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-23T22:35:56.670' ,`MLSNumber` = '472625' ,`ListAgentFullName` = 'Kimberly Whaley' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765409' ,`Longitude` = '-95.553105' ,`PhotoCount` = '11' ,`PostalCode` = '77024' ,`RoomCount` = '8' ,`ListPrice` = '1410000.00' ,`Status` = 'Active' ,`StreetName` = 'Wetherby Terrace' ,`StreetNumber` = '411' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNDER CONSTRUCTION! LAST REMAINING CORNER LOT! Memorial Green is a gated community of beautifully designed, luxury urban homes located in the heart of Memorial. Built by Pelican Builders, Inc., the Wetherby Terrace plan features beautiful exterior elevations, first-floor living, wood floors throughout living area, crown molding, high ceilings and outdoor living! 1st floor open-layout living with fireplace, dining and access to outdoor living; abundance of lights from wall of windows and french doors to patio. Gourmet kitchen features Bosch stainless steel appliances, quartz countertops and designer cabinetry. 2nd floor Primary suite with luxurious bath including soaking tub and walk-in shower, separate vanities and separate his&hers walk-in closets; Two secondary bedrooms with walk-in closets and jack and jill bath; utility room. 3rd floor oversized game room with full bath and space for upgraded wet bar. Elevator capable, two-car garage. BY APPOINTMENT ONLY.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = 'Pelican Builders Inc' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 3 MEMORIAL GREEN SEC 2 R/P & EXTN' ,`LotDesciption` = 'Corner,Patio Lot' ,`LotSize` = '2448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`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` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Green' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666592278' WHERE `Matrix_Unique_ID` = '204315952' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:24:06.863' ,`MLSNumber` = '46437670' ,`ListAgentFullName` = 'Willie Harris' ,`ListOfficeName` = 'Keyhole Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.188366' ,`Longitude` = '-96.275883' ,`PhotoCount` = '6' ,`PostalCode` = '77437' ,`RoomCount` = '6' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = '2nd' ,`StreetNumber` = '1004' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1461' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is a nice brick home. 3 bedrooms and 2 baths. Large lot.' ,`Acres` = '0.2204' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CHANDLER BLOCK 3 LOT 20,21' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9601' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chandler' ,`TaxAmount` = '3447' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592278' WHERE `Matrix_Unique_ID` = '205127539' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:38:23.883' ,`MLSNumber` = '7397497' ,`ListAgentFullName` = 'Michael Brombacher' ,`ListOfficeName` = 'Brombacher & Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717525' ,`Longitude` = '-95.420651' ,`PhotoCount` = '24' ,`PostalCode` = '77005' ,`RoomCount` = '7' ,`ListPrice` = '1880000.00' ,`Status` = 'Active' ,`StreetName` = 'Annapolis' ,`StreetNumber` = '6031' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3511' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6031 Annapolis! Another spectacular new construction by Laird Custom Homes features 4 bedrooms, 3.5 baths. Beautiful wide-plank oak floors throughout. Downstairs features an expansive family room overlooking the backyard, study, bar, and mudroom off the garage. Bright spacious kitchen includes Miele appliances, large Calacatta island, and walk-in pantry. Primary suite with vaulted ceilings, double vanities, oversized marble shower, and luxurious freestanding bathtub. Walk-in-closet-space galore (two of them in the primary bedroom)! Elevator capable and EV charging outlet in the garage. Located so close to Rice Village (where you can try a new restaurant every evening!) and a hop, skip, and jump to highly rated West U Elementary and Weir Park. AND so close to the Medical Center, Greenway Plaza, and Downtown. Builder and designer are finalizing selections, but there\'s still the opportunity to select your favorite finishes! Please inquire for more details.' ,`Acres` = '0.1148' ,`Area` = '17' ,`BuilderName` = 'Laird Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 3 VIRGINIA COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Virginia Court' ,`TaxAmount` = '13409' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666592278' WHERE `Matrix_Unique_ID` = '207239277' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:52:45.603' ,`MLSNumber` = '50623512' ,`ListAgentFullName` = 'Candace Petty' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = 'Stephen Farrell' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '29.817858' ,`Longitude` = '-95.456632' ,`PhotoCount` = '40' ,`PostalCode` = '77092' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Marlborough' ,`StreetNumber` = '4507' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '985' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price reduced !!!!!!!Fantastic updated 3 bedroom home in the Shepherd Forest Community with stunning open floor plan. Renovations include updated cabinets, granite countertops in kitchen, updates to plumbing & electrical, fresh paint inside and out, updated doors and double pane windows, dual sink in vanity in bathroom, restained hardwood floors, led recessed lighting and new light fixtures and ceiling fans along with fully fenced private backyard. This one has all the bells and whistles and is ready now for a new buyer. Light and bright Conveniently located near the Heights area, 610/290 Location Location!!!!!! Ten minutes from downtown. Unrestricted, No HOA This is truly an up and coming area. Never Flooded!!!!!' ,`Acres` = '0.1717' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 894 BLK 44 SHEPHERD FOREST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shepherd Forest Sec 03' ,`TaxAmount` = '5964' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592278' WHERE `Matrix_Unique_ID` = '207869891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:48:06.553' ,`MLSNumber` = '24989246' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.271567' ,`Longitude` = '-95.540668' ,`PhotoCount` = '42' ,`PostalCode` = '77316' ,`RoomCount` = '17' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Trophy Canyon' ,`StreetNumber` = '134' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller! Stunning front yard landscaping welcomes you to this beautiful all brick exterior home. Soak in the charming curb appeal paired with a 3 car attached garage! Step inside the airy foyer with meticulously maintained hard surface floors. Enjoy the office/study in the front of the home along with two bedrooms located on the first level. Massive 5 bedroom home and 4 bath offers ample space for comfortable living for everyone with the spacious floorplan and the second level Game Room plus Media Room! Entertain in the kitchen/living room combo. Expansive island opens up to the roomy breakfast area sizeable for a small kitchen table. Living room shines with natural light from the large windows and in the center a wood burning fireplace. Be impressed with the double vanities in the primary bath en suite, wide soaking tub and huge walk in closet. Outside covered patio provides shade understand while you\'re in the fully fenced backyard.' ,`Acres` = '0.2276' ,`Area` = '39' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S965249 - WOODFOREST 49, BLOCK 1, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9915' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 49' ,`TaxAmount` = '10262' ,`TaxRate` = '2.6888' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592279' WHERE `Matrix_Unique_ID` = '208328728' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:23:21.793' ,`MLSNumber` = '10711884' ,`ListAgentFullName` = 'Joe Wimberly' ,`ListOfficeName` = 'Lifestyles Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.370010' ,`Longitude` = '-94.975494' ,`PhotoCount` = '17' ,`PostalCode` = '77568' ,`RoomCount` = '6' ,`ListPrice` = '124900.00' ,`Status` = 'Active' ,`StreetName` = 'Roosevelt' ,`StreetNumber` = '1012' ,`StreetSuffix` = 'Street' ,`City` = 'La Marque' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t Miss this updated 3 Bedroom home in La Marque with a huge lot and tons of character!! 2019 New AC!! 2019 New Roof!! 2020 Sewer lines replaced and recent Vinyl Plank flooring just to name a few. A new range has been ordered and will be installed this week. The heavy lifting has been done and the home is ready for your finishing touches! Don\'t miss the virtual tour!' ,`Acres` = '0.1408' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 150 J D MOORE SUR LOT 17 STAFFORDS FIRST ADDN TO LAMARQ' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6135' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'WESTLAWN ELEMENTARY SCHOOL (LA MARQUE)' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stafford 1' ,`TaxAmount` = '2666' ,`TaxRate` = '2.6428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592279' WHERE `Matrix_Unique_ID` = '208539273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:06:22.143' ,`MLSNumber` = '58753507' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480179' ,`Longitude` = '-94.942005' ,`PhotoCount` = '48' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = '23rd Street' ,`StreetNumber` = '1311' ,`StreetSuffix` = 'Street' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1651' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the newest homes in the Edwards Landing Subdivision! This canal-front home is very close to Galveston Bay and features multiple decks for you to relax and breathe in the fresh, ocean air. Home was recently remodeled for improved functionality and beautiful style. Schedule your appointment today!' ,`Acres` = '0.159' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 10 A EDWARDS SUR LOT 31 & PT ADJ CANAL EDWARDS LANDING' ,`LotDesciption` = 'Other' ,`LotSize` = '6926' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Edwards Landing' ,`TaxAmount` = '7064' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592279' WHERE `Matrix_Unique_ID` = '208848968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:06:03.130' ,`MLSNumber` = '48861327' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.231443' ,`Longitude` = '-94.893016' ,`PhotoCount` = '49' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '1110000.00' ,`Status` = 'Active' ,`StreetName` = 'Sea Butterfly' ,`StreetNumber` = '11606' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home in Beachside Village offers functionality, style, and relaxation at every turn! Boasting 3 decks, high ceilings, an open floorplan for the living/dining/kitchen and being sold fully furnished, it is the perfect home for gathering with family and friends. The first floor features the open concept living and kitchen space plus 2 bedrooms (one bedroom which contains tucked-away built-in bunks!). The second level is home to an additional bedroom plus the primary suite. The primary suite is truly a home-owner\'s retreat with a private deck, large bath with both shower and soaking tub, and sizable closet space. The third level contains the 5th bedroom plus an additional porch for taking in the fresh, ocean breeze. You will enjoy the quick and easy walk to the beach via neighborhood streets and beach access points. This home is perfect as a full-time residence or weekend getaway and has a strong rental history. Schedule your appointment today!' ,`Acres` = '0.0905' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BEACHSIDE VILLAGE SEC 3 (2014) ABST 121, LOT 210, ACRES 0.09' ,`LotDesciption` = 'Other' ,`LotSize` = '3943' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Other Style,Victorian' ,`Subdivision` = 'Beachside Village Sec 3 2014' ,`TaxAmount` = '13556' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592279' WHERE `Matrix_Unique_ID` = '208862657' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:05:40.913' ,`MLSNumber` = '84932509' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.264071' ,`Longitude` = '-94.895704' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '759000.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Pointe' ,`StreetNumber` = '1615' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely beautiful bayside home within the tranquil and conveniently located neighborhood of Sweetwater Cove. This home is stunning at every turn and offers exceptional living space for gathering with family and friends. Enjoy the coastal breezes from one of the outdoor decks or move indoors for family game nights in the open living/dining/kitchen space. The home offers 4 BEDROOMS WITH EN-SUITE BATHS (including a built-in bunk room) which provides ample bedroom space for sleeping large families or the ability to transform a bedroom or two into multi-functional space. The home\'s covered ground level also offers additional space for outdoor living. The home also has a STRONG RENTAL HISTORY for those considering investment properties. Schedule your appointment today to see this incredibly beautiful home!' ,`Acres` = '0.1367' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 4 BLK 7 SWEETWATER COVE SEC 1 (2007) ABST 121 AKA TR IV' ,`LotDesciption` = 'Water View' ,`LotSize` = '5956' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Craftsman,Other Style,Traditional' ,`Subdivision` = 'Sweetwater Cove Sec 1 2007' ,`TaxAmount` = '8497' ,`TaxRate` = '2.9624' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592279' WHERE `Matrix_Unique_ID` = '208930944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:05:20.430' ,`MLSNumber` = '94938979' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.143524' ,`Longitude` = '-95.049629' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Matagorda' ,`StreetNumber` = '21902' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your cozy canal cottage in SEA ISLE. This home is perfect for those wanting to relax with the sound of ocean waters drifting through the canal or those interested in docking their boat at the home\'s BOAT SLIP for convenient fishing trips. The large deck is also the perfect place to fish directly from the home! This 3BR/2-3BA home has 2 BR/1BA upstairs and 1BR/1BA downstairs. There is also an additional, unlisted bath/plumbing setup in the garage. Ground floor square footage is estimated at approximately 600 square feet with slightly over 800 square feet on the second/primary floor. Upstairs features an open living, dining, kitchen space directly next to the bedrooms for easy flow into each room. The Sea Isle community is also packed with added features including a community fishing pier, swimming pool, tennis court, and park/picnic pavilion. This home has a STRONG RENTAL HISTORY. Schedule your showing today!' ,`Acres` = '0.1449' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 15 LOT 1617 SEA ISLE 4TH EXTENSION' ,`LotDesciption` = 'Other,Water View,Waterfront' ,`LotSize` = '6312' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sea Isle Ext 4' ,`TaxAmount` = '6951' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592279' WHERE `Matrix_Unique_ID` = '208999409' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:04:54.583' ,`MLSNumber` = '47659076' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.310626' ,`Longitude` = '-94.762181' ,`PhotoCount` = '44' ,`PostalCode` = '77550' ,`RoomCount` = '8' ,`ListPrice` = '1440000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Beach' ,`StreetNumber` = '68' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2977' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your beachside getaway on Galveston\'s East End. Awake to enjoy the sunrise from one of the several available decks (including private deck off primary bedroom), take a walk to the beach via the access point that is very near, and spend time with family and friends in the open concept living spaces! This home has it all - ample sleeping space with 4 TO 5 BEDROOMS, 3.5 baths (2 en-suite), a flex family/additional bedroom on the top floor, and an elevator that accesses multiple levels of the home! The 1st floor\'s living/kitchen/dining spaces flow together for easy gathering and the kitchen provides a breakfast bar for built-in dining options. Natural light greets you in all of the living spaces, and this is accompanied by water views from the kitchen, dining, and living spaces. Fort those considering investment properties, this home also has a STRONG RENTAL HISTORY. Schedule your appointment today to see this stunning home!' ,`Acres` = '0.2056' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East Beach' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE PRESERVE AT GRAND BEACH (2014) ABST 628, BLOCK 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8954' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'The Preserve At Grand Beach 2' ,`TaxAmount` = '17046' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592280' WHERE `Matrix_Unique_ID` = '208999851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:16:17.663' ,`MLSNumber` = '20051684' ,`ListAgentFullName` = 'Crystal Mason' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.847268' ,`Longitude` = '-95.423001' ,`PhotoCount` = '25' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Knox' ,`StreetNumber` = '6728' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction located in the Acres Homes Community. 3bedroom, 2 bathroom, covered back porch w/just enough backyard space, and a spacious 1-car garage ! Completion is approximately July1st… Come by and see this beauty… Let’s make this your new home today!' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = 'Kensli Homes LLC' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 17 BLK 25 HIGHLAND HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Heights' ,`TaxAmount` = '1154' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666592280' WHERE `Matrix_Unique_ID` = '209003517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:04:33.977' ,`MLSNumber` = '91829171' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.140503' ,`Longitude` = '-95.042571' ,`PhotoCount` = '27' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Zachary' ,`StreetNumber` = '21623' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to one of the most desirable streets in Sea Isle where you can listen to and watch the waves roll in from the giant beach-view deck! This home has beautiful updated finishings that make it move-in ready, and has a STRONG RENTAL HISTORY for those considering investment properties. The first floor game room is the perfect entertainment space for kiddos and is conveniently located next to two first floor bedrooms. The 2nd floor features 2 additional bedrooms (including primary) plus a combo living/dining space that easily flows into the kitchen. The Sea Isle community is packed with added features including a community fishing pier, park and picnic pavilion, swimming pool, and tennis court! HOME TO CONVEY FULLY FURNISHED. Schedule your appointment to see this cozy beachview cottage today!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 19 LOT 140 SEA ISLE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '225' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Sea Isle Orig' ,`TaxAmount` = '4553' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592280' WHERE `Matrix_Unique_ID` = '209088875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:04:14.023' ,`MLSNumber` = '82939379' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.204116' ,`Longitude` = '-94.934543' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '1780000.00' ,`Status` = 'Active' ,`StreetName` = 'Buccaneer' ,`StreetNumber` = '4219' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '3116' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to beachfront living in PIRATES BEACH! Take in the warm ocean breeze from the expansive balcony overlooking the waves or venture out for an easy stroll in the sand...just steps away from your front door. This beautiful home is the perfect beach getaway featuring an inverted floor plan, elevator, elevated ceilings, large bedrooms, and an expansive and welcoming 3rd floor gathering space that combines the kitchen, dining room, and living room. There are multiple decks for outdoor living space which makes entertaining large groups easy and fun. \r\n This home also has a STRONG RENTAL HISTORY for those interested in investment opportunities. Contact agent to schedule your showing today.' ,`Acres` = '0.1389' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 12 BLK 6 PIRATES BEACH SEC 2' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Beach 2' ,`TaxAmount` = '17885' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592280' WHERE `Matrix_Unique_ID` = '209797139' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:03:54.290' ,`MLSNumber` = '57081585' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.225025' ,`Longitude` = '-94.935652' ,`PhotoCount` = '38' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '870000.00' ,`Status` = 'Active' ,`StreetName` = 'Road Less Traveled' ,`StreetNumber` = '3122' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2652' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This incredible home is the perfect place to relax on the water. Perfectly situated on Eckert Bayou with a private pier, enjoy all the benefits waterfront living has to offer. The driveway is large enough to park your boat, and the home is only 3 minutes from Waterman\'s Marina if you prefer a boat slip. The beautiful porches are the perfect place to watch the sunset, and the interior home is open and welcoming for entertaining/gathering with family and friends. There are living spaces on both floors and ample sleeping accommodations with 4 bedrooms. Home has STRONG RENTAL HISTORY for those interested in investment opportunities. Contact agent to schedule your showing today.' ,`Acres` = '0.1573' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GALVESTON BAY CLUB PARTIAL RPLT (2014), ABST 121, BLOCK 1, L' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6851' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,English,Other Style,Traditional' ,`Subdivision` = 'Galveston Bay Club 2000,' ,`TaxAmount` = '13414' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592280' WHERE `Matrix_Unique_ID` = '209797837' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:03:26.897' ,`MLSNumber` = '33077615' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.306460' ,`Longitude` = '-94.780008' ,`PhotoCount` = '45' ,`PostalCode` = '77550' ,`RoomCount` = '7' ,`ListPrice` = '715000.00' ,`Status` = 'Active' ,`StreetName` = 'Winnie' ,`StreetNumber` = '1120' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3028' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely stunning Victorian home in the East End Historical District. This home offers a unique investment opportunity given the main home is approximately 2,128 sqft plus 2 GARAGE APARTMENTS (900 sqft) that can provide additional income, extra sleeping space for additional guests, or be utilized for multi-purpose space. Enjoy the sunset from one of the two beautiful porches overlooking the park or relax in the stunningly beautiful interior featuring high ceilings, large rooms, and plenty of natural light. Each garage apartment is 1 bed/1 bath with kitchen and living space, and the garage apartment entry is separated by a fence between the garage and main home\'s backyard. Truly a great opportunity for owner to live in the main home and rent the apartments. Contact agent to schedule your showing today!' ,`Acres` = '0.0888' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR W 1/2 OF LOT 12 & E 10-8.5 FT OF LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3870' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '8905' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1887' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592281' WHERE `Matrix_Unique_ID` = '209798064' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:17:53.073' ,`MLSNumber` = '65367535' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.758938' ,`Longitude` = '-95.790872' ,`PhotoCount` = '36' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '685000.00' ,`Status` = 'Active' ,`StreetName` = 'Saddlebrook' ,`StreetNumber` = '2806' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Incredibly spacious brick home situated on a gorgeous lot with mature trees. Conveniently close to I-10, TX-99, Falcon Point Park, Costco, and all of your shopping needs! 4 bedrooms/2.1 baths. So many different spaces to suite a variety of needs- a great room w/ fireplace, living room, family room, den, and a game room! Gorgeous tile and wood flooring throughout, crown molding, and recessed lighting. The beautiful primary suite boasts an attached sitting room, vaulted ceiling, 2 walk-in closets, dual vanity, and large walk-in shower. Huge loft/storage area upstairs. Dreamy gourmet kitchen featuring an electric cooktop on the island, a wall oven, stainless steel appliances, granite countertops and a walk-in pantry. The backyard space is perfect for relaxing, dining or entertaining and boasts a covered patio, jacuzzi, and a luscious green lawn.' ,`Acres` = '1' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = '0262 I AND GN RY, TRACT 3 & (N 1/2) PARCEL 45, ACRES 1.00, S' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RYLANDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'I & Gn Ry' ,`TaxAmount` = '11700' ,`TaxRate` = '1.9045' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592281' WHERE `Matrix_Unique_ID` = '209891101' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:25:16.423' ,`MLSNumber` = '6234408' ,`ListAgentFullName` = 'Patricia Rivera' ,`ListOfficeName` = 'Cornerstone Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.169640' ,`Longitude` = '-95.632835' ,`PhotoCount` = '39' ,`PostalCode` = '77486' ,`RoomCount` = '9' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadows' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1954' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully designed NEWLY CONSTRUCTED home in the Columbia Lakes Subdivision. This home features enhanced upgrades which include: Smart Home audio; farmhouse sinks w/custom faucets; pot filler above stove; custom front door; oversized windows; panoramic electric fireplace; free standing soaking tub; 11\' foot ceilings; Hard ^ stone exterior; 6\" wood baseboards; quartz countertops; and custom tile throughout. Other features include: LED recessed lights, open concept, split bedrooms, oversized custom master shower, self closing cabinets, SS appliances, and covered patio. Columbia Lakes Subdivision NEVER FLOODED. UNDER CONSTRUCTION. Estimated Completion date: JANUARY 2023. PICTURES ARE FROM BUILDERS STOCK AND ONLY FOR REFERENCE. SQUARE FEET IS APPROXIMATE. OPTIONAL UPGRADES AVAILABLE.' ,`Acres` = '0.2112' ,`Area` = '5' ,`BuilderName` = 'HomeStar Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 3 (A0133 M VARNER) BLK 31 LOT 73' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '9200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '105' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '279' ,`TaxRate` = '2.2487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666592281' WHERE `Matrix_Unique_ID` = '210107245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:42:23.857' ,`MLSNumber` = '69663686' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.699001' ,`Longitude` = '-95.834156' ,`PhotoCount` = '30' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Virginia Fields' ,`StreetNumber` = '6427' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3888' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Gorgeous brick home situated on a beautifully landscaped lot and shaded by mature trees! Conveniently close to TX-99, I-10, and just minutes away from all of your shopping and dining needs. Ample space throughout this two story, 4 bed/2.1 bath home, including a large game room, a media room, and a study! High ceilings, crown molding, and tons of natural light. Enjoy the beauty and ease of maintaining wood floors throughout the study, dining, living, and primary bedroom. Cook your meals in an open, island kitchen featuring granite countertops, stainless steel appliances, tile backsplash, and tons of storage. The primary bedroom of your dreams awaits you, complete with a large walk-in closet, soaking tub, dual vanities, and a separate walk-in shower. Enjoy warm Texas days relaxing on the covered patio in the fully-fenced backyard!' ,`Acres` = '0.1791' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTHEIMER LAKES NORTH SEC 1, BLOCK 3, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '855' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SHAFER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'SEVEN LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westheimer Lakes North Sec 1' ,`TaxAmount` = '9683' ,`TaxRate` = '2.6345' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592281' WHERE `Matrix_Unique_ID` = '210292368' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:03:05.337' ,`MLSNumber` = '90691171' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.137666' ,`Longitude` = '-95.063146' ,`PhotoCount` = '49' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '1350000.00' ,`Status` = 'Active' ,`StreetName` = 'Sabrina' ,`StreetNumber` = '3719' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3305' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Views! Views! Views! This home has the most incredible and ENDLESS WATERFRONT VIEWS. Perfect for entertaining, this property features large, open gathering spaces including a combined kitchen/dining/living space on the main floor and has multiple, large bedrooms for sleeping large groups. With two wood-burning fireplaces, crown molding, high ceilings, ample windows bringing in natural light and bayfront views, this home also has warm touches that make the large spaces feel relaxed and inviting. The primary suite is truly a retreat with extra privacy on the home\'s top floor. The outdoor space features multiple patios and deck spaces including a personal boat dock for quick, convenient boat access as well as space to fish, swim, and enjoy water activities directly from the property. This is the perfect year-round getaway! The neighborhood comes with additional perks such as access to a small beach area and community pool. Strong Rental History is also noted by sellers.' ,`Acres` = '0.1132' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 8 TERRAMAR BEACH SEC 6 REPLAT' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '4930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Terramar Beach Sec 6 Rep' ,`TaxAmount` = '15561' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592281' WHERE `Matrix_Unique_ID` = '210326777' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:38:22.983' ,`MLSNumber` = '20128833' ,`ListAgentFullName` = 'Mari Lasewicz' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075569' ,`Longitude` = '-95.196430' ,`PhotoCount` = '43' ,`PostalCode` = '77339' ,`RoomCount` = '9' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Beaver Glen' ,`StreetNumber` = '3126' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 bedroom, 2 and 1/2 Bath. Master down Crown Molding throughout home. Hardwood floors, Surround sound wiring inside and out. Outdoor kitchen and Covered patio. Pool, Hot tub and waterfall. One of the bedrooms is currently set up as a workout/yoga room and another bedroom has been converted into a soundproof movie room. So many extras. Must see.' ,`Acres` = '0.1708' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 10 ELM GROVE VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7442' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '485' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Elm Grove Village Sec 02' ,`TaxAmount` = '5463' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592281' WHERE `Matrix_Unique_ID` = '210370413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:02:36.853' ,`MLSNumber` = '72220622' ,`ListAgentFullName` = 'Hilary Griffin' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.224240' ,`Longitude` = '-94.935639' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '1095000.00' ,`Status` = 'Active' ,`StreetName` = 'Road Less Traveled' ,`StreetNumber` = '3218' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Relax and breathe in the ocean breeze from this stunning bayfront property. The home\'s well-appointed design features and decor make it feel warm and inviting while its spacious rooms, ELEVATOR access, and well-designed floor plans also make it the perfect space for hosting and sleeping large parties. Featuring a large combo living room/kitchen, 4 bedrooms (plus an additional, BUILT-IN BUNKROOM), 4.5 baths, 3 covered decks, covered ground-floor patio/FLEX SPACE, green space, and access to the neighborhood piers directly from the home\'s boardwalk, you will have plenty of places to relax, sleep, entertain, and make it yours! Several nearby marinas are available for convenient boat storage/access, and the driveway also has enough space for you to park your boat directly under the home (Waterman\'s Marina is 3 minutes away). Sellers also report strong rental history for those interested in using as an investment property. Contact agent to schedule your showing!' ,`Acres` = '0.2064' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GALVESTON BAY CLUB PARTIAL RPLT (2014), ABST 121, BLOCK 1, L' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Galveston Bay Club 2000,' ,`TaxAmount` = '14735' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592282' WHERE `Matrix_Unique_ID` = '210885106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:27:40.363' ,`MLSNumber` = '87845764' ,`ListAgentFullName` = 'Melissa Castro' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.272021' ,`Longitude` = '-94.823209' ,`PhotoCount` = '21' ,`PostalCode` = '77551' ,`RoomCount` = '12' ,`ListPrice` = '459990.00' ,`Status` = 'Active' ,`StreetName` = 'Ibis' ,`StreetNumber` = '5520' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention Investors and Galveston lovers alike! This 5 bedroom & THREE FULL bath is PRIME location for short term rentals or vacation home. Home boasts of an open concept, over-sized living area, tier 3 granite, flex room that can be used as movie room, formal dining, office space, or whatever your heart desires and TWO en-suites. \r\n A true diamond in the rough, come check out for yourself the beautifully crafted kitchen with large island facing the spacious living and dining area. All bedrooms are a generous size. Centrally located to grocery stores, shopping, and dining, this home is in pristine condition and turnkey ready. Pleasure pier, Moody Gardens, tours of Galveston’s rich history, and beach day memories are minutes away. Contact Agent for a private showing now to see this Galveston gem!' ,`Acres` = '0.184' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 PAGE 102 LOT 56 SURFSIDE SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '5111' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1666592282' WHERE `Matrix_Unique_ID` = '211132429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:00:36.340' ,`MLSNumber` = '46788699' ,`ListAgentFullName` = 'Christina DeLaTorre' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.656084' ,`Longitude` = '-95.483886' ,`PhotoCount` = '21' ,`PostalCode` = '77035' ,`RoomCount` = '7' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Warm Springs' ,`StreetNumber` = '5531' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 5531 Warm Springs! You will not be disappointed in this charming 4-bedroom home located in the Westbury community. There\'s optimal space throughout. The kitchen is open to the formal dining area making it ideal for friends/family gatherings. Laminate flooring flows throughout the living, dining, kitchen and breakfast area. New carpet in all bedrooms. New tile surround and tile flooring in bathrooms. New shaker style cabinetry. Granite counter tops. New lighting package and ceiling fans in all rooms. Spacious backyard with plenty of room for a pool. Hager Park is next to Anderson Elementary and a SPARK playground is being installed and will be available for community use on weekends and after school hours. Westbury Park is 3 min. away on Mullins Dr. Park features include playgrounds, basketball court, picnic tables, pool & baseball/football field, walking trail. Only minutes to Medical Center, NRG, Galleria and Downtown. Overall, great family friendly community! NO FLOODING.' ,`Acres` = '0.1928' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 58 WESTBURY SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 03' ,`TaxAmount` = '4272' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592282' WHERE `Matrix_Unique_ID` = '211282078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:08:45.660' ,`MLSNumber` = '9503435' ,`ListAgentFullName` = 'Jeffrey Lutz' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.321446' ,`Longitude` = '-95.607781' ,`PhotoCount` = '50' ,`PostalCode` = '77430' ,`RoomCount` = '12' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Oak' ,`StreetNumber` = '20405' ,`StreetSuffix` = 'Lane' ,`City` = 'Damon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2189' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COUNTRY LIVING at its best. Come see why living in this great little acreage community is so great. Homes do not come up for sale very often in this community, so hurry before it is too late. This one story custom ranch home is located on +/- 2.08 acres. The open concept home was simply before its time. The massive family room is open to the kitchen and offers a big formal dining or home office right at the front door. The kitchen has tons of counter tops, nice granite and loads of cabinets. The combined breakfast area is perfect for that morning coffee. There is a huge utility/mud room off the kitchen. The bedrooms are all of good size with one being perfect for a nursery or craft room. There is a covered back porch inside a fence yard . There is a two car carport, and three car garage with a one garage bay converted to a workshop. The property is loaded with nice trees. a pond and tons of nature all around you. Watch the deer walk across your property on a regular basis. HURRY HURRY.' ,`Acres` = '2.08' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A0003 THOS ALLSBERRY TRACT 42 TR 23C (PECAN BEND SOUTH UNREC' ,`LotDesciption` = 'Wooded' ,`LotSize` = '90605' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '35' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Thos Allsberry' ,`TaxAmount` = '3401' ,`TaxRate` = '1.6563' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592282' WHERE `Matrix_Unique_ID` = '211332635' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:16:59.253' ,`MLSNumber` = '56034718' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483136' ,`Longitude` = '-95.365847' ,`PhotoCount` = '49' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle' ,`StreetNumber` = '6703' ,`StreetSuffix` = 'Run' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Pristine single-story home on a corner lot in Lakeland! Massive 840sqft. 4-car garage with walkable barn loft above, don\'t miss out! Outside you\'ll enjoy a spacious backyard fitted with a covered patio.Close to schools, and easy access to HWY 6. Elegant details throughout will impress from the moment you enter- crown molding, arched windows, built-ins, and more! Extra study room with glass French doors. Lovely living room space with a fireplace.The sparkling kitchen boasts an island, granite countertops, tons of storage and recessed lighting. The primary suite feels massive and features a tray ceiling, large windows, a huge walk-in closet, soaking tub, and separate shower. Clean and move-in ready!' ,`Acres` = '0.2532' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKELAND SD SEC 2 (A0283/A0483 HT&BRR) (MANVEL) BLK 3 LOT 8' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11029' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeland SD Sec 2' ,`TaxAmount` = '11230' ,`TaxRate` = '3.5974' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592282' WHERE `Matrix_Unique_ID` = '211581801' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:54:08.800' ,`MLSNumber` = '74286801' ,`ListAgentFullName` = 'Britni Haley' ,`ListOfficeName` = 'Britni Haley' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.944993' ,`Longitude` = '-95.298031' ,`PhotoCount` = '21' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '238900.00' ,`Status` = 'Active' ,`StreetName` = 'Texas' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beach cottage will make the perfect primary home, investment property, or vacation getaway! Take your vision and make it a reality, priced with interior updates in mind! It has great indoor and outdoor living spaces to enjoy after a long day at the beach. The expanded deck gives you plenty of room to spread out and soak up the views of the Gulf, the large ships coming into port, stunning sunsets over the intracoastal, wetlands full of wildlife, and the Surfside bridge. This quiet part of the village offers tranquil beachside living with a short walk to the beach, boat ramp, jetty park, Ft. Velasco museum, bird & butterfly trail, splash pad, restaurants, and more!! Enter from the deck to the open living area. The master suite is to the right of the living room, while the guest bedroom and bathroom are to the right. Currently occupied, so be sure to call ahead.' ,`Acres` = '0.1478' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE BLK 550 LOT 9 (A0051 F J CALVIT)' ,`LotDesciption` = 'Water View' ,`LotSize` = '6438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '2399' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592283' WHERE `Matrix_Unique_ID` = '211659600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:01:36.917' ,`MLSNumber` = '79896925' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.171014' ,`Longitude` = '-95.194826' ,`PhotoCount` = '30' ,`PostalCode` = '77357' ,`RoomCount` = '11' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Banks Mill' ,`StreetNumber` = '23490' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2753' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on Market. This residence will impress form the moment you enter w/ soaring ceilings, art niches, & tons of natural light. 5 bedrooms, 3.1 baths & a loft/game room upstairs! Fresh paint, steamed carpets, & refreshed landscaping make this home ready for new owners. Hard surface flooring throughout the main level is a breeze to maintain while all bedrooms have soft carpeting underfoot. Both formal & informal dining spaces. Large living room is a great space to relax or entertain guests. The kitchen checks all of the boxes- stainless steel appliances, granite countertops, recessed lighting, & a walk-in pantry. The primary bedroom is the only bedroom downstairs which makes for optimal privacy & features a walk-in closet, soaking tub, & separate shower. Enjoy outdoor activities or relax on the covered patio in the fenced backyard! Community is nestled close to greenbelt trails, lakes, & amazing views. Easy access to US 69. Click the Virtual Tour link for a 3D walkthrough.' ,`Acres` = '0.1377' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S921108 - TAVOLA 08, BLOCK 3, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola 08' ,`TaxAmount` = '8202' ,`TaxRate` = '3.3731' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592283' WHERE `Matrix_Unique_ID` = '211702715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:12:05.040' ,`MLSNumber` = '96876107' ,`ListAgentFullName` = 'Anthony Hines' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Anthony Hines' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '28.945140' ,`Longitude` = '-95.362762' ,`PhotoCount` = '21' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '129000.00' ,`Status` = 'Option Pending' ,`StreetName` = '12th' ,`StreetNumber` = '1027' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Seller is offering $$7k to buyer in seller concessions, Great opportunity for a Buyer to get into a home with little too no money out of pocket. This 3 bedroom 1 bath is ready for its next owner. The home has been equipped with new floors and paint through out and some updates to the kitchen and other areas. The Home sits on a very spacious corner lot with a front drive way giving quick and easy access to the front door. Enjoy extra storage space with a shed in the back yard that can be converted into a workshop or whatever the new home owner can imagine. Don\'t wait and see for yourself and schedule a showing.' ,`Acres` = '0.1469' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTH VIEW GARDENS (FREEPORT) BLK 9 LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'South View Gardens Freeport' ,`TaxAmount` = '2410' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592283' WHERE `Matrix_Unique_ID` = '211802994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:06:14.950' ,`MLSNumber` = '23038732' ,`ListAgentFullName` = 'Jeffrey Lutz' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746801' ,`Longitude` = '-95.876978' ,`PhotoCount` = '46' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Jarvis Bay' ,`StreetNumber` = '29410' ,`StreetSuffix` = 'Pass' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ORIGINAL OWNER, TRUE PRIDE OF OWNERSHIP. Lovely and perfectly maintained home in desired community. This fabulous one story offers +/- 2094 Sqft with a wonderful and open concept. Step in the front door and you will be amazed how open and large the family space is. From the spacious and beautiful kitchen with rich granite and stainless appliances, tons of cabinets, plus a big island that looks out onto the open dining and family room. All the family space is done in large ceramic tile through all traffic areas. High ceilings and lots of windows make it all come together. Then step right out on to the huge concrete patio with paver stone finish, stretching across the entire back of the home. Back inside you find the primary en-suite tucked in the back corner of the home, with oversized shower, double sinks and dream size walk in closet. There are three other bedrooms, one of which could easily be used as a home office or play room. The front Two bedrooms feature a bath between them.' ,`Acres` = '0.1446' ,`Area` = '30' ,`BuilderName` = 'Dr Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 30, BLOCK 2, LOT 45' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron Sec 30' ,`TaxAmount` = '7699' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592283' WHERE `Matrix_Unique_ID` = '211925970' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:08:03.197' ,`MLSNumber` = '71751204' ,`ListAgentFullName` = 'Jeffrey Lutz' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796082' ,`Longitude` = '-95.683004' ,`PhotoCount` = '50' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '297900.00' ,`Status` = 'Active' ,`StreetName` = 'Pepperwood' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION LOCATION LOCATION! Wonderfully updated and nice home, in a small pocket size community with excellent access to IH 10. This lovely three bedroom home features beautiful wood look tile in the family, dining, kitchen and hallways. There is modern nice tile in the baths, with carpet in the bedrooms only. This spacious home offers lots of natural light, huge family room with cozy wood burning fireplace, vaulted ceilings, big kitchen with connecting dining area on one side and breakfast on the other other. The kitchen is well appointed with wonderful granite tops, stainless appliances, painted real wood cabinets, big and spacious with sink window to driveway and side door. The primary bedroom is tucked away in the back with nicely redone en-suite, featuring double sinks, modern shower, granite lavatory, and two closets. The secondary bedrooms are both spacious and offer a nice hall bath with double sinks, and separate toilet and tub room. There is also an indoor utility closet.' ,`Acres` = '0.1641' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 69 BLK 3 MAYDE CREEK FARMS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mayde Creek Farms Sec 01' ,`TaxAmount` = '5290' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592283' WHERE `Matrix_Unique_ID` = '212080495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:07:02.077' ,`MLSNumber` = '50088865' ,`ListAgentFullName` = 'Elizabeth Cencini' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811869' ,`Longitude` = '-95.759922' ,`PhotoCount` = '48' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '359500.00' ,`Status` = 'Active' ,`StreetName` = 'Whitetip' ,`StreetNumber` = '2623' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2149' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home in the beautiful community of the Lakes at Mason Park. Home is almost like new! As you enter you will be greated with majestic ceilings at the entry, all bedrooms are located upstairs and a bonus spacious gameroom overlooks the entire entryway. This home has a spacious entry that takes you straight into a kitchen/ family room combination. Enjoy the beautiful granite countertops and stainless steel appliances and a breakfast area near the bay windows facing your backyard. Refrigerator, washer dryer is optional with purchase. The patio is beautifully done with a sandbox and fire pit! The backyard also features a covered porch with lighting on the cement/wood flooring to lighten up the space at night. Your first floor also features a fireplace, half bath for your guest and a utility room next to your garage entrance. Need one more bedroom? The gameroom has a big enough space to be converted. Zoned to Katy ISD!' ,`Acres` = '0.1263' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 1 LAKES AT MASON PARK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MORTON RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes at Mason Park' ,`TaxAmount` = '6539' ,`TaxRate` = '2.8233' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592284' WHERE `Matrix_Unique_ID` = '212086309' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:48:36.020' ,`MLSNumber` = '52092614' ,`ListAgentFullName` = 'Jesse Castro' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.031179' ,`Longitude` = '-95.576063' ,`PhotoCount` = '33' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Madisons Crossing' ,`StreetNumber` = '18322' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1751' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom, 2 bath w/ private office in Memorial springs. From the moment you walk you will want to make this home yours! Totally repainted interior in a smooth neutral color and completely repainted exterior as well. Roof only 6.5 years old! Super high ceilings. Sparkling new stainless steel appliances. NO CARPET! Kitchen, dining, office and hallways are laid in large format ceramic tile and all 3 bedrooms are laid in laminate flooring, perfect and super easy to clean for our pet lovers, not to mention, the new light fixtures add a nice modern touch. The sprinkler system makes maintaining your green lush lawn in the hot summer months effortless. Move to Memorial springs and enjoy the community pool, lake with multiple paved walking trails a very short walking distance away. Ask your agent to schedule your showing today!' ,`Acres` = '0.1263' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 1 MEMORIAL SPRINGS SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Spgs Sec 10' ,`TaxAmount` = '5007' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592284' WHERE `Matrix_Unique_ID` = '212166963' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:56:06.033' ,`MLSNumber` = '86060076' ,`ListAgentFullName` = 'Dennis Martinez' ,`ListOfficeName` = 'Alchemist Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685551' ,`Longitude` = '-95.371571' ,`PhotoCount` = '11' ,`PostalCode` = '77021' ,`RoomCount` = '1' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Noah' ,`StreetNumber` = '3570' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '5160' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lt 13, Blk 2 South End Sunnyside U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHIDBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South End Sunnyside' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592284' WHERE `Matrix_Unique_ID` = '212169820' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:36:22.953' ,`MLSNumber` = '94940364' ,`ListAgentFullName` = 'Yanling Teng' ,`ListOfficeName` = 'Great Wall Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.575701' ,`Longitude` = '-95.596531' ,`PhotoCount` = '21' ,`PostalCode` = '77479' ,`RoomCount` = '3' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Battle Ridge' ,`StreetNumber` = '3110' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HIGHLY DEMANDED AND DESIRABLE LOCATION! QUIET NICE NEIGHBORHOOD! POOL! GREAT SCHOOLS! CONVENIENT! Easy to Fwy59 and Hwy6. Fantastic education system, Clement High School! \r\nLOW TAX RATE 2.16! NEVER FLOODED! \r\nThe house has been very TASTEFULLY DESIGNED AND REMODELED with high quality material multiple times. August 2022. NEW laminated floors. With tiles for kitchen and bathrooms, NO carpet. NEW swimming pool filter; NEW lighting fixtures and sink faucet in kitchen; NEW bedroom door and closet door. NEW paint for the walls, ceilings, cabinets, doors, windows trims, baseboard and crown mouldings. AC May 2021; gas stove July 2021; The extra storage cabinet and epoxy surfaced floor 2019 added value to the garage. \r\nLike a pool table in the the game room or watching a movie in the home theater? The home office with built- in shelves and cabinets for you to handle important documents. \r\n\r\nA cozy, nice, sweet home to build up good lives and memories.\r\n\r\nSELL AS IS.' ,`Acres` = '0.1647' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SETTLERS GROVE SEC 1, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7174' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Grove' ,`TaxAmount` = '5737' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592284' WHERE `Matrix_Unique_ID` = '212206347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:35:04.570' ,`MLSNumber` = '76364221' ,`ListAgentFullName` = 'Cathy Carter' ,`ListOfficeName` = 'Carter Signature Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.946471' ,`Longitude` = '-95.295190' ,`PhotoCount` = '34' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'Seabean' ,`StreetNumber` = '445' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This surfside home has open floorplan with upgraded flooring, and extended deck for entertaining friends and family. You will love the updated kitchen with quartz countertops, induction range with air fryer, undercabinet lighting, freshly installed cabinets, upgraded lighting fixtures, and home water filtration system. After a long day at the beach, relax and stay cool with recently installed AC, and shower in one of 2 baths with the tankless water-heater. Your furry family members will have room to play with access to multiple fenced areas and the concrete pad with asphalt drive is a great place to park your beach toys or hang a hammock for an afternoon nap in the shade. Looking to store your beach toys.... there are 2, the louvered storage on concrete pad and 2nd storage bldg in the backyard surrounded by chain-link fenced yard. Upgraded wiring on the ground floor. View the back deck sunsets and live your best beach life!!' ,`Acres` = '0.18' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GULF RIDGE (A0051 F J CALVIT TR G) BLK 1 LOT 10-10A SURFSIDE' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '7841' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Gulf Ridge' ,`TaxAmount` = '5667' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592284' WHERE `Matrix_Unique_ID` = '212351717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:58:30.623' ,`MLSNumber` = '90698615' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.134714' ,`Longitude` = '-95.393460' ,`PhotoCount` = '30' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Ellscott' ,`StreetNumber` = '3215' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4203' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Located on a corner lot within a gated community awaits your dream home! This stunning two-story brick residence offers over 4000 square feet of living space. Spacious bedrooms, multiple living and dining areas - the options are endless. 5 full bedrooms plus an office that could also flex as a bedroom. Relish in the soaring high ceilings and fresh neutral interiors. All areas with carpet are replaced brand new and a full interior repaint recently completed. Private primary suite on the main level boasts tray ceiling, sitting area, garden tub, separate shower and walk-in closet. Upstairs features both media and game rooms, four bedrooms, and two full bathrooms. Community amenities include splash pad, pools, tennis courts, and walking trails. Conveniently located near 45 and 99. You don\'t want to miss out on this one!' ,`Acres` = '0.221' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S328404 - CANYON LAKES AT LEGENDS RANCH 04, BLOCK 5, LOT 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lakes At Legends Ranch' ,`TaxAmount` = '8922' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592285' WHERE `Matrix_Unique_ID` = '212497838' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:08:51.717' ,`MLSNumber` = '85697595' ,`ListAgentFullName` = 'Ginger Mashburn' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759770' ,`Longitude` = '-94.677234' ,`PhotoCount` = '9' ,`PostalCode` = '77514' ,`RoomCount` = '6' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak' ,`StreetNumber` = '907' ,`StreetSuffix` = 'Street' ,`City` = 'Anahuac' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful custom built home is located in the quaint town of Anahuac. Nestled on almost an acre, this home features quality craftmanship and attention to every detail. Solid wood doors and crown molding are standard features, An open concept floor plan offers plenty of space for family and friends to gather. The kitchen counters are crafted from high quality granite and there is abundant counter space and storage. Throughout the home you will find beautiful tile flooring. The spacious primary bedroom and adjoining bathroom have a large walk in shower, double sinks, and a spacious closet. Large windows allow natural light into the home. There is a large covered back porch with plenty of room for grilling and relaxing. The detached 3 car garage has plenty of space for storage and parking with a stairway to the attic for easy access. The location is quiet and peaceful but only a 10 minute drive to Interstate 10.' ,`Acres` = '1.246' ,`Area` = '53' ,`BuilderName` = 'Christian Acosta' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '304 TR 10-2-2 C WILLCOX' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '54276' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'AGC Acosta Estates' ,`TaxAmount` = '1112' ,`TaxRate` = '2.9736' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1666592285' WHERE `Matrix_Unique_ID` = '212567216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:37:00.973' ,`MLSNumber` = '4600602' ,`ListAgentFullName` = 'Wanda Pink' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654423' ,`Longitude` = '-95.838221' ,`PhotoCount` = '12' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '1875000.00' ,`Status` = 'Active' ,`StreetName` = 'LEANING OAK TRAIL' ,`StreetNumber` = '703' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEST BUILT LUXURY HOME KNOW AS FORT KNOX. CONCERT AND STEEL. LAKE VEIW PROPERTY ON ONE ACRE NESTLED IN THE COUNTRY IN PRIVATE NEIGHBORHOOD!' ,`Acres` = '1.0234' ,`Area` = '30' ,`BuilderName` = 'ACE LIFESTYLES LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WHISPERING OAKS, BLOCK 1, LOT 13' ,`LotDesciption` = 'Water View' ,`LotSize` = '44579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Whispering Oaks' ,`TaxAmount` = '5796' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666592285' WHERE `Matrix_Unique_ID` = '212666301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:19:03.257' ,`MLSNumber` = '29897568' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = 'Lina Dao Tran' ,`SellingOfficeName` = 'Nest Finders' ,`Latitude` = '29.789790' ,`Longitude` = '-95.662537' ,`PhotoCount` = '25' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '397000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Beach Oak' ,`StreetNumber` = '1520' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2047' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BETTER THAN NEW beautiful townhouse in a gated community and very quiet area. Great access to Energy Corridor, Houston Methodist Medical Center West, Katy, and more.\r\n \r\nVery popular Weston floorplan with living, kitchen, dining, and half bath downstairs. Additional living/office, bedrooms, bathrooms, and laundry are upstairs. Has covered patio with small grass yard. Tile floors downstairs and carpet upstairs. \r\n\r\nEXTRAS:\r\n-Electric vehicle charging outlet in garage 220V 50Amp\r\n-epoxy coated garage floor\r\n-ceiling fans in all bedrooms and living spaces\r\n-all tile, grout, and quartz has been sealed\r\n\r\nThis home is only 5 months old with builder extras: covered patio, Meritage highest finishes, and appliance package. \r\n\r\nLow tax district.\r\n\r\nHOA covers lawn care, water, sewer, and trash.\r\n\r\nRefrigerator, washer, and dryer are negotiable.' ,`Acres` = '0.0544' ,`Area` = '8' ,`BuilderName` = 'Meritage' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 OAKS OF PARK ROW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2369' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oaks/Pk Row Amending Plat #1' ,`TaxAmount` = '1196' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666592285' WHERE `Matrix_Unique_ID` = '212722903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:41:49.863' ,`MLSNumber` = '67433289' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.858240' ,`Longitude` = '-95.610843' ,`PhotoCount` = '31' ,`PostalCode` = '77041' ,`RoomCount` = '9' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Klamath Falls' ,`StreetNumber` = '13323' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1329' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. This clean & move-in ready residence is ready for new owners to call it home. Enter the open living room w/ high ceiling & an all brick fireplace, great for those upcoming chilly winter nights. The windows in the back of the house fill the living room, breakfast nook, & kitchen w/ natural light. The breakfast bar is perfect for grab and go meals on those busy mornings and a cozy breakfast nook for sitting around on those slow mornings. SS appliances, striking patterned backsplash, & colored cabinets sharpen up the look of the kitchen. The primary bedroom has hard surfaced floors, plus a large window to look out to your private, fenced backyard. The bath en-suite features a double vanity w/ built in shelves for more storage and a standing shower. Take a break outside under the covered patio featuring a ceiling fan to stay cool during hot Texas summers. A neighborhood park & grocery store are conveniently located just down the road.' ,`Acres` = '0.1756' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 7 CONCORD BRIDGE SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Concord Bridge Sec 03' ,`TaxAmount` = '3760' ,`TaxRate` = '2.471' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592285' WHERE `Matrix_Unique_ID` = '212815271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:03:14.010' ,`MLSNumber` = '43972943' ,`ListAgentFullName` = 'Brenda Klushin' ,`ListOfficeName` = 'Realty Pros of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706844' ,`Longitude` = '-95.871122' ,`PhotoCount` = '46' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Terrace' ,`StreetNumber` = '28703' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**** Amazing Taylor Morrison home (Granada Floorplan) located in Bonterra at Cross Creek Ranch, a 55+ community! 2 BR + 3rd Flex Rm (currently a Study), 2.5 Baths, 2.5 Car Extended Garage. This beautiful, energy efficient & ADA compliant home is loaded with well thought out upgrades, located on a cul-de-sac lot with a lake view & gated lake access. Features A 22KW Generac WHOLE HOUSE GENERATOR, Water Softener & Filter System, Tankless HWH, ‘Instant Heater’ (kitchen sink), Cameras/IT Rack upgrades, Indoor & Outdoor shades (some electric!), Indoor/outdoor Surround Sound, Huge backyard, Flag Pole, no back neighbors, Extended Covered Patio, HOT TUB, Outdoor Kitchen, Rear Gate (lake access), Fountain, Drainage/Driveway Extension, extended garage, & WiFI sprinkler system. Front lawn maintenance included in HOA dues. Community amenities include The Club @ Bonterra plus walking trails, ponds, pools, pickleball, access to other Cross Creek amenities & more!' ,`Acres` = '0.2832' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONTERRA AT CROSS CREEK RANCH SEC 6, BLOCK 1, LOT 18' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '12338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra At Cross Creek Ranch Sec 6' ,`TaxAmount` = '13537' ,`TaxRate` = '3.3362' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592286' WHERE `Matrix_Unique_ID` = '212882044' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:48:37.720' ,`MLSNumber` = '2781436' ,`ListAgentFullName` = 'Elaine Marak' ,`ListOfficeName` = 'Elaine Marak Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515149' ,`Longitude` = '-95.021927' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '4' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Belcara' ,`StreetNumber` = '2121' ,`StreetSuffix` = 'View' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3178' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Vacation at Home! Immaculate & Loaded Taylor Morrison Home in Premium Location with 2nd Floor Lake Fountain View! Elegant 2-story foyer, formal dining/study on entry, 2-inch blinds throughout, neutral trendy colors, open concept, huge celebrity-style kitchen with granite/stainless and gas cooking, large pantry, under cabinet lights, large utility room with sink and storage, main suite with spa-style bath, large walk-ins, media and game room up, split plan, en suites and more! Extensive upgrades include bath remodels, fixtures upgrades, recent HVAC, 1 dehumidifier, 2 tank-less water heaters, water softener, insulation, security system. Vacation at Home in amazing back yard with covered patio to entertain all year, flagstone, enjoy the breeze relaxing in the private pergola, sprinkler system, night lights and added bonus of large heavy-duty shed converted to man-cave & she-shed a must see! Private back yard ready to add your pool & more! Don\'t miss this - ready for move-in today.' ,`Acres` = '0.2093' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'MAR BELLA SEC 2 (2007) ABST 32, BLOCK 1, LOT 8, ACRES 0.209' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9118' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1015' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mar Bella Sec 2 2007' ,`TaxAmount` = '11173' ,`TaxRate` = '2.7997' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592286' WHERE `Matrix_Unique_ID` = '213154120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:08:11.137' ,`MLSNumber` = '66449824' ,`ListAgentFullName` = 'Joy Padvorac' ,`ListOfficeName` = 'Village Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.215605' ,`Longitude` = '-95.663823' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Thousand Oaks' ,`StreetNumber` = '33318' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this stunning home nestled on a MASSIVE 1.3 acre lot featuring 4 spacious bedrooms, 3 FULL bathrooms & an attached oversized 3-car garage. The open floorplan of this home is very functional & convenient. Luxe flooring, designer paint & tall ceilings throughout. Enjoy your chef’s kitchen w/ sprawling counter space, ample amounts of cabinet storage & walk-through access to the formal dining room. The spacious living room boasts impressive two-story ceilings, bright natural light & a stunning stone-cast fireplace. Downstairs you’ll find the primary luxury suite with a tray ceiling, bright windows & a spa-inspired ensuite bathroom. Also located downstairs is a separate guest room w/ secondary bathroom. Upstairs enjoy your oversized game room and two additional guest rooms & bathroom. The sprawling backyard is an OUTDOOR PARADISE that has been well-maintained with lush landscaping & over a dozen fruit-bearing trees. Zoned to Magnolia ISD, w/ easy access to 249, I45 & 99.' ,`Acres` = '1.274' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S924300 - THOUSAND OAKS 01, BLOCK 3, LOT 2, ACRES 1.274' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '55495' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thousand Oaks 01' ,`TaxAmount` = '7209' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592286' WHERE `Matrix_Unique_ID` = '213228165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:23:08.257' ,`MLSNumber` = '4649676' ,`ListAgentFullName` = 'Jasmine Lenderman' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667294' ,`Longitude` = '-95.125446' ,`PhotoCount` = '16' ,`PostalCode` = '77536' ,`RoomCount` = '1' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Evie' ,`StreetNumber` = '7402' ,`StreetSuffix` = 'Lane' ,`City` = 'Deer Park' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1003' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated 3 bedroom, 1 bathroom home in Deer Park within walking distance to JP Dabbs Elementary school. House is close to grocery stores, restaurants, and shopping. Minutes from The Beltway, Spencer Highway, and San Jacinto College\'s Central Campus. \r\n\r\nThe property features new insulation in the attic, updated PEX tubing, recent foundation repair comes with warranty, new appliances, and open concept with new flooring throughout. Washer and dryer hook ups located inside the home. The fence is new with a large door on the side with a concrete pad, a perfect spot to park your boat, or trailer. The house is on a large corner lot, with a newly poured driveway making this the perfect opportunity to own a home in Deer Park.' ,`Acres` = '0.1873' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 8 SPENCER VIEW TERRACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '8160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spencer View Terrace' ,`TaxAmount` = '2414' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592286' WHERE `Matrix_Unique_ID` = '213341715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:26:11.940' ,`MLSNumber` = '64283648' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.138828' ,`Longitude` = '-95.392955' ,`PhotoCount` = '30' ,`PostalCode` = '77386' ,`RoomCount` = '14' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Clover Trace' ,`StreetNumber` = '3206' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your oasis awaits! This move-in ready property is looking for new owners. This 4bed/2bath has beautiful floors and high ceilings. Natural lighting is bursting throughout the many windows. The open living area connects to the breakfast nook and kitchen. A kitchen island with bar seating is right in the center for guests to have a seat and converse with the chef. The primary bedroom is tucked away for additional privacy and features a 5 piece en-suite bath with a vanity! Upstairs you’ll find the loft and remaining bedrooms. Relax outdoors under the covered patio that features an outdoor fan - perfect for those hot Texas summers. Enjoy extra space and storage with the 3-car garage. Down the road is access to HWY 99 and various restaurants and grocery stores. Click the Virtual Tour link to view the 3D walkthrough.' ,`Acres` = '0.1736' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456100 - ESTATES OF LEGENDS TRACE 01, BLOCK 4, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7561' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates Of Legends Trace 01' ,`TaxAmount` = '8387' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592286' WHERE `Matrix_Unique_ID` = '213369660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:28:49.717' ,`MLSNumber` = '31881238' ,`ListAgentFullName` = 'Michael Furman' ,`ListOfficeName` = 'RE/MAX Unlimited' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.663155' ,`Longitude` = '-96.342611' ,`PhotoCount` = '26' ,`PostalCode` = '77802' ,`RoomCount` = '3' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Peterson' ,`StreetNumber` = '3072' ,`StreetSuffix` = 'Circle' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home by 5K Homes in lovely Briar Meadows. This 3 bedroom 2.5 bath beautifully designed home has granite throughout, raised ceilings, split floorplan and open concept into kitchen & living room. The stunning master suite has a large bathroom with dual vanities, separate shower & huge walk-in closet. Chef\'s dream kitchen includes enormous island, beautiful granite countertops, upgraded appliances and walk-in pantry. Great private patio in back perfect for entertaining family and friends. This home is just minutes away from shopping, restaurants, schools and entertainment. Call now and schedule a private showing!' ,`Acres` = '0.1388' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRIAR MEADOWS CREEK PH 5, BLOCK 2, LOT 13' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '6046' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'JOHNSON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Mdws Crk Sub Ph 5' ,`TaxAmount` = '8557' ,`TaxRate` = '2.3493' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592287' WHERE `Matrix_Unique_ID` = '213396612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:59:30.107' ,`MLSNumber` = '33831438' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932282' ,`Longitude` = '-95.630590' ,`PhotoCount` = '37' ,`PostalCode` = '77429' ,`RoomCount` = '14' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'White Oak Point' ,`StreetNumber` = '10827' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Gorgeous move-in ready home awaits new owners! This open concept floor plan is an ideal layout for hosting guests and entertaining. The kitchen features an all gas stove and oven with stunning corian countertops and tile backsplash. Gather around the fireplace and have a cup of tea during the upcoming winter nights. The primary bedroom looks out toward the pool and features an en-suite bathroom with a standing shower and spa-like tub. Additional space is found upstairs that can be used as a gameroom, media room, or office – the options are endless! Take the fun outside and cool off in your own private in-ground pool - perfect for the hot Texas summers. Additional shade is provided by the covered patio! Close access to HWY 290, restaurants, and grocery stores all at your convenience. Come tour your new oasis! Recent upgrades: full interior paint on walls and ceilings, new carpet.' ,`Acres` = '0.2406' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 WHITE OAK SPRINGS SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'LAMKIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'White Oak Spgs Sec 01' ,`TaxAmount` = '6764' ,`TaxRate` = '2.551' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592287' WHERE `Matrix_Unique_ID` = '213432633' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:56:42.173' ,`MLSNumber` = '8358038' ,`ListAgentFullName` = 'Johnathan Callery' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.295646' ,`Longitude` = '-94.915452' ,`PhotoCount` = '22' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '815000.00' ,`Status` = 'Active' ,`StreetName` = 'Hawaii' ,`StreetNumber` = '1303' ,`StreetSuffix` = 'Drive' ,`City` = 'Tiki Island' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Deal! Home located On A LARGE CORNER LOT, directly on the canal. Property is also equipped with a nice sized vacant piece of land that will give new home owners multiple options for utilizing and building on. 1303 Hawaii Dr. features three bedrooms, two bathrooms, A large open living and kitchen combination with HIGH CEILINGS and beautifully EXPOSED BEAMS. Each bathroom is equipped with large walk-in showers plus the home also includes a luxury Over-Sized Jetted Tub that heats up to 104°, perfect for relaxing. The first level has a large covered patio space perfect for family gatherings or entertainment. The Owners recently replaced the entire patio deck flooring which provides multiple scenic views of Tiki and the Canal. A nice over-sized garage, plus plenty of additional parking to accommodate family and friends. Situated right on the canal, you have a BOAT SLIP and DIRECT ACCESS to the Gulf of Mexico at your leisure. Please View Virtual Video Tour and schedule a tour.' ,`Acres` = '0.21' ,`Area` = '33' ,`BuilderName` = 'N/A' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 72 TIKI ISLAND SEC 3' ,`LotDesciption` = 'Corner,Water View,Waterfront' ,`LotSize` = '9148' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island 3' ,`TaxAmount` = '6519' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592287' WHERE `Matrix_Unique_ID` = '213487865' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:53:08.410' ,`MLSNumber` = '58913085' ,`ListAgentFullName` = 'Yen Truong' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.759332' ,`Longitude` = '-95.755594' ,`PhotoCount` = '23' ,`PostalCode` = '77450' ,`RoomCount` = '3' ,`ListPrice` = '280000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Eagle Meadow' ,`StreetNumber` = '22035' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this spacious 1 story home in the beautiful community of Creekstone! This home is located in very quiet and peaceful neighborhood. House with 3 beds room, 2 bathrooms , high ceiling and open floor plan with a good-sized living room, vinyl flooring through out , cozy fireplace. Kitchen offers a lot of spaces with plenty of cabinet storage, gas cooktop, stainless steels appliances. Bathroom with separate tub and shower. Large fenced in backyard is a great place for entertainment and gathering .Very convenience and easy to access to I10, 99. Surround by a lot of restaurants, groceries stores, La Centerra, Katy Asian town, Zoned to Katy ISD schools ... and just less than 1 min walking to the playground and tennis court. Schedule your showing to see this beautiful home today!' ,`Acres` = '0.1405' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 5 CREEKSTONE SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekstone Sec 02' ,`TaxAmount` = '4627' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592287' WHERE `Matrix_Unique_ID` = '213537373' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:41:24.403' ,`MLSNumber` = '45322574' ,`ListAgentFullName` = 'Virginia Schilling' ,`ListOfficeName` = 'Turbo Realty of Texas' ,`SellingAgentFullName` = 'Paula Miller' ,`SellingOfficeName` = 'JPAR - The Sears Group' ,`Latitude` = '29.991784' ,`Longitude` = '-95.165877' ,`PhotoCount` = '33' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '237000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Oak Bower' ,`StreetNumber` = '18811' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very well kept 1 story Brick 4 Bedroom ~ 2 Bath ~ 2 Car Garage with a double wide driveway . Home near a right turn cul-de-sac in 77346 for $237K! Who could ask for more? Updated double windows , \r\nRoof replaced in 2020 5 burner Maytag Gas stove Oven / Refrigerator stays\', Living room features a vaulted ceiling and a beautiful brick gas log fireplace. Tile entry / Storm Door . Engineered wood floors . \r\nWalk to Elementary school and Atascoctia Middle School Close to Atascocita High School . Come check it out!' ,`Acres` = '0.1717' ,`Area` = '1' ,`BuilderName` = 'General Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 18 ATASCOCITA SOUTH SEC 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '7480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'TIMBERS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita South Sec 02' ,`TaxAmount` = '4068' ,`TaxRate` = '2.3974' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592288' WHERE `Matrix_Unique_ID` = '213538448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:48:30.187' ,`MLSNumber` = '62368240' ,`ListAgentFullName` = 'Meredith Davis' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799928' ,`Longitude` = '-95.483741' ,`PhotoCount` = '34' ,`PostalCode` = '77055' ,`RoomCount` = '6' ,`ListPrice` = '467500.00' ,`Status` = 'Active' ,`StreetName` = 'Westside Gardens' ,`StreetNumber` = '1607' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to first floor, open concept living, in a gated community. With high ceilings and large windows this home is flooded in natural light. This dream kitchen has bountiful cabinetry, under cabinet lighting and elegant backsplash. The built-in pantry has custom stainless steel sliding racks providing plenty of room for your favorite snacks. A large island and quartz countertops tie it all together. The primary retreat features a large walk in closet, double vanity, quartz countertops, upgraded lighting, soaking tub and large separate shower. The spacious secondary bedrooms are serviced by a Jack and Jill bathroom. The garage has gladiator wall racks for even more storage and the epoxy floor keeps it clean and cool. No detail was missed. This home is move in ready and has been meticulously maintained.' ,`Acres` = '0.0438' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 3 WEST SIDE VILLAS' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1968' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TREASURE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'West Side Villas' ,`TaxAmount` = '8909' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592288' WHERE `Matrix_Unique_ID` = '213553393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:07:25.897' ,`MLSNumber` = '5236339' ,`ListAgentFullName` = 'Jeffrey Lutz' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.416550' ,`Longitude` = '-95.809389' ,`PhotoCount` = '50' ,`PostalCode` = '77461' ,`RoomCount` = '9' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Jeske' ,`StreetNumber` = '9219' ,`StreetSuffix` = 'Road' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL +/- 10 acre tract with custom +/- 1900 sqft., ranch style home and pool. This property is perfect for country living with the city just a few minutes away. This unrestricted tract offers not only a beautiful homesite, but the ability to bring your horses, live stock, pets, and all your outdoor toys. Set nicely off the road, and surrounded by big trees, this setting is sure to please. The ranch style home has many recent updates and is truly ready to move into. With the home and 10 acres priced affordably, you can continue to make changes and updates to your likely, but the neutral pallet is ready to make yours. The entire home has been been painted inside, and new Luxury vinyl plank flooring through out. The unique floor plan offers an amazing family space measuring +/- 30 x 17 foot. There is an entire wall of windows looking out to the inground pool. There are so many views of the pool from almost every part of the home. There is also a barn/workshop, with stalls and coop.' ,`Acres` = '9.996' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Stove,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '0222 H AND TC RY, TRACT 10, ACRES 9.996' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '435426' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'H & Tc Ry' ,`TaxAmount` = '7011' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592288' WHERE `Matrix_Unique_ID` = '213578844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:43:48.080' ,`MLSNumber` = '52182361' ,`ListAgentFullName` = 'Jimi Jordan' ,`ListOfficeName` = 'Xterra Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201507' ,`Longitude` = '-97.846506' ,`PhotoCount` = '33' ,`PostalCode` = '78749' ,`RoomCount` = '7' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Danli' ,`StreetNumber` = '3905' ,`StreetSuffix` = 'Lane' ,`City` = 'Austin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing reno move in ready. Completely remodeled, Just a few minutes from down town. New floors, Carpet, counters, Fresh interior and exterior paint new HVAC, New Primary bathroom his and her walk in shower, His and her vanities. New fence, Deck and All new Landscaping make this home completely updated. Located in the Austin city limits and convenient to the hill country parks and lakes. Great for Families and Professionals alike. Hurry this Home will not last.' ,`Acres` = '0.1326' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 21 BLK I MAPLE RUN SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5776' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '111 - Austin' ,`SchoolElementary` = 'COWAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOWIE HIGH SCHOOL (AUSTIN)' ,`SchoolMiddle` = 'COVINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Maple Run Sec 08' ,`TaxAmount` = '7615' ,`TaxRate` = '2.1767' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592288' WHERE `Matrix_Unique_ID` = '213629739' --> 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','213637343','1666592288','213637343','2022-10-23T22:30:23.363','75344842','Jay Richardson','Register Real Estate Advisors','','','29.968195','-95.435205','38','77014','10','250000.00','Active','Clear Valley','1231','Drive','Houston','2','0','3','1768','Single-Family','Such a Beautiful Home! Conveniently located near I-45 and Beltway 8 and just minutes away from Bush airport, Downtown, and The Woodlands. Great property for a family. Great for entertaining. Recently updated! Be sure to check out the huge family room. Its spacious island kitchen includes granite and stainless steel countertops, a gas range, a microwave, a dishwasher, garbage disposal with lots of cabinets, and counter space. Primary bath with Whirlpool bathtub and separate shower. Outdoors features a very large backyard with an oversized covered patio which is perfect for children and our furry family members. No carpet here. Only Luxury Vinyl Plank and Ceramic Tile. Ceiling fans are located in each room. Schools and parks are all nearby! Ready for a fast move-in, it\'s time for you to make this your Home! Request an appointment to view this beauty today!!','0.1832','13','','','Washer Connections','','Mud,Sellers Disclosure','1','','0','1960/Cypress Creek South','Central Gas','1','TRS 2 & 3A BLK 4 CRANBROOK SEC 1','Subdivision Lot','7980','Appraisal District','','450','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','48 - Spring','CLARK ELEMENTARY SCHOOL (SPRING)','ANDY DEKANEY H S','STELLE CLAUGHTON MIDDLE SCHOOL','Lockbox Front,Supra Keybox','Appraisal District','1','Ranch','Cranbrook','4230','2.7192','Water District','1987','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:09:13.370' ,`MLSNumber` = '25660285' ,`ListAgentFullName` = 'Edgar Jammer' ,`ListOfficeName` = 'Jammer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.940778' ,`Longitude` = '-95.206708' ,`PhotoCount` = '32' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Oasis' ,`StreetNumber` = '12119' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful energy efficient 4 bedroom,3.5 bath home in Humble, TX today. This spacious home features granite countertops in the kitchen, a walk-in pantry, large primary bedroom with a garden tub and separate shower in the bathroom, a game room, and energy efficient Low-E windows and tech-shield. Have your REALTOR show you this home today before it\'s gone!' ,`Acres` = '0.1324' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 SUNSET RIDGE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5768' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Ridge' ,`TaxAmount` = '7294' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592288' WHERE `Matrix_Unique_ID` = '213687810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:11:37.947' ,`MLSNumber` = '5916713' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943268' ,`Longitude` = '-95.256314' ,`PhotoCount` = '30' ,`PostalCode` = '77396' ,`RoomCount` = '3' ,`ListPrice` = '256000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunlit Park' ,`StreetNumber` = '9210' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Humble one-story home offers a two-car garage.' ,`Acres` = '0.1415' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 1 CANYON VILLAGE AT PARK LAKES SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6165' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PARK LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Vlg/Pk Lakes Sec 5' ,`TaxAmount` = '5165' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666592289' WHERE `Matrix_Unique_ID` = '213745903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:25:54.467' ,`MLSNumber` = '40897433' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.644020' ,`Longitude` = '-95.767572' ,`PhotoCount` = '22' ,`PostalCode` = '77406' ,`RoomCount` = '3' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunlight Springs' ,`StreetNumber` = '3610' ,`StreetSuffix` = 'Street' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built in 2019, this Richmond one-story home offers a patio, granite countertops, and a two-car garage. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1326' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MCCRARY MEADOWS SEC 4, BLOCK 7, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5774' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mccrary Meadows Sec 4' ,`TaxAmount` = '6213' ,`TaxRate` = '2.8548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666592289' WHERE `Matrix_Unique_ID` = '213745909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:21:55.140' ,`MLSNumber` = '17234926' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.037867' ,`Longitude` = '-95.517800' ,`PhotoCount` = '32' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Trailway' ,`StreetNumber` = '6303' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2003' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Spring two-story home offers a two-car garage. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.2789' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 22 017*S6353500-003-022-034 SPRING CREEK FOREST SE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Creek Forest Sec 03' ,`TaxAmount` = '4850' ,`TaxRate` = '2.5315' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666592289' WHERE `Matrix_Unique_ID` = '213746217' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:44:55.953' ,`MLSNumber` = '72881739' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.327387' ,`Longitude` = '-95.315287' ,`PhotoCount` = '21' ,`PostalCode` = '77306' ,`RoomCount` = '3' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Danika Oak' ,`StreetNumber` = '16393' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this fabulous area! This home has fresh interior paint. Windows create a light filled interior with well placed neutral accents. The kitchen is ready for cooking with ample counter space and cabinets for storage. Head to the spacious primary suite with good layout and closet included. Other bedrooms provide nice flexible living space. Take advantage of the extended counter space in the primary bathroom complete with double sinks and under sink storage. Take it easy in the fenced in back yard. The sitting area makes it great for BBQs! Don\'t miss this incredible opportunity. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1607' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'KELLYN OAKS 01, BLOCK 1, LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'CREIGHTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kellyn Oaks 01' ,`TaxAmount` = '3404' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666592289' WHERE `Matrix_Unique_ID` = '213754418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:38:26.743' ,`MLSNumber` = '60525091' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928902' ,`Longitude` = '-95.511324' ,`PhotoCount` = '19' ,`PostalCode` = '77086' ,`RoomCount` = '3' ,`ListPrice` = '281000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Line' ,`StreetNumber` = '13327' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this charming home now on the market! This home has fresh interior paint. Discover a bright and open interior with plenty of natural light and a neutral color palate, complimented by a fireplace. You\'ll love cooking in this kitchen, complete with a spacious center island and a sleek backsplash. Relax in your primary suite with a walk in closet included. Other bedrooms provide nice flexible living space. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. The fenced in backyard gives you the perfect private area to enjoy the outdoors. Hurry, this won’t last long! This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.1361' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 BLUE CREEK SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5929' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MCDOUGLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Blue Creek Sec 06' ,`TaxAmount` = '4670' ,`TaxRate` = '2.4615' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666592289' WHERE `Matrix_Unique_ID` = '213756870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:55:31.930' ,`MLSNumber` = '90205993' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.912924' ,`Longitude` = '-95.718074' ,`PhotoCount` = '30' ,`PostalCode` = '77433' ,`RoomCount` = '14' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Opal Shores' ,`StreetNumber` = '9226' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Stunning curb appeal welcomes you home! This 4 bed/3 bath has plenty of space to entertain guests. Granite countertops, gas cooktop, and stainless steel appliances are just a few highlights in the open kitchen. The kitchen also looks out to the family room where guests can sit at the breakfast bar and enjoy conversations with the chef. Natural lighting brightens the breakfast area and living room. The primary bedroom features a 5 piece en-suite bath with a spa like tub and walk-in closet. Upstairs a large game room can be turned into a media room or office! The spacious and private backyard has plenty of room for a playground, pool, or garden – the choices are endless! No neighbors to the back. Close access to HWY 99, grocery stores, and restaurants. Come relax and make memories in your new home!' ,`Acres` = '0.1943' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 BLK 1 MIRABELLA SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mirabella Sec 6' ,`TaxAmount` = '9516' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592290' WHERE `Matrix_Unique_ID` = '213758279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:02:34.663' ,`MLSNumber` = '25261662' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014668' ,`Longitude` = '-95.561650' ,`PhotoCount` = '19' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Kilrenny' ,`StreetNumber` = '9527' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1795' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your dream home is waiting for you! This home has fresh interior and exterior paint. Discover a bright and open interior with plenty of natural light and a neutral color palate, complimented by a fireplace. Step into the kitchen, complete with an eye catching stylish backsplash. You won’t want to leave the serene primary suite, the perfect space to relax. Other bedrooms provide nice flexible living space. The primary bathroom features plenty of under sink storage waiting for your home organization needs. Take it easy in the fenced in back yard. Don\'t wait! Make this beautiful home yours today. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.2312' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 12 017*M1875900-002-012-001 MEMORIAL CHASE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10071' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Chase Sec 02' ,`TaxAmount` = '4439' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666592290' WHERE `Matrix_Unique_ID` = '213759689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:01:25.950' ,`MLSNumber` = '12657529' ,`ListAgentFullName` = 'Feras Rachid' ,`ListOfficeName` = 'Opendoor Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766255' ,`Longitude` = '-95.005142' ,`PhotoCount` = '24' ,`PostalCode` = '77521' ,`RoomCount` = '4' ,`ListPrice` = '261000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashwood' ,`StreetNumber` = '5108' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this stunner! This home has fresh interior paint, new appliances, and partial flooring replacement. Discover a bright and open interior with plenty of natural light and a neutral color palate, complimented by a fireplace. Step into the kitchen, complete with an eye catching stylish backsplash. Head to the spacious primary suite with good layout and closet included. Other bedrooms provide nice flexible living space. The primary bathroom is fully equipped with a separate tub and shower, double sinks, and plenty of under sink storage. Take it easy in the fenced in back yard. Don\'t wait! Make this beautiful home yours today. This home has been virtually staged to illustrate its potential.' ,`Acres` = '0.2755' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 15 COUNTRY CLUB OAKS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Club Oaks Sec 05' ,`TaxAmount` = '5285' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666592290' WHERE `Matrix_Unique_ID` = '213762087' --> 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','213779144','1666592290','213779144','2022-10-23T22:29:36.843','63306556','Maria Jackson','FYI Realty-Katy','','','29.794506','-95.789015','35','77493','9','395000.00','Active','Schivener House','24431','Lane','Katy','2','1','4','2526','Single-Family','Welcome to 24431 Schivener House Ln., a beautiful 4-bedroom two story home with an incredible backyard oasis in the highly desired Lakecrest community! This stunning home has many upgrades throughout like a fully updated kitchen consisting of custom cabinetry, granite countertops, copper sink, travertine backsplash, travertine flooring & stainless-steel appliances. \r\nThe family room comes complete with wood look tile throughout, a beautiful vaulted ceiling, gas fireplace with a travertine surround, and inset art niche. \r\nIt doesn’t stop there, the updated owner\'s suite is a light filled peaceful spot to unwind that includes a spa like bath with a custom vanity, double vessel sinks, frameless shower with travertine tile, round soaking tub, and designer fixtures. Your Texas sized yard is an entertainer’s dream complete with a covered patio, dual fans, gas firepit, relaxing pool & spa with serene water features. Don’t miss this amazing home and schedule your private tour today!','0.2212','25','','','','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Katy - North','Central Gas','1','LT 9 BLK 4 LAKECREST SEC 1','Greenbelt,Subdivision Lot','9637','Appraisal District','','525','0','','2','Gas Oven','1','In Ground','','','','Composition','30 - Katy','KING ELEMENTARY SCHOOL','MORTON RANCH HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Lakecrest','7035','2.5733','Water District','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:19:35.407' ,`MLSNumber` = '50442262' ,`ListAgentFullName` = 'Nicholas Carona' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818786' ,`Longitude` = '-95.780547' ,`PhotoCount` = '29' ,`PostalCode` = '77493' ,`RoomCount` = '14' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Quarry Place' ,`StreetNumber` = '3107' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Stunning curb appeal welcomes you home! This 4 bed/2.5 bath is move-in ready and features an open floor plan. Natural lighting fills the office and family room! Guests can gather in the dining or family room through one of the gorgeous archways. The kitchen has ample counter space, tile backsplash, and a breakfast bar that opens to the family room. Double sinks, en-suite bath, walk-in closet, and garden tub are just a few highlights in the primary bath. Upstairs can be turned into an extra living space, game room, or media room – the opportunities are endless! The spacious private backyard is a blank slate to add a garden, playground, or pool. Enjoy the outdoors by spending time at the neighborhood park/pool or on Mason Creek South Hike & Bike trail. Down the road is HWY 99, restaurants, and grocery stores. Welcome home to your new oasis! Home is fully wired, has home theater speakers, and new carpet.' ,`Acres` = '0.1411' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 3 MORTON CREEK RANCH SEC 2 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6146' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '595' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Crk Ranch Sec 02' ,`TaxAmount` = '8233' ,`TaxRate` = '3.3333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592290' WHERE `Matrix_Unique_ID` = '213804650' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:48:47.040' ,`MLSNumber` = '30392123' ,`ListAgentFullName` = 'Kathy Garrison' ,`ListOfficeName` = 'Real Living Karapasha Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749262' ,`Longitude` = '-95.760749' ,`PhotoCount` = '32' ,`PostalCode` = '77450' ,`RoomCount` = '11' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Long Cove' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Circle' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3974' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this rare find, Mitchell-Carroll custom home. Centrally located in the exclusive gated golf course community of Fairway Manor, all within the heart of Cinco Ranch where location is key! Beautiful mature trees and lush landscaping greet you from the curb. Meticulously maintained inside and out, this home is spacious with lots of natural light, boasting 12 foot ceilings and many windows with spectacular views overlooking the pool and spa. Primary, living and study all with beautiful hard woods, while porcelain tile in den, kitchen and dining for easy maintenance. This home offers lots of storage from the closets, built-ins and generous bathroom space to extra garage space. New updates include HVAC systems, water heaters, toilets, carpet and paint. Backyard paradise includes lots of covered space for entertaining, pool/spa with rock waterfall and ample yard space plus a sports court which offers multiple uses. All this and a LOW TAX RATE! Zoned to EXCELLENT Katy ISD!' ,`Acres` = '0.2771' ,`Area` = '36' ,`BuilderName` = 'Mitchell-Carroll' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH NORTH LAKE VILLAGE SEC 6, BLOCK 1, LOT 27' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '12070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FIELDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch North Lake Village Sec 6' ,`TaxAmount` = '11227' ,`TaxRate` = '2.2045' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592291' WHERE `Matrix_Unique_ID` = '213821058' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:57:56.607' ,`MLSNumber` = '60004672' ,`ListAgentFullName` = 'Debbie Ashley' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571075' ,`Longitude` = '-95.333923' ,`PhotoCount` = '46' ,`PostalCode` = '77581' ,`RoomCount` = '9' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Rolling Hills' ,`StreetNumber` = '2117' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fabulous two story features a great floorplan with high ceilings, lots of natural light, custom window covers & imported European hardwood engineered flooring. The kitchen boasts a huge island open to the family room, walk-in pantry & adjacent casual dining with sparkling chandelier. Home office/study provides privacy with its double French doors. Primary bedroom easily accommodates your king-size bed & the curved wall of windows adds elegance. Primary bath with double sinks, soaking tub, separate shower & huge walk-in closet. Upstairs, three bedrooms share two full baths. The game room provides plenty of room for all your friends! Covered back patio with built-in grill & sink. Raised garden bed is ready for planting. Storage shed. Additional fencing for dog run! Quick commute to Houston Medical Center and Museum District. Nearby shopping and restaurants. Amenities include sports complex, splash pad, pool & playgrounds. Low tax rate, affordable HOA, zoned to A-Rated Pearland ISD.' ,`Acres` = '0.1698' ,`Area` = '5' ,`BuilderName` = 'Plantation Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON TERRACE SEC 4 (A0505 H T & B) BLK 2 LOT 8' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7397' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon Terrace' ,`TaxAmount` = '10154' ,`TaxRate` = '2.6537' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592291' WHERE `Matrix_Unique_ID` = '213832194' --> 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','213853180','1666592291','213853180','2022-10-23T23:48:59.223','90353712','Clemente Garza','Alpha Elite Realty','','','29.388244','-95.215993','31','77511','9','295500.00','Active','County Road 136a','1176','','Alvin','2','1','4','2300','Single-Family','Lovely well-maintained home is ready for your family. Lots of cabinets on the wall between the Kitchen & Dining area. The home is located on over a half acre of land with a fenced back yard that that includes a large workshop.','0.6428','5','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Alvin South','Central Gas','0','LAKE SIDE VILLAGE (A0161 B B B & C), LOT 35-36','Subdivision Lot','28000','Appraisal District','','','0','','2','Double Oven,Electric Oven','0','','','Freestanding Range','','Composition','3 - Alvin','WALT DISNEY ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','ALVIN JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Ranch','Lake Side Village','3126','2.2174','Septic Tank,Well','1973','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:05:46.307' ,`MLSNumber` = '48796017' ,`ListAgentFullName` = 'Jacqueline Canada' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096109' ,`Longitude` = '-95.234364' ,`PhotoCount` = '28' ,`PostalCode` = '77365' ,`RoomCount` = '6' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Spears' ,`StreetNumber` = '22095' ,`StreetSuffix` = 'Road' ,`City` = 'Porter' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor special, unrestricted close to 59 and 99. This one has 3 homes, two of them are attached via a breeze way. One unit is tenant (month to month) occupied, that one is a 2 bedroom 1 bath. The A frame unit is a one bedroom studio type apartment. The main home has 2 kitchens and part of it was used as a massage/spa business. This property has a lot of potential for the right buyer. Selling as is.' ,`Acres` = '0.471' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0405 OWEN MARY, TRACT 35-B, ACRES 0.471,A0405 OWEN MARY, TR' ,`LotDesciption` = 'Cleared' ,`LotSize` = '20517' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Owen Mary' ,`TaxAmount` = '6039' ,`TaxRate` = '2.5431' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592291' WHERE `Matrix_Unique_ID` = '213885459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:41:10.417' ,`MLSNumber` = '89327595' ,`ListAgentFullName` = 'Sabrina Elias' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823347' ,`Longitude` = '-95.359655' ,`PhotoCount` = '6' ,`PostalCode` = '77022' ,`RoomCount` = '3' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Dorchester' ,`StreetNumber` = '833' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located to downtown, this property sits on a oversized lot of 20,400 sq ft. Great development opportunity or build your dream home. Convenient access to I45, Hardy Toll, 610 and 59. Walking distances to schools. Please do not disturb the tenant or enter fenced yard.' ,`Acres` = '0.4683' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 36 & 37 BLK 6 BEVERLY PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HERRERA ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beverly Place' ,`TaxAmount` = '4525' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592291' WHERE `Matrix_Unique_ID` = '213910440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T23:52:47.323' ,`MLSNumber` = '59167722' ,`ListAgentFullName` = 'Angela Longo' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703267' ,`Longitude` = '-95.457661' ,`PhotoCount` = '39' ,`PostalCode` = '77401' ,`RoomCount` = '14' ,`ListPrice` = '1950000.00' ,`Status` = 'Active' ,`StreetName` = 'Laurel' ,`StreetNumber` = '4615' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '6007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning and spacious on an oversized City of Bellaire inner loop lot, sits this beautifully constructed house. Truly spectacular open-concept floorplan, this home is designed for gatherings and entertaining as well as accommodating a large number of overnight guests. The kitchen is efficiently designed for preparation and serving while maintaining an open site-line for all first-floor spaces. The Primary and a Secondary en-suite bedroom are downstairs with an additional 4 oversized and en-suite bedrooms and a gameroom upstairs. Ideal for multi-generational families with great flexibility offered among all of the spaces. Covered porches on both sides of the house offer outdoor leisure space, additional architectural charm and view to the backyard which is ready for a pool. The large motor-court provides off-street parking and the workroom and utility room provide ample space for in-house tasks to be completed. No detail has been overlooked and every convenience is accounted for.' ,`Acres` = '0.3099' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 DAVIS R D' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HORN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Davis R D' ,`TaxAmount` = '24540' ,`TaxRate` = '2.23' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592291' WHERE `Matrix_Unique_ID` = '213911181' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-23T22:27:36.520' ,`MLSNumber` = '51768739' ,`ListAgentFullName` = 'Ram Garg' ,`ListOfficeName` = 'Suntrust Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861441' ,`Longitude` = '-95.422638' ,`PhotoCount` = '20' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Knox' ,`StreetNumber` = '6720' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful small cozy house with large front patio in Highland Heights, close to 610, I 45 and Tomball Parkway 249. Recently updated, new floor, paint interior and exterior, granites and new plumbing in kitchen, microwave, garbage disposal. New tiles in kitchen and bathrooms, 12 mm laminated floor in living and hallway and carpet in bedroom. New stove and AC will be installed before closing or pay $4000 in lieu of these. Front and back patio are redone and new fence is added. 3000 sqft of land, Lot 20 from the HCAD account # 0162770250020 will be conveyed at no extra cost with this sale, total land will be 6000 sqft, legal will be lots 19 and 20 Highland Heights . House is ready to move in immediately.' ,`Acres` = '0.156' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 25 HIGHLAND HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WESLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Heights' ,`TaxAmount` = '2278' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666592292' WHERE `Matrix_Unique_ID` = '213940894' --> 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','213972240','1666592292','213972240','2022-10-23T23:12:06.247','49749946','Tiffany Curry','BHHS Tiffany Curry & Co., REALTORS','','','30.011523','-95.647487','21','77429','10','299900.00','Active','Riford','15526','Drive','Cypress','2','1','3','1742','Single-Family','NEW LISTING!!! Gorgeous 2-story D.R. Horton Home in the highly sought after Villages on Grant community! Spacious 3 bedroom 2.5 bath with a large kitchen, family room, dining room and more. Great elevation, open plan, LAMINATE WOOD floors, high ceilings, recent appliances, blinds & fireplace! 1st floor Primary bedroom with private bath with separate tub & shower with a walk-in closet. 2 bedrooms up along with a game room! Spacious backyard w/ covered patio. Enjoy suburban peace & convenience to grocery stores, shopping, local eateries, area hot spots, great schools! Convenient access to 99 TOLLWAY, HWY 249 AND HWY 290! NEVER FLOODED!!!','','35','D.R. Horton','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Cypress North','Central Gas','1','LT 11 BLK 4 VILLAGES ON GRANT','Subdivision Lot','5940','Appraisal District','','350','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CY-FAIR HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required','Appraisal District','2','Traditional','Villages on Grant','5311','2.821','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213989588','1666592292','213989588','2022-10-23T22:56:52.890','14591069','Carla Lopez Fagundo','C.R.Realty','','','29.839862','-95.853750','31','77493','4','510000.00','Active','Indigo Night','3088','Lane','Katy','3','0','4','2432','Single-Family','Welcome to Lakehouse! Your New Home! A gated community in Katy, Texas. You will like coming home to this impeccably maintained house newly built in March 2022 with 4 bedroom, 3 bathroom and lots of space for entertainment. This house has an amazing open floor plan filled with beautiful finishing touches! This home features an open living area, dining room/living room, study room, kitchen with beautiful cabinets and a big island. Master suite offers a big walk-in closet, garden tub and a walk-in shower. Spacious secondary bathrooms. Enjoy the tranquil view of the water from your covered patio. Amazing fenced backyard to enjoy with your family and friends. Close to schools, shopping, dining and hospital, and convenience stores. All information submitted on the MLS and websites are intended to be accurate; however, cannot be guaranteed, buyers are advised to verify. Submit your offer today!','0.1837','25','','','','','Other Disclosures,Sellers Disclosure','','','','Katy - Old Towne','Central Gas','1','S558203 LAKE HOUSE 3 BLK 2 LOT 9','Water View','8002','Unknown','','1600','0','','2','','0','','','','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Supra Keybox','Builder','1','Traditional','Lakehouse','4637','2.1293','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','213993869','1666592292','213993869','2022-10-23T22:46:08.900','55011256','Melissa Rodriguez','Reyna & Reyna Holdings, LLC','','','29.878114','-95.437949','14','77088','3','288000.00','Active','Tower','9307','Street','Houston','2','1','3','1592','Single-Family','Welcome to 9307 Tower! New Construction home located in Highland Heights subdivision. No HOA! No Deed Restrictions! This home features 3/ bedrooms, 2.5/ baths, 2 Car Garage, fully fenced in. Photos are from a previous model home. This home will have the same floor plan and finishes throughout the home. Home offers a spacious living area with an open kitchen. Kitchen offers quartz counter tops with pendant lighting. Laminated wood flooring throughout the home. All bedrooms are located on the 2nd floor. Conveniently located by all major highways. Estimated completion date is mid November. Temporary no showings.','0.0413','11','EcuaHomes','','Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Northwest Houston','Central Gas','0','LT 2 BLK 1 ECUA HOMES ON TOWER','Other','1800','Other','','','1','Never Lived In','2','Convection Oven,Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','1 - Aldine','ANDERSON ACADEMY','CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS','DREW ACADEMY','Temporarily No Showings','Builder','2','Traditional','Highland Heights','315','2.5119','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','213995204','1666592292','213995204','2022-10-23T23:22:28.943','44355738','Sam Kurian','Texas Signature Realty','','','29.582317','-95.772988','16','77469','4','180000.00','Active','Rochelle','215','Street','Richmond','2','0','4','1373','Single-Family','Beautiful and Cozy Single-Story, Single-Family Home in Richmond, TX. Home has wood paneling in the living room which keeps it pretty cool even in the warm summer. \r\n\r\nHome is located very close to downtown Richmond and has 4 bedrooms and 2 full bathrooms. Seller purchased this home and added a huge master bedroom to it - Master bedroom has attached bath, walk-in closet, is carpeted and Air-Conditioned space. Seller made a lot of updates to the home including but not limited to the addition of a whole new master bedroom, a master bath, walk-in closet, laundry area and an overally update of the home. This address is centrally located close to all amenities. No HOA in the area. Would make a great home for a first-time home buyer or an investor. \r\n\r\nHome comes with cooking range, microwave and fridge. Laundry hook-ups available.','0.0976','30','','','','','Sellers Disclosure','1','','','Fort Bend South/Richmond','No Heating','0','SAM MELLON ADDN, BLOCK 2, LOT 31','Cleared','4250','Appraisal District','','','0','','0','','0','','','','','Composition','33 - Lamar Consolidated','PINK ELEMENTARY SCHOOL (LAMAR)','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Lockbox Front','Seller','1','Traditional','Sam Mellon Add','1100','2.3748','Public Water','1965','Appraisal District'); --> New record created successfully