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-21T07:07:59.950' ,`MLSNumber` = '45324625' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471078' ,`Longitude` = '-95.510416' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '724572.00' ,`Status` = 'Active' ,`StreetName` = 'Camille Park' ,`StreetNumber` = '1918' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 45324625 - Built by Toll Brothers, Inc. - Ready Now! ~ The popular 1.5 story Turner plan is filled with amazing features. The covered entry leads into a dramatic foyer with two-story ceiling. Glass doors and sloped ceiling in the office give an elegant yet private feel and is large enough for two work spaces. Your guests will appreciate the bedroom suite with full bath and walk-in closet just off the great room. Enjoy entertaining on movie night in the media room or relaxing in the upstairs flex/game room. The great room features 12-foot ceilings and is open to a desirable kitchen with large island, an abundance of cabinets, butler\'s pantry and walk-in pantry. The casual dining area is conveniently located off the kitchen with views to the backyard. A secluded and relaxing primary bedroom includes a tray ceiling and en-suite with a luxurious freestanding tub, ultra shower and spacious walk-in closet. Located in acclaimed Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9511' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Sienna - Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666359820' WHERE `Matrix_Unique_ID` = '199716300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:21:59.347' ,`MLSNumber` = '96477852' ,`ListAgentFullName` = 'Maria Aguirre' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872589' ,`Longitude` = '-94.878519' ,`PhotoCount` = '15' ,`PostalCode` = '77535' ,`RoomCount` = '7' ,`ListPrice` = '565990.00' ,`Status` = 'Active' ,`StreetName` = 'Champions Forest' ,`StreetNumber` = '11818' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Hastings is a two-story new house floor plan with 4 bedrooms and 3.5 bathrooms, and a variety of welcoming layout and design features and options. Downstairs is a formal dining room, a kitchen with an optional island and a breakfast nook, a spacious family room with an optional fireplace, a private master bedroom with a large walk-in closet in the unique owners retreat, a conveniently located walk-in utility room, and a covered patio. Upstairs are all secondary bedrooms and an oversized game room.The home styles offered in Champions Forest will range from traditional to modern exteriors with up to 4-car garages. Champions Forest is just minutes away from I-10 placing you near a variety of local shopping, dining, entertainment and recreational choices to enjoy close-by. Quick commutes to Baytown, Dayton and Grand Parkway are just within minutes as well. SOME PICTURES ARE FOR ILLUSTRATION PURPOSE ONLY. MATERIAL AND COLORS WILL VARY' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Anglia Homes, LP' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14, Blk 2, Sec 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14518' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Champions Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666359820' WHERE `Matrix_Unique_ID` = '203214129' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:18:32.007' ,`MLSNumber` = '48640258' ,`ListAgentFullName` = 'Jennifer Hernandez' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.997568' ,`Longitude` = '-96.652482' ,`PhotoCount` = '18' ,`PostalCode` = '77957' ,`RoomCount` = '6' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 111' ,`StreetNumber` = '449' ,`StreetSuffix` = '' ,`City` = 'Edna' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 bedroom 2 bath home in Edna. Ready for you to make it your own with completion of unfinished projects. Home is near businesses, shops, and Hwy 59.' ,`Acres` = '0.34' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A5072 SMITH, HENRY, TRACT -100X150FT-, ACRES 0.34' ,`LotDesciption` = 'Other' ,`LotSize` = '14810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '246 - Edna' ,`SchoolElementary` = 'EDNA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'EDNA HIGH SCHOOL' ,`SchoolMiddle` = 'EDNA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'NA' ,`TaxAmount` = '1446' ,`TaxRate` = '1.8589' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666359820' WHERE `Matrix_Unique_ID` = '207493195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:21:48.833' ,`MLSNumber` = '72949069' ,`ListAgentFullName` = 'Susan Brock' ,`ListOfficeName` = 'Brock & Foster Real Estate' ,`SellingAgentFullName` = 'Haidar Alkhalisi' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '29.690424' ,`Longitude` = '-95.474590' ,`PhotoCount` = '33' ,`PostalCode` = '77401' ,`RoomCount` = '7' ,`ListPrice` = '445000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mimosa' ,`StreetNumber` = '5224' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellaire' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1241' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity in prime Bellaire location. A desirable and friendly neighborhood in the City of Bellaire. On a quiet street with mature trees and new construction everywhere. Zoned to Lovett Elementary, Pershing Middle and Bellaire High. This home is ready for your renovations and updates offering tremendous potential. The extra room makes a great office space or play room overlooking the lovely, tranquil backyard. Blocks from Bellaire High, Bellaire Aquatic Center. Buy now, build later. Never flooded. Survey on file - check your lot fit in advance!' ,`Acres` = '0.1686' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 32 BLK 1 BRAEBURN GARDENS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7345' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeburn Gardens' ,`TaxAmount` = '12055' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359821' WHERE `Matrix_Unique_ID` = '208986705' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:09:41.290' ,`MLSNumber` = '59489354' ,`ListAgentFullName` = 'Sally James' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.002806' ,`Longitude` = '-95.555118' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '13' ,`ListPrice` = '664000.00' ,`Status` = 'Active' ,`StreetName` = 'Champions Cove' ,`StreetNumber` = '9715' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stately 5-bedroom executive home with 2 bedrooms, 2.5 bathrooms down sits on a quiet cul-de-sac lot in the highly desirable Estates at Windrush. Soaring 2-story entry leads to large kitchen, open to the family room & features granite counters, double ovens, gas stovetop, built-ins, & views of the backyard/covered patio. Off the family room is a 2nd bedroom/full bathroom, another private entrance to the backyard & a 2nd stairway leading upstairs. Custom features include tons of built in storage with 2 desk areas, large gameroom, media/bonus room. Spacious primary suite with bay windows, ensuite bathroom with builtins. Recent updates: *ROOF REPLACED 8/26/22* interior walls painted, tile/grout/carpet professionally cleaned, AC unit serviced, all toilets replaced, new smoke detectors installed, stucco recently painted. The theme of this stately home is plenty of space/storage, including the 4 car tandem garage within close proximity to Hwy 249 & Vintage shopping center.' ,`Acres` = '0.2007' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 ESTATES AT WINDRUSH SEC 4 AMD' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8742' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates At Windrush Sec 04 Amd' ,`TaxAmount` = '11455' ,`TaxRate` = '2.3266' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666359821' WHERE `Matrix_Unique_ID` = '209527660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:23:59.153' ,`MLSNumber` = '31354779' ,`ListAgentFullName` = 'David Ortiz' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.335841' ,`Longitude` = '-94.943238' ,`PhotoCount` = '44' ,`PostalCode` = '77568' ,`RoomCount` = '6' ,`ListPrice` = '494999.00' ,`Status` = 'Active' ,`StreetName` = 'North White Heron' ,`StreetNumber` = '9' ,`StreetSuffix` = '' ,`City` = 'La Marque' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2230' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Bayfront view with canal! Omega Bay beauty overlooking Highland Bayou bay. 3/2 upstairs totally updated floor, cabinets, tops, appliances, showers, fixtures, windows and doors etc.. Replaced roof, boat house decks, cat walk and porches. Downstairs open concept can be Apartment, game room, man cave, she shed, you get the Idea oh it has a full bath too.This home is perfect for entertaining, watching the 4th and new year fireworks or evening sunsets. Back yard has room for a pool.' ,`Acres` = '0.124' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Omega Bay' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'lot 9 abst 7 cbundick, Sur&abst640jcleaguesurlot9 O.B. secB' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`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` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Omega Bay' ,`TaxAmount` = '9493' ,`TaxRate` = '2.803' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359821' WHERE `Matrix_Unique_ID` = '209660099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:22:41.667' ,`MLSNumber` = '7522398' ,`ListAgentFullName` = 'Dianne O\'Brien' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.090288' ,`Longitude` = '-95.256244' ,`PhotoCount` = '45' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '747000.00' ,`Status` = 'Active' ,`StreetName` = 'Eaglewood Forest' ,`StreetNumber` = '20608' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3794' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A REAL SHOWSTOPPER! Highly coveted custom 1-story with all the bells and whistles located in the beautiful Oakhurst neighborhood of Eaglewood Estates. A light, bright and sophisticated decor theme is featured throughout this meticulously maintained home that looks and feels like brand new construction. Upgraded to the max with quartz, marble and granite countertops, designer lighting, wood and tile floors throughout (no carpet). Plus, automatic blinds, plantation shutters, custom millwork throughout, high ceilings, art niches, loads of recessed LED lighting, plus built-ins galore! Oversized 3-car garage with epoxy floors, built-in cabinets and staircase to a walk-up attic. Water Softener! Generac Generator! New Roof and Gutters - April 2022. Great location close to US59, IAH Airport, Grand Parkway, Hospitals and new HEB Center. This one won\'t last!' ,`Acres` = '0.2879' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S440002 - EAGLEWOOD AT OAKHURST 02, BLOCK 2, LOT 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '12542' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`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` = 'Eaglewood at Oakhurst' ,`TaxAmount` = '11253' ,`TaxRate` = '3.0681' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359821' WHERE `Matrix_Unique_ID` = '210352189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:52:57.507' ,`MLSNumber` = '28441117' ,`ListAgentFullName` = 'Vania Yagelski' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820695' ,`Longitude` = '-95.733832' ,`PhotoCount` = '38' ,`PostalCode` = '77449' ,`RoomCount` = '8' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Rainshore' ,`StreetNumber` = '3503' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2330' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the beautiful house with high ceiling, gourmet kitchen with granite countertops, kitchen island and stainless steel appliances. The first floor has tile and extensive engineered wood floor, and includes the formal living/dining area, open concept kitchen into the large family room, utility room and 1/2 bath. The second floor includes 3 bedrooms and 2 full baths, plus a small flex room that can be used as a study or nursery. Refrigerator, washer and dryer are included. The garage currently has a insulated divider wall that is currently being used as an extra bedroom, or the wall can be removed to be converted back to 2 car garage. The back yard is completely fenced with a covered patio for your enjoyment. No back yard neighbors! House has never flooded!! Schedule your private showing today!!' ,`Acres` = '0.1136' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 4 RAINTREE VILLAGE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Raintree Village Sec 6' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359821' WHERE `Matrix_Unique_ID` = '210739436' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:50:13.600' ,`MLSNumber` = '60249858' ,`ListAgentFullName` = 'Bertha Saenz' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Daniela Hernandez' ,`SellingOfficeName` = 'Framework Properties' ,`Latitude` = '29.803849' ,`Longitude` = '-95.358126' ,`PhotoCount` = '15' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '339900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Elser' ,`StreetNumber` = '4808' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1607' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Centrally located, easy access from major freeways, within minutes from downtown and all of H-towns city dining and attractions. Walking distance to Moody park, enjoy the nearby bike trails and metro rail for easy commute. This home features 4 bedrooms, 2 baths, living room open to dining area, new kitchen appliances, flex room, utility room inside of home, spacious backyard and move in ready!' ,`Acres` = '0.1263' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 88 IRVINGTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Irvington' ,`TaxAmount` = '4352' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359822' WHERE `Matrix_Unique_ID` = '210835849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:32:59.877' ,`MLSNumber` = '54211720' ,`ListAgentFullName` = 'Maggie Pearson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569045' ,`Longitude` = '-95.031201' ,`PhotoCount` = '50' ,`PostalCode` = '77586' ,`RoomCount` = '10' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Cove' ,`StreetNumber` = '2249' ,`StreetSuffix` = 'Way' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tucked away in the prestigious waterfront, gated community, The Sanctuary, an unparalleled luxury awaits. From the captivating architectural features and the high-end finishes to the lush landscaping, you’ll quickly learn you’ve arrived somewhere special. Soaring ceilings add to the abundance of natural light throughout, creating a comfortable oasis. The open concept living areas flow seamlessly from one room to the next creating an ideal space for hosting large gatherings. This unique layout offers a secluded primary retreat located on the first floor, a parlor for conversation with guests, formal dining and an open concept kitchen to living room. Upstairs are three oversized bedrooms, an extravagant game room & media room, plus a Texas sized office/bonus room. Step outside to two garages, a secure driveway gate and outdoor kitchen with seating to boot! You won\'t want to leave this Waterfront community. Sunrise to sunset this stunning custom home has everything.' ,`Acres` = '0.2111' ,`Area` = '7' ,`BuilderName` = 'Imperial Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 4 LAKE COVE SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9196' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Lake Cove Sec 11 Final' ,`TaxAmount` = '10890' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359822' WHERE `Matrix_Unique_ID` = '210917371' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:20:35.263' ,`MLSNumber` = '87950892' ,`ListAgentFullName` = 'Sofia Arzate' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564397' ,`Longitude` = '-95.520949' ,`PhotoCount` = '22' ,`PostalCode` = '77459' ,`RoomCount` = '4' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Mateer Manor' ,`StreetNumber` = '1403' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2173' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The seller is very very motivated!! \r\nBeautiful One Story home on Cul-De-Sac!! with solar panels and water softener, Very well maintained...Large kitchen with granite countertops, gas range/oven, microwave, refrigerator, and plenty of cabinet space! formal dining room. The large master bedroom has a bathroom with vanity with double sinks and a large walk-in shower and walk-in closet, a Covered patio in the backyard, and plenty of room for a play area. Easy access to major highways 6 and fort bend parkway toll, shopping center, dining, and entertainment.\r\n\r\nAbout 12 miles to the Medical Center.\r\n\r\nThis one will not last long!! Thank you for showing.' ,`Acres` = '0.1533' ,`Area` = '38' ,`BuilderName` = 'D.R Horton' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARKS EDGE SEC 8, BLOCK 2, LOT 37' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6678' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Parks Edge Sec 8' ,`TaxAmount` = '4938' ,`TaxRate` = '3.24' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666359822' WHERE `Matrix_Unique_ID` = '210996067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:59:28.220' ,`MLSNumber` = '60774401' ,`ListAgentFullName` = 'Rebecca Morgan' ,`ListOfficeName` = 'Houston Associates Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.557362' ,`Longitude` = '-95.751198' ,`PhotoCount` = '30' ,`PostalCode` = '77469' ,`RoomCount` = '5' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Persimmon' ,`StreetNumber` = '2919' ,`StreetSuffix` = 'Grove' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2385' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for an out of the city View- come and see this FULL-ON beautiful rare serene view on a bayou water lot. Refreshed home!! Freshly painted interior and garage, new GE stainless appliances including GE Cafe cooktop with Stainless Vent Hood, new epoxied garage flooring and new hardware. Shows like new!! Dunwoody plan, open concept with 2 bedrooms, 2.5 baths and study enclosed by French doors as well as hardwood flooring throughout- not a tiled or carpeted home. Stone gas fireplace in spacious main living area with fan and crown molding. Spacious Master Bedroom (with hardwoods). Master Shower has new frameless glass shower, large jetted tub and large Master Closet. New pendant lights over large breakfast island and dining light are gorgeous. This home offers pull out racks in kitchen cabinets and beautiful upgraded backsplash. Has Sprinkler System, tandem garage and extended rear patio. This is a 55+ community.' ,`Acres` = '0.1641' ,`Area` = '30' ,`BuilderName` = 'Pulte Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEL WEBB RICHMOND SEC 1, BLOCK 1, LOT 5' ,`LotDesciption` = 'Ravine,Water View' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb Richmond Sec 1' ,`TaxAmount` = '10643' ,`TaxRate` = '2.9548' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359822' WHERE `Matrix_Unique_ID` = '211063707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:51:38.367' ,`MLSNumber` = '61118467' ,`ListAgentFullName` = 'Melissa Seureau' ,`ListOfficeName` = 'RE/MAX Preferred Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.128935' ,`Longitude` = '-95.819442' ,`PhotoCount` = '24' ,`PostalCode` = '77447' ,`RoomCount` = '9' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Creek Bend' ,`StreetNumber` = '24445' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEE Home!! 1 story ranch style home with 36x36 metal building on an acre in Waller County, Texas. Exterior of home is brick and vinyl, home has sweet porch and large back covered patio. Lots of Mature Oak Trees! Large detached garage is 20x20 with a carport. Home has a very large formal living and dining room that could be used as a massive game room. Den is good size too. Primary bedroom has double closets, the en-suite bath has double sinks and an adorable corner shower with tub. 2nd bedroom has a 1/2 bath. 3rd bedroom is on the opposite side of home has easy access to the 3rd bathroom with a shower. Kitchen has eat-in breakfast and TWO pantries and an extra large sink. Windows replaced by Anderson. 2 AC systems with dehumidifiers. Tuff Shed is 11x9. Metal Building has 5 roll-up doors and man door.' ,`Acres` = '1' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S433500 CLEAR CREEK FOREST 5 LOT 12 ACRES 1.0' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '8' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Clear Creek Forest' ,`TaxAmount` = '5693' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666359822' WHERE `Matrix_Unique_ID` = '211506474' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:12:29.877' ,`MLSNumber` = '40557774' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.010975' ,`Longitude` = '-95.162400' ,`PhotoCount` = '21' ,`PostalCode` = '77346' ,`RoomCount` = '4' ,`ListPrice` = '446900.00' ,`Status` = 'Active' ,`StreetName` = 'Pinehurst Trail' ,`StreetNumber` = '20110' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2683' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 1-story home with a pool situated on almost a 1/2 acre. Home features a large circular drive with an oversized 2-car garage w/ built-ins. Home features fresh interior paint, new carpet in the bedrooms and a new ROOF! Upon entry, a spacious formal living/dining room leads into an updated kitchen. Kitchen features newer shaker style cabinets with quartz counters and new stainless steel appliances including a gas cooktop, electric wall oven and microwave. Kitchen opens to the family room with vaulted ceiling and gas fireplace. Luxurious primary suite is located along the East side of the home and features an ensuite w/dual sinks, oversized shower and jetted tub plus a walk-in closet w/custom built-ins. An adjacent sitting room w/gas fireplace features glass doors which lead out to the covered patio. Split floor plan features 3 secondary bedrooms w/2 full baths along the NW side of the home. A huge covered patio leads out to a sparkling pool and large backyard. Move-In Ready!' ,`Acres` = '0.4582' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 KINGS RIVER VILLAS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings River Villas' ,`TaxAmount` = '7837' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359823' WHERE `Matrix_Unique_ID` = '211581452' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:18:33.960' ,`MLSNumber` = '7236951' ,`ListAgentFullName` = 'Amy Vanterpool' ,`ListOfficeName` = 'Elite 5 Star Realty' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.136872' ,`Longitude` = '-95.061072' ,`PhotoCount` = '20' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '520000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Martes' ,`StreetNumber` = '22903' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All one level three bedrooms two bathrooms, canal front home in Terramar Beach. Windows have storm shutters you will really enjoy all the deck and patio space as well as the downstairs storage and yard area. Terramar community offers a pool, boat ramp, beach access, frisbee golf course, and pavilion area. Terramar is close to Sea Isle restaurant, marina, & stores. Buyer to verify room dimensions and details of the property. Everything stays with the sale of the property. Property is being sold AS IS.' ,`Acres` = '0.123' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 12 LOT 6 BLK 8 TERRAMAR BEACH SEC 4' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`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` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Terramar 4' ,`TaxAmount` = '7438' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359823' WHERE `Matrix_Unique_ID` = '211902844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:30:34.843' ,`MLSNumber` = '98689940' ,`ListAgentFullName` = 'Whitney Pugh' ,`ListOfficeName` = 'Legacy South Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.439491' ,`Longitude` = '-95.262384' ,`PhotoCount` = '21' ,`PostalCode` = '77511' ,`RoomCount` = '9' ,`ListPrice` = '321500.00' ,`Status` = 'Active' ,`StreetName` = 'Maggie Trail' ,`StreetNumber` = '1652' ,`StreetSuffix` = 'Drive' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2131' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this lovely K. Hovnanian home located in the well- desired subdivision of Sunset Ranch! The Juniper II floor plan is a very popular plan due to the openness of the main areas. This home features a huge kitchen with tons of cabinet space, island with sink, breakfast bar, & beautiful granite counters. The study is located directly off the living room and features a closet, allowing for this room to be a 4th bedroom if desired. Many updates have been made to this home, including a leaf filter system to gutters, & a concrete walkway extension to new 12x10 Tuff Shed (with electricity). The owner\'s suite is large with high ceilings, double sinks, walk- in closet, and a nice soaking tub! Close to schools, quick access to highway 6 & 288. Check it out today!' ,`Acres` = '0.1405' ,`Area` = '5' ,`BuilderName` = 'K. HOV' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNSET RANCH SEC 1 (A0420 HOOPER & WADE) (ALVIN) BLK 2 LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Ranch Sec 1' ,`TaxAmount` = '7138' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359823' WHERE `Matrix_Unique_ID` = '211945176' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:49:07.980' ,`MLSNumber` = '38838526' ,`ListAgentFullName` = 'Suzan Zachariah' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.950557' ,`Longitude` = '-95.291007' ,`PhotoCount` = '31' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Oyster' ,`StreetNumber` = '510' ,`StreetSuffix` = 'Street' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1426' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Octoberfest SALE! This home offers space for outside living for friends and family as well as inside. There are so many pluses with the area from under the house for relaxing and visiting as well as where the current owners have a volleyball net/court for games, & a fenced area for dogs. There are stairs on both sides of the home. From one set, you will enter the living area that is open to the kitchen, dining area and a bonus living area. There are bedrooms to the right with the master and master bath as well as the full bath and another bedroom. The third bedroom and washer/dryer rooms are off the gathering area at the rear of the home. This is where there is another set of stairs. This home has easy access to kayaking in the bay off the Intracoastal and views of the bridge and the ships going by, as well as an easy walk to the beach off Oyster St. The sellers are buying another home in Surfside.The two neighbors are selling for other reasons; one neighbor is moving to Lake Jackson.' ,`Acres` = '0.225' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE, BLOCK 517, LOT 9-LOT 11 E/2, SURFSIDE,A0051 F J CA' ,`LotDesciption` = 'Water View' ,`LotSize` = '9801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359823' WHERE `Matrix_Unique_ID` = '212011523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:43:25.367' ,`MLSNumber` = '58118955' ,`ListAgentFullName` = 'Erika Hernandez' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874052' ,`Longitude` = '-95.629628' ,`PhotoCount` = '39' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Hertford Park' ,`StreetNumber` = '6803' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This lovely & unique Hertford Home features 2 stories (1st floor has common areas- kitchen, living, dining & half bath) & 2nd floor has primary bedroom plus 2 bedrooms, Laundry and access to garage apartment via walkway outdoors. The Studio Garage Apartment is perfect for a quiet WORK FROM HOME space, maybe an extended stay by a friend/family member, maybe a second small group. The choice is all yours. Also, new paint and ALL NEW carpet upstairs and recently updated flooring in living room. DO NOT PASS THIS UP !!! Call for appointment today. Hablamos espanol, llama hoy para tu cita.' ,`Acres` = '' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 44 BLK 1 HEARTHSTONE PLACE SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6285' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '387' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Place Sec 01' ,`TaxAmount` = '5524' ,`TaxRate` = '3.171' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359823' WHERE `Matrix_Unique_ID` = '212040400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:26:09.360' ,`MLSNumber` = '33392308' ,`ListAgentFullName` = 'Nick Janke' ,`ListOfficeName` = 'Janke and Co Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.918235' ,`Longitude` = '-95.192450' ,`PhotoCount` = '35' ,`PostalCode` = '77044' ,`RoomCount` = '10' ,`ListPrice` = '759000.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade Caverns' ,`StreetNumber` = '16347' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! This is a stunning 4 bedroom, 4 1/2 bath with perfect cinematic media room, tons of builder upgrades, on a large lot and NO BACK neighbors. This beautifully maintained home has windows galore with a tiered ceiling entrance and a sweeping Romeo and Juliet style staircase. The open and inviting kitchen (bring your chef!) has impressive granite counters, stainless steel appliances and a stove inset encased in stone. Just off the kitchen is a sunroom and breakfast area. The towering fireplace is floor to ceiling & stone front. Enjoy the convenience of dual staircases, a formal dining room, study/bonus room an open game room w balcony that overlooks the back yard. The bedrooms have walk in closets and granite, double sinks in guest bath. This is a home built by Award Winning J PATRICK HOMES, known for luxury amenities and finishes throughout the home. There\'s much more to see, schedule a showing today! Located in Summerwood only a short distance from Lake Houston, near everything.' ,`Acres` = '0.3644' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 SUMMERWOOD SEC 30' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '15874' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '795' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Summerwood Sec 30' ,`TaxAmount` = '12689' ,`TaxRate` = '2.7932' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359824' WHERE `Matrix_Unique_ID` = '212064432' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:11:40.190' ,`MLSNumber` = '29794274' ,`ListAgentFullName` = 'Elizabeth Boles' ,`ListOfficeName` = 'One10 Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.448640' ,`Longitude` = '-94.652934' ,`PhotoCount` = '27' ,`PostalCode` = '77650' ,`RoomCount` = '4' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandollar - lot 58' ,`StreetNumber` = '970' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1491' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction beachside with a pool!! 4 bedroom, 2 bath with all of the deck space you could want to enjoy the views of Galveston Bay. This home features an open concept kitchen to the living room - perfect for entertaining! Whether you choose to make this your home, vacation home, or an amazing rental income opportunity, you will not want to miss this gem in progress.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'FIC Construction LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 58 CLOON SUB #4' ,`LotDesciption` = 'Water View' ,`LotSize` = '5000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cloon Sub 4' ,`TaxAmount` = '2513' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666359824' WHERE `Matrix_Unique_ID` = '212105711' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:26:57.767' ,`MLSNumber` = '59184317' ,`ListAgentFullName` = 'Elisa Hanson-Linton' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047510' ,`Longitude` = '-95.373733' ,`PhotoCount` = '22' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '272900.00' ,`Status` = 'Active' ,`StreetName` = 'Winter Maple' ,`StreetNumber` = '22619' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better than new 1-story, 1535 sq ft open concept living. Home has been tastefully decorated with the highly sought-after gray scale pallet with a hint of color. Spacious family and dining room area to host all your family and friends. Gourmet island kitchen acts as a center piece in the heart of the home waiting to prepare all your delicious meals. Large primary suite located in the rear for true privacy. Owners baths has double sinks and walk-in closet. Two additional bedrooms flanked by a bathroom. Easement located to the front of the home so you have more use of your backyard.' ,`Acres` = '0.1648' ,`Area` = '12' ,`BuilderName` = 'Dr. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 4 BRECKENRIDGE WEST SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge West Sec 9' ,`TaxAmount` = '573' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359824' WHERE `Matrix_Unique_ID` = '212114606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:32:42.997' ,`MLSNumber` = '71784076' ,`ListAgentFullName` = 'Pamela DeBlasio' ,`ListOfficeName` = 'Lake Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.682902' ,`Longitude` = '-95.035657' ,`PhotoCount` = '42' ,`PostalCode` = '77351' ,`RoomCount` = '9' ,`ListPrice` = '1000000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodhead' ,`StreetNumber` = '120' ,`StreetSuffix` = 'Circle' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully understated, open waterfront home with stunning sunset views. This home was made for entertaining inside and out but cozy enough for two. Straight through the front door the lake view awaits. Open-concept, spacious living, kitchen, dining spaces with wood-look tile throughout. Big bedrooms, large home office perfect for overflow guests and huge game room. OUTSIDE IS WHERE THE PARTY IS...huge flagstone covered patio \"Palapa\" style, complete with wine fridge, utility fridge, dishwasher and two sinks spread out between 3 granite topped islands. Outdoor access only bathroom and separate shower for convenience. AND...in-ground pool overlooking the lake that is just the icing on the cake. Enjoy the large boathouse with boat and jet ski lifts, covered and uncovered decks all finished out with composite decking for easy maintenance. This lake home has it all! Call today for an appointment!' ,`Acres` = '0.0067' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'OAK TERRACE ESTATES SECTION 1 LOT 14, 15 & .231 AC OF RESERV' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Terrace Estates' ,`TaxAmount` = '15156' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359824' WHERE `Matrix_Unique_ID` = '212163742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:26:32.627' ,`MLSNumber` = '48128723' ,`ListAgentFullName` = 'Carolyn Payton' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669681' ,`Longitude` = '-95.485160' ,`PhotoCount` = '35' ,`PostalCode` = '77096' ,`RoomCount` = '6' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Wigton' ,`StreetNumber` = '5642' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pre-forclosure . All Offers must be approved by Lender. NEVER FLOODED. This 4/2 & Garage Apt 2/1 has been remodeled. Professionally Renovated Kitchen & Baths! Spacious & Flexible Floorplan Offers a Game Room/Flex Room, Mud Room,& Full Quarters (above the Garage).Spacious Formal Dining Room w/ Brushed Nickel Chandelier & Bltin Serving Buffet.Remodeled & Expanded Kitchen Boasts Custom Style Raised Panel Wood Cabinets (with Glass Front),SS Gas Range,SS Double Ovens,SS Vent Hood,Granite Counters,Tile Backsplash,Custom Designed Breakfast Bar, & Butlers Pantry with Bltin Wine Rack.Den Opens to Gameroom/Flex Room - Open Flowing Floorplan.' ,`Acres` = '0.1983' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Pre-Foreclosure,Sellers Disclosure,Short Sale' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 5 BARKLEY SQUARE SOUTH SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkley Square South Sec 01 R/' ,`TaxAmount` = '8184' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359824' WHERE `Matrix_Unique_ID` = '212487021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:50:00.900' ,`MLSNumber` = '97522260' ,`ListAgentFullName` = 'Lauren Harris' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800986' ,`Longitude` = '-95.402646' ,`PhotoCount` = '33' ,`PostalCode` = '77008' ,`RoomCount` = '12' ,`ListPrice` = '1899000.00' ,`Status` = 'Active' ,`StreetName` = '17th' ,`StreetNumber` = '325' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Light filled contemporary home blended with classic Heights style in this new luxury build. Charming front porch and gated front yard. Entryway greets you with soaring 10 foot high ceilings, gorgeous hardwood flooring, and neutral paint colors. An entertainer’s dream layout: state-of-the-art island kitchen with quartz waterfall countertops, Wolf range + double ovens, Sub Zero refrigerator, butler’s pantry with wine fridge, formal dining room, breakfast room + massive living room with built in cabinetry. Covered patio with summer kitchen, Big Green Egg, Napoleon grill + burner that overlook the turfed lawn and swimming pool! 1/1 guest house just off of the summer kitchen. Second level with generously sized primary suite, game room, two secondary bedrooms + full bathroom. Home is on an oversized lot and is walking distance to hike and bike trail, iconic dining + shopping on 19th street. A Heights home that checks every box!' ,`Acres` = '0.1515' ,`Area` = '9' ,`BuilderName` = 'IBuild Concepts LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 36 & 37 BLK 120 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed,Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '9691' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359825' WHERE `Matrix_Unique_ID` = '212511168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:59:39.687' ,`MLSNumber` = '97215260' ,`ListAgentFullName` = 'Tisha Lockwood' ,`ListOfficeName` = 'Southern Style Realty' ,`SellingAgentFullName` = 'Tisha Lockwood' ,`SellingOfficeName` = 'Southern Style Realty' ,`Latitude` = '30.167878' ,`Longitude` = '-95.189384' ,`PhotoCount` = '21' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '369900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sage Villa Dr' ,`StreetNumber` = '23626' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully decorated Perry one story in walking distance to Elementary school, parks, and community pool. Home features 4 large bedrooms all with walk in closets, 3 full bathrooms, a home theater, Island kitchen with granite counters, breakfast room, corner fireplace in living room, open concept split floor plan, wood floors through out main living areas, laundry with room for extra fridge or deep freeze. Epoxied garage floors, Oversized covered back porch with mister system to stay cool int the Texas heat.' ,`Acres` = '0.1811' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S921115 - TAVOLA 15, BLOCK 2, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7887' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '9726' ,`TaxRate` = '3.3731' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359825' WHERE `Matrix_Unique_ID` = '212740289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:23:10.700' ,`MLSNumber` = '3926855' ,`ListAgentFullName` = 'Bob Azzarello' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.984495' ,`Longitude` = '-95.610153' ,`PhotoCount` = '33' ,`PostalCode` = '77070' ,`RoomCount` = '6' ,`ListPrice` = '454900.00' ,`Status` = 'Active' ,`StreetName` = 'Laneview' ,`StreetNumber` = '12414' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3306' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning corner lot on a semi-secluded street in Lakewood Forest. Freshly landscaped and meticulously cared for, this home is ready for large gatherings. Generous primary bedroom down features an equally generous ensuite bath. Warm up and enjoy time in the family room near the gas fireplace, french doors lead out to the patio. Formal dining space with large wet bar is fantastic for hosting events. Kitchen boasts beautiful custom granite, tons of storage, 2 cooktops, and breakfast nook, and also features access to the covered patio and air-conditioned/ heated 3-car garage. Upstairs you will find 3 additional bedrooms, a game room with wet bar, and a theatre room ready to entertain.The backyard oasis has several gardening beds, a green house, and finally a beautifully maintained heated pool with water feature and spa. Pool is screened in to enjoy year-round. Area behind garage can be green space. Tankless water heater, newer roof. This was the owners\' dream home, now it can be yours.' ,`Acres` = '0.2204' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 24 LAKEWOOD FOREST SEC 11' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest' ,`TaxAmount` = '6726' ,`TaxRate` = '2.3988' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359825' WHERE `Matrix_Unique_ID` = '213007169' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:14:28.010' ,`MLSNumber` = '21571682' ,`ListAgentFullName` = 'Michael Terry' ,`ListOfficeName` = 'Goldenlight Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768258' ,`Longitude` = '-95.727856' ,`PhotoCount` = '43' ,`PostalCode` = '77450' ,`RoomCount` = '11' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Shillington' ,`StreetNumber` = '1146' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attractive frequently maintained home with a view to Mason Creek. Back gate opens to green space that adjoins to Harris County’s Mason Creek Hike & Bike Trail. The Kitchen includes a 36\" Thermador range, Viking double oven, LG refrigerator and a new Cummings natural gas emergency generator that powers the complete house and swimming pool. The detached garage has a large workshop area with built in shelves, work benches and storage in the floored garage attic. There is a screened outdoor patio with a cabinet and outdoor television that remains. The steel Bar B Que pit remains with the house. The very attractive swimming pool has pebble tec. The pool cleaner will remain. The window treatments will remain. The front windows have custom wood shutters. The house alarm, lights and sprinkler system are wifi controlled. Room sizes should be verified by the buyer. All doors and windows are double pane. Seller said no flooding during Harvey.The seller\'s Real Estate agent is related to the seller' ,`Acres` = '0.2014' ,`Area` = '36' ,`BuilderName` = 'Kickerillo' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 21 NOTTINGHAM COUNTRY SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'NOTTINGHAM COUNTRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Nottingham Country Sec 07' ,`TaxAmount` = '7019' ,`TaxRate` = '2.3693' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359825' WHERE `Matrix_Unique_ID` = '213073796' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:37:01.357' ,`MLSNumber` = '53664121' ,`ListAgentFullName` = 'Garie Muenchausen' ,`ListOfficeName` = 'Walter Jolley Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.139972' ,`Longitude` = '-95.403246' ,`PhotoCount` = '37' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsway Park' ,`StreetNumber` = '31006' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FRESH & READY FOR YOU!SPACIOUS 2 STORY W/MASTER DOWN, STUDY DOWN,GAMEROOM UP;FORMAL DINING ROOM,LARGE FAMILY ROOM W/FIREPLACE-SPACIOUS KITCHEN W/REFRIGERATOR, 42\" CABINETS & OPEN TO FAMILY ROOM WHICH BOASTS WALLS OF WINDOWS W/STREAMING LIGHT INTO THE HOME.THIS HOME IS LOCATED ON A CORNER LOT & THE YARD IS OVERSIZED & FULLY FENCED FEATURING A DECK FOR YOUR ENJOYMENT.JUST BRING YOUR TABLE, UMBRELLA & CHAIRS!!UPSTAIRS IS THE JACK & JILL BATH &, AN ADDITONAL BATH OFF ONE OF THE SECONDARY BEDROOMS. DON\'T OVER LOOK THE STUDY AREA IN THE GAMEROOM.SPACIOUS PARKING FOR YOUR CARS W/THIS 3 CAR DETATCHED GARAGE W/A SINGLE DRIVEWAY THAT OPENS TO A DOUBLE AREA FOR PARKING. A/C & HEAT REPLACED IN SUMMER, 2022. BE IN BEFORE THE HOLIDAYS TO ENJOY YOUR NEW HOME & NEIGHBORHOOD.' ,`Acres` = '0.2531' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS FOREST 01, BLOIMPERIAL OAKCK 3, LOT 6' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '11025' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Forest 01' ,`TaxAmount` = '8367' ,`TaxRate` = '2.7627' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359825' WHERE `Matrix_Unique_ID` = '213100167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:30:15.250' ,`MLSNumber` = '50209023' ,`ListAgentFullName` = 'Janelle Williams' ,`ListOfficeName` = 'RE/MAX Cinco Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711940' ,`Longitude` = '-95.859908' ,`PhotoCount` = '7' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '870000.00' ,`Status` = 'Active' ,`StreetName` = 'Hunt Trace' ,`StreetNumber` = '27922' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the desirable IBIS LAKES section of Cross Creek Ranch. OUTDOOR LIVING is yours to enjoy with SPARKLING POOL & SPA plus fabulous COVERED OUTDOOR KITHCEN PAVILLON w/ remote controlled shade. Step inside this 2 story beauty that is ON POINT W/ DESIGNER TRENDS to find 4 bedrooms, 3 ½ baths. Highly sought after 2nd BEDROOM DOWN & EN SUITE BATH. Floorplan also includes a handsome STUDY and a CASUAL DINING AREA that opens to a spacious LIVING ROOM boasting SOARING CEILINGS. Stunning GOURMET KITCHEN is complete w/ ENORMUS GRANITE ISLAND, DBL OVENS & LOFTY PANTRY. Inviting Primary suite leads to luxurious bath featuring FREESTANDING TUB & separate shower. Primary CLOSET delights w/ CUSTOM BUILT INS. Head Upstairs to find GMRM + MEDIA and 2 More BRs! Hidden Storage opens to Attic for additional storage. SHUTTERS. 3 CAR GARAGE. CULDESAC. Zoned to Award winning KATY ISD....Walk/Bike to Adams JH / Jordan HS. Enjoy 60+ miles of trails, resort pools, dog park..and so much more in CCR!' ,`Acres` = '0.2333' ,`Area` = '36' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEK COVE AT CROSS CREEK RANCH SEC 5, BLOCK 2, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10162' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JAMES E RANDOLPH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '18451' ,`TaxRate` = '3.1375' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359826' WHERE `Matrix_Unique_ID` = '213107078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:20:06.110' ,`MLSNumber` = '23804421' ,`ListAgentFullName` = 'Jennifer Hill' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033823' ,`Longitude` = '-95.512962' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Butteroak Dr' ,`StreetNumber` = '17027' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous home, located in highly desirable Spring Creek Oaks. The home has been updated with double-paned windows and new hvac systems with transferrable warranty. Laminate wood look flooring added downstairs and all new kitchen appliances to the updated kitchen featuring your very own coffee bar. The laundry room has been opened and expanded. Great layout with multiple entertaining rooms. You will not be disappointed in all this home has to offer. Call for your appointment today!' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 14 Blk 2 Spring Creek Oaks' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8049' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '991' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Creek Oaks' ,`TaxAmount` = '' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359826' WHERE `Matrix_Unique_ID` = '213129526' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:37:58.800' ,`MLSNumber` = '4900569' ,`ListAgentFullName` = 'Steven Andognini' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.417103' ,`Longitude` = '-95.109349' ,`PhotoCount` = '48' ,`PostalCode` = '77517' ,`RoomCount` = '10' ,`ListPrice` = '539000.00' ,`Status` = 'Active' ,`StreetName` = 'Lago Circle' ,`StreetNumber` = '327' ,`StreetSuffix` = 'Drive' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2676' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home on 1 acre in the gated beautiful subdivision of Lago Santa Fe! From the moment you pull through the gate you will be surrounded by stunning homes and water used for the community\'s favorite activity, waterskiing. This 4 bedroom, 2.5 bath house has an open and bright floorplan ready to entertain your guests or serve as your personal oasis. The very large 3 car garage is impressive and has about 600 ft. of additional storage above the parking spaces. This home has been well maintained with immaculate landscaping, sprinkler systems, outdoor lighting, and very inviting interior. Home is not within any flood zone, and has not experienced flooding even during the most extreme storms since it has been built. This subdivision is small, unique, but loaded with character and charm. Please see link for 360 virtual tour and video walkthrough. 2d and 3d floor plan are available in the link.' ,`Acres` = '1' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 1 M AUSTIN SUR LOT 13 BLK 1 LAGO SANTA FE SUB SEC 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '43561' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lago Santa Fe Sub Sec 2 99' ,`TaxAmount` = '8238' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1666359826' WHERE `Matrix_Unique_ID` = '213157589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:46:04.437' ,`MLSNumber` = '7048465' ,`ListAgentFullName` = 'Stacy McNeill' ,`ListOfficeName` = 'Southern Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.071180' ,`Longitude` = '-95.544236' ,`PhotoCount` = '34' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '449500.00' ,`Status` = 'Active' ,`StreetName` = 'Bradford Grove' ,`StreetNumber` = '21115' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING One Story Home. Very OPEN FLOOR PLAN with High Ceilings, welcome you as you enter the Home. AMAZING KITCHEN features HUGE ISLAND, 42\" Cabinets with tons of Storage, Stainless Appliances. Off the Kitchen is an Extremely LARGE UTILITY ROOM with Plenty of cabinets and Large Amount of counter space. DOUBLE DOORS lead out to a COVERED PATIO AREA off of the Kitchen. This is Great for Entertaining Family and Friends. Generous size Rooms throughout the house. This Home has many ENERGY EFFICIENT features. Also, Bali Blinds, Hardwood Flooring, Granite Counters, Alarm System, 3 Car Garage, Private Primary Suite, with a VERY LARGE BATHROOM SUITE, with a generous his and hers closet, are some of the wonderful features what makes this home so desirable. Walking Trails, Clubhouse, Pool, Dog Park, Putting Green are located in the neighborhood. Close to The Woodlands, Grand Parkway-99, Restaurants and shopping. Zoned to the Exceptional KLEIN ISD. This home is a MUST SEE! Make your appt today.' ,`Acres` = '0.1818' ,`Area` = '14' ,`BuilderName` = 'Shea' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 LAUREL PARK NORTH SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MUELLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'French' ,`Subdivision` = 'Laurel Park North Sec 2' ,`TaxAmount` = '10837' ,`TaxRate` = '3.2565' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359826' WHERE `Matrix_Unique_ID` = '213168338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:46:40.873' ,`MLSNumber` = '77287358' ,`ListAgentFullName` = 'Carlotta Matejka-Kaldor' ,`ListOfficeName` = 'The Kaldor Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.562058' ,`Longitude` = '-95.333650' ,`PhotoCount` = '41' ,`PostalCode` = '77581' ,`RoomCount` = '12' ,`ListPrice` = '374500.00' ,`Status` = 'Active' ,`StreetName` = 'Quiet Arbor' ,`StreetNumber` = '2519' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2389' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Honey STOP the car! THIS IS THE ONE. Low tax rate. We can be home for the holidays in this perfect floor plan by Plantation Homes. Split floor plan with media room. 4/2/2 all brick. Well maintained. Interior painted 10/22. Walk into the extended tile entry with 2 decorative niches, 3 secondary bedrooms, bath & utility to the left. On the right there is a formal dining area with wood flooring that extends to the open concept family room with fireplace & perfect TV wall. Kitchen has granite and stainless steel appliances, breakfast island & breakfast area. Off the family room to the right is the media room, perfect for office, play area, but built as a media room by builder. To the back right of the family room is the primary bedroom with a window seat, large primary bath with long vanity, dual sinks and seperate tub & shower. Front & back doors are glass storm doors. Backyard has a covered patio with additional concrete for relaxing or hosting parties. Exclusions in Agent remarks.' ,`Acres` = '0.1584' ,`Area` = '5' ,`BuilderName` = 'Plantation' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON TERRACE SEC 3 (A0505 H T & B) BLK 3 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'LAWHON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon Terrace Sec 3' ,`TaxAmount` = '8245' ,`TaxRate` = '2.6537' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359826' WHERE `Matrix_Unique_ID` = '213202200' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:52:00.597' ,`MLSNumber` = '54356498' ,`ListAgentFullName` = 'Vania Yagelski' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998310' ,`Longitude` = '-95.734758' ,`PhotoCount` = '37' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Maple Village' ,`StreetNumber` = '20202' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2966' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this large single story 3/4BR, 2BA home! Front living and dining area is open and spacious with beautiful wood flooring! Kitchen area has granite counter tops, tile backsplash, and a large sky light that brightens the whole house! Primary bedroom has been extended to 28’x14’ and the primary bathroom has been extended with walk-in closets with built in shelving, two person shower with marble and tile, large 2 person jacquzzi tub, double sinks, and crown molding throughout. Back family room is spacious with carpet and a fireplace. The backyard includes covered patio and open patio areas with tiled deck. Garage has converted to an extra room with heating and AC that can be used as a recreational area or home gym. Schedule your showing today to see this beautiful home!!' ,`Acres` = '0.2166' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 FAIRFIELD INWOOD PARK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9436' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '970' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairfield Inwood Park Sec 03' ,`TaxAmount` = '7698' ,`TaxRate` = '2.676' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359827' WHERE `Matrix_Unique_ID` = '213224936' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:58:12.967' ,`MLSNumber` = '31588026' ,`ListAgentFullName` = 'Deborah Gonzalez' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812005' ,`Longitude` = '-95.537037' ,`PhotoCount` = '50' ,`PostalCode` = '77080' ,`RoomCount` = '6' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Moorberry' ,`StreetNumber` = '9734' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property is located in the highly desired Spring Branch nestled on a large corner lot. Beautifully updated 4 bedroom, big windows to let the sun light shine into the formal living and dinning area. Cook your delicious family meals in the incredible chef\'s kitchen with island overlooking a large gorgeous den with vaulted ceilings and wood beams. Updated bathrooms, huge backyard, covered patio, double pane windows, quartz counters, and new appliances. double panel energy efficient windows all through the house , new carpets in the bedrooms , industrial wood floor in main areas, soft close cabinets. This property needs just a little TLC to add your personal touch, priced to sale Easy access to I10, downtown, City Centre, and Beltway 8 makes this the perfect location at an affordable price! Refrigerator, washer and dryer convey with the house.\r\nDon\'t wait too long to schedule your private showing today.' ,`Acres` = '0.2918' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 7A SPRING SHADOWS SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '12712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING SHADOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Spring Shadows Sec 05' ,`TaxAmount` = '11337' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359827' WHERE `Matrix_Unique_ID` = '213254166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:28:51.887' ,`MLSNumber` = '85434072' ,`ListAgentFullName` = 'Bertha Saenz' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Mindy Clemmons' ,`SellingOfficeName` = 'RE/MAX American Dream' ,`Latitude` = '29.568976' ,`Longitude` = '-95.292922' ,`PhotoCount` = '30' ,`PostalCode` = '77581' ,`RoomCount` = '3' ,`ListPrice` = '199000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Austin' ,`StreetNumber` = '2102' ,`StreetSuffix` = 'Avenue' ,`City` = 'Pearland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss out on this great investor opportunity! 2 properties for one! Keep the current tenants that have resided there long term or rehab and flip! The main home is 3 bedrooms, 2 baths, and other home is 1 bedroom and 1 bath.' ,`Acres` = '0.344' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0232 H T & B R R TRACT 1 ACRES .344 (PEARLAND)' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '14985' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'BARBARA COCKRELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH WEST' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '2548' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359827' WHERE `Matrix_Unique_ID` = '213264501' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:25:26.310' ,`MLSNumber` = '28051695' ,`ListAgentFullName` = 'Carolyn Payton' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.177975' ,`Longitude` = '-95.185391' ,`PhotoCount` = '35' ,`PostalCode` = '77357' ,`RoomCount` = '3' ,`ListPrice` = '239500.00' ,`Status` = 'Active' ,`StreetName` = 'Linnwood' ,`StreetNumber` = '164' ,`StreetSuffix` = 'Drive' ,`City` = 'Woodbranch' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1.377 acres lot located in Woodbranch! This house has been raised and completely renovated. Don\'t miss the spectacular remodel that has been done. From the beautiful tile flooring to the spa like bathrooms. Open concept (living/dining/kitchen) to enjoy family and friend gatherings featuring vaulted ceilings. Kitchen has granite countertops, all new cabinets and appliances. Main bathroom has dual vanities, stand up tiled shower with great detail and a separate soaking tub. Primary bathroom features dual vanities, and a beautiful, spacious stand up tiled shower. Large side porch/balcony overlooking the oversized lot. Call today for a private tour!' ,`Acres` = '1.377' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WOODBRANCH 03, LOT 164' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '59982' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodbranch 03' ,`TaxAmount` = '324' ,`TaxRate` = '2.4398' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359827' WHERE `Matrix_Unique_ID` = '213321393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:13:21.367' ,`MLSNumber` = '25659671' ,`ListAgentFullName` = 'Jeffrey Welch' ,`ListOfficeName` = 'Welch Realty Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.757397' ,`Longitude` = '-95.589681' ,`PhotoCount` = '50' ,`PostalCode` = '77077' ,`RoomCount` = '10' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Wilston' ,`StreetNumber` = '1215' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3145' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately & traditional, this stunning brick home at 1215 Wilston offers a rare & desirable combo: a prime location near Terry Hershey Park & Buffalo Bayou bike trails & even Nottingham Park, 10 mins from City Center, a corner lot, a primary bedroom on each floor, fantastic lighted outdoor space, a 2-car garage w/extra storage, all packaged together in a truly desirable energy corridor location. This thoughtful f/plan includes a large den, living room w/built ins & gaslog fireplace, breakfast area w/built-in window seats, laundry room w/washer & dryer, kitchen includes double ovens & cooktop, built-in desk. The Grand owner\'s suite (1st floor) includes a walk-in closet & an updated bathroom & large walk-in shower. The second floor includes a primary bedroom which is big enough for a gameroom, 1 of the 3 secondary bedroom is connected to a bathroom. Its ample lot allows a grassy, fenced yard, perfect for pets & play. The neighborhood offers a clubhouse, pool, & tennis courts!' ,`Acres` = '0.1806' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 WOODS OF LAKESIDE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7866' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woods Lakeside' ,`TaxAmount` = '8087' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359827' WHERE `Matrix_Unique_ID` = '213329547' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:50:49.290' ,`MLSNumber` = '4125301' ,`ListAgentFullName` = 'Will Borel' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657086' ,`Longitude` = '-95.460897' ,`PhotoCount` = '31' ,`PostalCode` = '77035' ,`RoomCount` = '12' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Benning' ,`StreetNumber` = '4814' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Timeless brick ranch-style home sitting just outside the popular Bellaire area! Upon entry, your eyes are immediately drawn to sun-drenched interiors and beautiful mahogany wood floors. This 4BD, 2BR home offers many charming living spaces, including a spacious living room that flows seamlessly into the dining room, family room, and kitchen. Designed for convenience, the open-concept kitchen is stocked with modern appliances and generous top and bottom shelving for all your cooking and storage needs. Sliding glass doors open from the family room to the large back patio area made for entertaining. Located just off 610 loop and minutes from the medical district and Galleria, quickly pop into the city to grab a bite to eat at one of the many trendy restaurants nearby, or stay home and enjoy peace and tranquility in this quiet, quaint neighborhood. Home has never flooded.' ,`Acres` = '0.1738' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 20 POST OAK MANOR SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7571' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Post Oak Manor Sec 06' ,`TaxAmount` = '6635' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359828' WHERE `Matrix_Unique_ID` = '213332824' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:31:05.230' ,`MLSNumber` = '69166118' ,`ListAgentFullName` = 'Liz McNeel' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.010509' ,`Longitude` = '-95.525800' ,`PhotoCount` = '49' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Heathrow' ,`StreetNumber` = '7710' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully renovated, two story Kleinwood home radiates CHARM! Around the corner from enchanting Meyer Park, this attractive home is lovingly maintained. You are welcomed with gorgeous wood-look tile throughout cozy first floor. 4 beds upstairs with recent carpet. The kitchen features granite countertops, stainless steel appliances, deep sink, tile backsplash and a coffee/wine bar. Backyard oasis with new split-level deck creates the perfect space for family outdoor time and gathering of friends. Community pool and tennis court.' ,`Acres` = '0.1977' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 12 017*K4554500-001-012-024 KLEINWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kleinwood Sec 01' ,`TaxAmount` = '5329' ,`TaxRate` = '2.4866' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359828' WHERE `Matrix_Unique_ID` = '213369543' --> 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','213413809','1666359828','213413809','2022-10-21T07:24:49.573','96444186','Daniel Merlo','Keller Williams Woodlands','','','30.139906','-95.559630','46','77375','6','525000.00','Active','Pioneer Canyon','3','Place','Tomball','3','0','4','2842','Single-Family','Gorgeous home! Stunning bright design and gorgeous floor plan, this home features: 2 bedrooms down, 2 bedrooms and game room up, formal living room, kitchen has granite counter tops, stainless steel appliances and lots of cabinet space, this is an open floor plan great to entertain! Principal bedroom with nice bathroom separate shower and tub, other bedroom downstairs also has a full bathroom, large game room, large backyard with covered patio great for family and friends gatherings! No back neighbors! Gorgeous tile floor! This home will go fast! Make your appointment today!','0.1421','14','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','The Woodlands','Central Gas','0','LT 1 BLK 1 THE WOODLANDS CREEKSIDE PARK WEST SEC 22','Corner','6188','Appraisal District','','','0','','2','Convection Oven','0','','','Gas Range','','Composition','53 - Tomball','CREEKVIEW ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','CREEKSIDE PARK JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Woodlands Creekside Park West Se','','','Public Water,Water District','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:22:01.190' ,`MLSNumber` = '51566035' ,`ListAgentFullName` = 'Michael Knowles' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729070' ,`Longitude` = '-95.744409' ,`PhotoCount` = '38' ,`PostalCode` = '77450' ,`RoomCount` = '13' ,`ListPrice` = '838738.00' ,`Status` = 'Active' ,`StreetName` = 'Ganton' ,`StreetNumber` = '21315' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5107' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2884' ,`Area` = '36' ,`BuilderName` = 'K. Hovnanian' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KELLIWOOD GREENS SEC 1, BLOCK 1, LOT 7' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '12563' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CREECH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'BECK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kelliwood Greens' ,`TaxAmount` = '12045' ,`TaxRate` = '2.495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359828' WHERE `Matrix_Unique_ID` = '213472713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:03:59.950' ,`MLSNumber` = '44035512' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.540678' ,`Longitude` = '-95.051936' ,`PhotoCount` = '35' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Bay' ,`StreetNumber` = '2005' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful updated two-story cul-de-sac home with a pool in highly sought after Marina Bay Park. This home boasts 4 bedrooms and 3 and 1 half bathrooms. Large, inviting entry way with huge second level ceiling. Soft neutral colors throughout the home to give that cozy, at home feeling. Large breakfast area and formal dining for entertaining. Split floorplan upstairs with a large game room. Wood floors, large master suite, with a jacuzzi tub and large walk-in closet. Pool installed in 2020. This home is a must see!' ,`Acres` = '0.1865' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 27 BLK 1 MARINA BAY PARK SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marina Bay Park Sec 3 96' ,`TaxAmount` = '7368' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359828' WHERE `Matrix_Unique_ID` = '213510900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:45:11.790' ,`MLSNumber` = '50366068' ,`ListAgentFullName` = 'Michelle Hoover' ,`ListOfficeName` = 'Hoover Lake Conroe Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.393179' ,`Longitude` = '-95.722763' ,`PhotoCount` = '30' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Brocks' ,`StreetNumber` = '258' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1679' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gently lived in 2 yr old home. Four bedrooms, two bath. single story. Open concept living room/dining/kitchen. Counter height island with room for bar stools. Washer, Dryer and refrigerator included. Water softener, gutters and expanded back patio. Large fenced backyard. Neighborhood playground. Near schools in highly acclaimed Montgomery school district.' ,`Acres` = '0.1716' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S582403 - THE HILLS OF TOWN CREEK 03, BLOCK 3, LOT 5' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7473' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Hills Of Town Creek 03' ,`TaxAmount` = '5331' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359828' WHERE `Matrix_Unique_ID` = '213511071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:56:12.797' ,`MLSNumber` = '26901505' ,`ListAgentFullName` = 'Michael Flores' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797614' ,`Longitude` = '-95.788574' ,`PhotoCount` = '49' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Travis House' ,`StreetNumber` = '24319' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Boasting an array of sleek finishes and a thoughtful open-plan layout, this immaculate 4 Bedrooms, 2 Baths single-family home in a Cul-de-sac is located in the charming community of Williamsburg. This home features an updated dream kitchen that showcases white beveled edge subway tile, granite, white cabinets, and a gas cooktop. Hardwood flooring in the formal living, dining, den, and hallways leads to the master en suite and three secondary bedrooms. The Oversized Master’s bedroom with a walk-in closet has a spacious en suite with a separate tub and shower making this en suite just perfect. Enjoy the fully fenced backyard perfect for kids & pets. This home is near shopping malls and restaurants, with easy access to 99/I10. BONUS: Security system and cameras stay, 2.8% tax rate, KATY JH, and no flood! You’ll find tasteful updates throughout this stunning home. Schedule a tour today!' ,`Acres` = '0.1446' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 17 WILLIAMSBURG HAMLET SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williamsburg Hamlet Sec 04' ,`TaxAmount` = '5628' ,`TaxRate` = '2.5733' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359829' WHERE `Matrix_Unique_ID` = '213538427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:49:42.320' ,`MLSNumber` = '65259144' ,`ListAgentFullName` = 'Donna Norris' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.475453' ,`Longitude` = '-95.118250' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Bullhead' ,`StreetNumber` = '2317' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home features 4 bedrooms, 3 full bathrooms plus large home office/media room. Formal dining, den and island kitchen/breakfast combo all overlook custom tiled fireplace surround and view to back garden, sharing 10\' ceilings and upgraded molding. Counter height bar in kitchen and island are granite, with gorgeous travertine tile back splash and lighting beneath the 42\" cabinets. Huge primary bedroom has cathedral ceiling and lovely accent wall as well as walk-through access to the laundry room via the closet. Many rooms have motion activated lighting; all light fixtures/fans are upgraded. Interior newly repainted, and exterior freshly landscaped. Oversized 2-car garage has been drywalled; upstairs is additional finished 392 sq ft, with its own private entrance, HVAC unit (plumbing stub out for future bathroom is in place) and is currently used as a craft room. Spray foam insulation with sealed attic system ensures low utility bills. Super low 2.06% tax rate - no MUD!' ,`Acres` = '0.2311' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEDONA SEC 3 (2014) ABST 3, BLOCK 8, LOT 4, ACRES 0.23' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '10066' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAUERSCHLAG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'VICTORYLAKES INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sedona' ,`TaxAmount` = '9163' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359829' WHERE `Matrix_Unique_ID` = '213600892' --> 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','213603372','1666359829','213603372','2022-10-21T06:54:13.347','37318016','Karen Seale','Etheredge Real Estate','','','29.533638','-95.022229','33','77565','9','334900.00','Active','Oak Briar','510','Drive','Kemah','3','1','4','2684','Single-Family','**FANTASTIC 4 Bedroom Home with Home Office in KEMAH OAKS** Home features 4 bedrooms- 3 full bathrooms- 1 half bathroom- 2 car garage! Kitchen with breakfast bar is open to the breakfast room. Formal Dining Room! Home Office/Study! Fireplace. Primary en-suite located on 1st floor with walk-in closet! ADDITIONAL PRIMARY Bedroom located on the 2nd floor!! From 2016-2022 owner\'s have replaced water heater, dishwasher, backyard fencing, air conditioner, carpeting and interior paint. Kemah Oaks provides pool, playground, basketball, soccer, pavilion, walking trails and restrooms!','0.1423','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','League City','Central Gas','1','ABST 18 M MULDOON SUR LOT 16 (16-2) BLK 10 KEMAH OAKS SUB','Cleared,Cul-De-Sac,Subdivision Lot','6200','Appraisal District','','484','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','9 - Clear Creek','STEWART ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR FALLS HIGH SCHOOL','BAYSIDE INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','2','Traditional','Kemah Oaks Sub 92','5039','2.0134','Public Sewer,Public Water','1995','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:08:33.673' ,`MLSNumber` = '868548' ,`ListAgentFullName` = 'Anna Gonzalez' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595446' ,`Longitude` = '-95.600978' ,`PhotoCount` = '35' ,`PostalCode` = '77478' ,`RoomCount` = '9' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Waters Way' ,`StreetNumber` = '3123' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2739' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful two-story home is nestled in the quiet community of Edgewater, it\'s a smaller community consisting of only 120 homes and is walking distance to Water\'s Way Park. There are 4 bedrooms and 3 baths upstairs, and a 1/2 bath downstairs for guests. The kitchen offers an open concept to the living and breakfast area which is always great for entertaining and the entry way offers a sitting area that could also be used as an office space. Outback there is a large wrap around yard and a patio area for sitting and enjoying your morning coffee. There is easy access to Hwy 59, Hwy 6, and a short distance to tollway. Some updates include new interior paint, baseboards, and carpet. Zoned to Highlands Elementary, Dulles MS, and Dulles HS come tour this home and make it yours. *This property sits high and has never flooded*' ,`Acres` = '0.1454' ,`Area` = '29' ,`BuilderName` = 'Brighton Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'EDGEWATER SEC 2, BLOCK 2, LOT 9, R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6335' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewater Sec 2' ,`TaxAmount` = '6241' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359829' WHERE `Matrix_Unique_ID` = '213611427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:54:32.960' ,`MLSNumber` = '15469659' ,`ListAgentFullName` = 'Jennifer Ciulla' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511923' ,`Longitude` = '-95.538100' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '14' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Big Trail' ,`StreetNumber` = '107' ,`StreetSuffix` = 'Circle' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '5381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Positioned in the elite acreage estate section of The Forest This stunning home designed by J. KYLE Custom Homes is encompassed with mature trees & lush landscaping. The professionally equipped open gathering kitchen features Thermadore built-in appliances, custom Benedettini cabinets, designer granite and wine room. The expansive living room is a showstopper with soaring ceilings and serene views of the tree filled back yard. The primary retreat features a vestibule entrance, seating area and spa like master bath with 2 spacious closets. The casita with en-suite bath is perfect for guests or private home office. Upstairs is a dream space featuring 4 large bedrooms all with en-suite baths, study nook, media room & gameroom with wet bar. Step outdoors to your secluded \"grand\" sized back terrace retreat equipped with wood burning fireplace, summer kitchen and cabana bath. Minutes away from Hwy 6 and the Fort Bend toll road offers an easy commute to Downtown The Galleria or Med Center.' ,`Acres` = '0.8028' ,`Area` = '38' ,`BuilderName` = 'J. Kyle Estate' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF BEES CREEK SEC 1, BLOCK 3, LOT 2' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '34972' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Bees Creek' ,`TaxAmount` = '20263' ,`TaxRate` = '2.8129' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359829' WHERE `Matrix_Unique_ID` = '213623651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:42:38.880' ,`MLSNumber` = '5760045' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = 'Hillory Shearer' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.829410' ,`Longitude` = '-95.444963' ,`PhotoCount` = '34' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '749900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cheshire' ,`StreetNumber` = '1802' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'On a great block in booming Oak Forest, 1802 Cheshire offers a well-executed floor-plan designed with elegance and efficacy. Guests are greeted by hardwood floors that extend throughout the home. The chef\'s kitchen offers ample storage space and an oversized island with easy flow to the living and dining areas, but it is the light color scheme and a mixture of its white subway tile, and white cabinetry with a sleek stainless steel appliance package that steal the show. The spacious living room features elegant tray ceilings and a stone-framed fireplace that creates a cozy and inviting space for entertaining. The primary bathroom boasts dual sinks, abundant cabinet space, long countertops, and plenty of space for toiletry organization. An additional secondary bedroom offers an ensuite bathroom with a shower/tub combination. A large veranda overlooking the spacious backyard and a rare 2-car garage round out this home.' ,`Acres` = '0.1791' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 73 OAK FOREST SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '13931' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359829' WHERE `Matrix_Unique_ID` = '213628725' --> 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','213656724','1666359830','213656724','2022-10-21T07:40:17.403','91431428','Nicky Gomez','RE/MAX The Woodlands & Spring','','','30.542542','-97.877624','24','78641','7','695000.00','Active','Gift Horse','2304','Pass','Leander','2','1','3','2622','Single-Family','Welcome home to Caprock at Crystal Falls, one of Leander\'s most sought after, private, gated communities. Through the hills of Crystal Falls, you will be welcomed home to this immaculate one story home right outside of Crystal Falls Golf Club. This home features 3 Bedrooms, 2.5 bathrooms, a spacious living room with cozy fireplace, study, sunroom and formal dining room. Highlights include walk-in closets in all bedrooms, mud room, rounded archways, crown molding, laundry room built-ins, plantation shutters and windows that bring in an abundance of natural light. The kitchen features an open island layout with granite countertops, spacious walk-in pantry, herringbone backsplash, double ovens and stainless steel appliances. Enjoy evenings and weekends on the covered back patio. The wonderful backyard is great for entertaining all of your family and friends with NO BACK NEIGHBORS. The home is zoned to excellent Leander ISD Schools.','0.2978','83','','','Washer Connections','','Exclusions,Sellers Disclosure','1','Gaslog Fireplace','1','','Central Gas','1','LOT 44 BLK A FAIRWAYS AT CRYSTAL FALLS SEC 3 PHS 1 CAPROCK A','Subdivision Lot','12972','Appraisal District','','924','0','','2','Double Oven','0','','','Gas Cooktop','','Tile','123 - Leander','WHITESTONE ELEMENTARY SCHOOL','LEANDER HIGH SCHOOL','LEANDER MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Crystal Falls','11927','2.3907','Public Sewer,Public Water','2011','Appraisal'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213656836','1666359830','213656836','2022-10-21T07:46:44.093','58193302','Nicky Gomez','RE/MAX The Woodlands & Spring','','','30.168886','-95.443867','38','77385','9','510000.00','Active','Susan','402','Lane','Oak Ridge North','2','1','4','2558','Single-Family','Welcome Home to another Modern Defined remodel 4 Bedroom Two-Story Home by The Build Co. The sleek design will capture you from the moment you arrive. This home features Luxury finishes such as Gourmet Kitchen, Spacious living room with lime wash fireplace, Rustic Oak & Black Cabinets with Soft close drawers, Modern Spanish Tile Flooring throughout, and Floating Cabinets. Spend your evening and weekends resting in tranquility on the back deck right off the living room. Minutes away from The Woodlands, Entertainment, Dining, Shopping, this is one you won\'t want to miss.','0.2948','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Spring Northeast','Central Gas','0','OAK RIDGE NORTH 10, BLOCK 8, LOT 60','Corner,Subdivision Lot','12840','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','OAK RIDGE ELEMENTARY SCHOOL (CONROE)','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Oak Ridge North','5096','2.461','Public Sewer,Public Water','1984','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:02:36.390' ,`MLSNumber` = '29347426' ,`ListAgentFullName` = 'Isela Truong' ,`ListOfficeName` = 'Terramont Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.368054' ,`Longitude` = '-95.608529' ,`PhotoCount` = '44' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Springs Edge' ,`StreetNumber` = '266' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open House Saturday 1pm-4pm. Stately home sits on a corner, cul-de-sac lot with views of the golf course. Roof is only 6 years old and the home comes with a whole house Generac Generator! Recently updated with New Quartz countertops, backsplash, stove with wifi, pop up exhaust vent, stainless steel sink, fresh paint and carpet, all new faucets and LED lighting. Simply Charming home, light and bright, located on one of the nicest streets in April Sound. Pride of ownership shows in all the surrounding homes. Covered balcony off the primary bedroom with stairs to access the patio below. Kitchen boasts a double bar for additional seating on both ends. Owner is offering $500 towards a home warranty of your choice. Schedule your tour today!' ,`Acres` = '0.3036' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 01, BLOCK 5, LOT 51' ,`LotDesciption` = 'Corner,Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot,Wooded' ,`LotSize` = '13223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '234' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound 01' ,`TaxAmount` = '5587' ,`TaxRate` = '2.2525' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359830' WHERE `Matrix_Unique_ID` = '213668641' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:28:46.217' ,`MLSNumber` = '52029978' ,`ListAgentFullName` = 'Hugo Alfaro' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.022349' ,`Longitude` = '-95.309088' ,`PhotoCount` = '10' ,`PostalCode` = '77338' ,`RoomCount` = '3' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Rezanof' ,`StreetNumber` = '21239' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story 3/2/2 home, ready for a new family to enjoy! Neutral colors throughout, lovely updated kitchen. Owner has taken great care of this home. Open concept plan with Kitchen overlooking the Living Room. Come Relax on the backyard featuring a large 12X15 covered patio with fans. Great location, enjoy all the shopping and dining selections in Humble, and only 5 mins away from the airport. Home is price to sell fast, place an offer today!! Home never flooded, per owner.' ,`Acres` = '0.1125' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 KENSWICK MEADOWS AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4902' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kenswick Meadows Amd' ,`TaxAmount` = '4105' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359830' WHERE `Matrix_Unique_ID` = '213735404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:50:26.733' ,`MLSNumber` = '13841627' ,`ListAgentFullName` = 'Moira Holden' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.567949' ,`Longitude` = '-95.632120' ,`PhotoCount` = '48' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '785000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekstone' ,`StreetNumber` = '3202' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3777' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ABSOLUTELY FABULOUS!! Stunning 4/4.5 custom home with sparkling pool & spa nestled on a large golf course lot in prestigious Colony Oaks. This beautiful, open concept floorplan was built for entertaining with well proportioned living spaces flowing seamlessly together. Enter the 2 story foyer to gleaming hardwoods & breathtaking pool & golf course views. Elegant dining room can accommodate a large gathering with ease! The formal living room w/feature fireplace is a wonderful spot for conversation and relaxation. Chef\'s dream kitchen is the center of the home w/breakfast bar connecting to the family living space & casual dining nook. One secondary bedroom with ensuite on the first floor. Serene & spacious primary retreat with spa like bathroom and private balcony overlooking the golf course; two large secondary bedrooms (both w/private baths) and sitting/game room on the second level. Large covered patio, green play space and 2 car attached garage. Great schools! Hurry!!' ,`Acres` = '0.2683' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY OAKS SEC 1, BLOCK 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11688' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colony Oaks' ,`TaxAmount` = '12994' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359830' WHERE `Matrix_Unique_ID` = '213755027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:51:44.197' ,`MLSNumber` = '31741828' ,`ListAgentFullName` = 'Maribel Granados' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747303' ,`Longitude` = '-95.747033' ,`PhotoCount` = '19' ,`PostalCode` = '77450' ,`RoomCount` = '10' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Wittman' ,`StreetNumber` = '21615' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3089' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the beautifully kept 4 bedroom, 2 and 1/2 bath home that features a unique entrance to the office/study, with a spacious dining room. Kitchen boast new wood look vinyl plank flooring, new dishwasher, and new gas oven. Tall ceilings in living room with a cozy fireplace. Elegant wood floor staircase leads up to a spacious gameroom for plenty of fun activities for the family. Primary bedroom and bathroom display beautiful stained glass windows. NO CARPET! Big backyard with garden area ready for your touch. Great community amenities including community pool, splash pad for the little ones, and 2 tennis courts. And last but not certainly not least the home is zoned to highly sought after Katy ISD.' ,`Acres` = '0.1873' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 OAK PARK TRAILS SEC 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'EXLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Park Trails Sec 02' ,`TaxAmount` = '6680' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359830' WHERE `Matrix_Unique_ID` = '213766245' --> 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','213774834','1666359831','213774834','2022-10-21T07:25:11.023','39378351','Elisa Maceda','Keller Williams Realty - Memorial','','','29.648572','-95.339073','23','77033','3','209900.00','Active','Groveton','5606','Street','Houston','1','0','3','1165','Single-Family','MOVE-IN READY, SINGLE STORY HOME COMPLETELY RENOVATED!\r\nImmaculate 3 bedrooms 1 bath home with a huge fully fenced backyard. Beautiful original wood floors in living area and rooms helps keep the character of the home. Beyond the entryway the home opens to a luminous, open-concept living, dining and kitchen area. A redesigned kitchen with elegant white quartz countertops, all new appliances and plenty of storage. New exterior siding with updated insulation. A remodeled bathroom including quality hardware, modern title, and two niches for all toiletries. All windows (Energy Star), doors, ceiling fans, and led lighting are brand new! Interior and exterior painting was recently completed. The large front porch is great for morning coffee and would be perfect for a porch swing. Updated electrical, central air and heat, and foundation. Convenient covered back patio perfect for entertaining.\r\nCall your agent to schedule a showing of this beautiful home before it\'s gone!','0.157','3','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure,Special Addendum','1','','0','Medical Center South','Central Gas','0','LT 11 BLK 7 CRESTMONT SEC 2','Subdivision Lot','6840','Appraisal District','','','0','','1','Gas Oven','0','','','Freestanding Range','','Composition','27 - Houston','MADING ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','1','Ranch','Crestmont Add Sec 02','2064','2.3307','Public Sewer,Public Water','1959','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','213775865','1666359831','213775865','2022-10-21T06:13:34.190','76885406','Jan Pappert','Compass RE Texas, LLC','','','29.690149','-95.471442','1','77401','13','1595000.00','Active','Mimosa','5135','Drive','Bellaire','5','1','5','4733','Single-Family','Exceptional Contemporary New Construction Brick/Stone Home in Bellaire. Step inside to a handsome study with custom wood detailed walls. The refined dining room is located perfectly with natural light. Highly functional & open kitchen/living space appointed with stylish designer finishes & linear fireplace. Quartzite counters, high-end appliances & custom cabinetry. The amazing sliding wall of doors to the grand outdoor veranda/kitchen just sets the mood!! 1st floor hosts a rare/bonus bedroom/2nd primary & full bath. Upstairs are 3 spacious secondary bedrooms all en-suite & prewired media/game room. An oversized laundry with tons of closets & cabinets. A wonderful flex room ideal for a 2nd study, workout/craft room. Luxury awaits in the owner’s suite with a dramatic freestanding tub & dual/2 large custom walk-in closets. This special home is elevator ready (specs by Marshall Stevenson). Near Bellaire Parks, Pools, Recreation Center & convenient to the Medical Center & Downtown.','0.1716','17','Medini Luxury','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','1','Bellaire Area','Central Gas','0','LT 2 BLK 2 BRAEBURN GARDENS SEC 2','Subdivision Lot','7475','Appraisal District','','','1','To Be Built/Under Construction','2','Convection Oven,Double Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','27 - Houston','LOVETT ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Accompany,Appointment Required','Builder','2','Contemporary/Modern','Braeburn Gardens Sec 02','10468','2.2271','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:07:42.510' ,`MLSNumber` = '40190150' ,`ListAgentFullName` = 'Robin Meachum' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.943205' ,`Longitude` = '-95.496017' ,`PhotoCount` = '32' ,`PostalCode` = '77066' ,`RoomCount` = '6' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Incline' ,`StreetNumber` = '5104' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this 3 bedroom, 2 full, 1 half bath home in the Bammel Trace townhome community. Beautifully upgraded home, 2 car attached garage w/extended driveway. Enter the home to smooth wood-like flooring, window w/window seat ideal for decorative pieces. Half bath w/pedestal sink, perfect for guests as they enter and/or leave your home . Open concept downstairs living area allows you to prepare meals in the kitchen and entertain at the same time. Pendant lighting in breakfast area & over elevated bar around kitchen. The kitchen in this home features stainless steel appliances and recessed lighting. Wood cabinetry and upgraded black countertops. Flex office with track lighting. Primary bedroom features elegant white ceiling fan, crown molding, primary bath with his and hers sinks, garden tub and walk in shower. Multiple upgrades include solar screens, stone & accent walls, crown molding, all bathroom lighting, faucets and sinks. Roof covered by HOA.' ,`Acres` = '0.0707' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 61 BLK 2 BAMMEL TRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '153' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'KUJAWA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bammel Trace' ,`TaxAmount` = '3558' ,`TaxRate` = '2.2753' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359831' WHERE `Matrix_Unique_ID` = '213786285' --> 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','213793614','1666359831','213793614','2022-10-21T06:29:41.613','15486893','Thuong Gist','Brookhaven Realty','','','30.386397','-96.038111','37','77868','9','1100000.00','Active','County Road 446','15598','','Navasota','4','1','5','3882','Single-Family','Gorgeous Modern Farmhouse on UNRESTRICTED 20 acres located 20 minutes from Texas A&M and less than an hour from Houston (Woodlands/Tomball/Cypress). Built in 2016, this Designer home has almost 3900sf of living space with two 10-12 feet wide covered porches that are great for entertaining, INCREDIBLE views and keeping the home cool in the summers. There are 5 spacious bedrooms with 4.5 baths in an open floor plan. Kitchen equipped with granite counter tops, double oven with gas cooktop, farmhouse sink and pot filler. Very well built with Shiplap walls, High ceilings and wood floors. 32x64 Barn/Wood Shop with electricity in the back along with a small storage shed. Plenty of acreage to build a fishing pond or your very own pool oasis. High Speed Fiber Optic (1gig). AG Exemption','20','60','Trendmaker','','Electric Dryer Connections,Washer Connections','','Owner/Agent','1','','1','','Central Electric','0','A0044 JESSE B MC NEALY, TRACT 13-6, ACRES 20','Wooded','','Appraisal District','','','0','','0','Double Oven','0','','','Gas Cooktop','','Aluminum','129 - Navasota','HIGH POINT ELEMENTARY SCHOOL (Navasota)','NAVASOTA HIGH SCHOOL','NAVASOTA JUNIOR HIGH','Accompany,Appointment Required','Appraisal District','2','Contemporary/Modern,Ranch','other','8137','1.7749','Aerobic,Public Water,Septic Tank','2016','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:19:20.960' ,`MLSNumber` = '98409135' ,`ListAgentFullName` = 'Kate Johnson' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.828021' ,`Longitude` = '-95.138929' ,`PhotoCount` = '39' ,`PostalCode` = '77360' ,`RoomCount` = '6' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Cattle' ,`StreetNumber` = '485' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '1' ,`SqFtTotal` = '2516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Custom Lake Home on just over an acre with amazing water views of Lake Livingston! This unique 1 bedroom, 2 ½ bath has an elegant entryway leading into a study and large den, built in entertainment center, and a cozy fireplace. The large, enclosed sunroom is lined with windows bringing natural light to the entire room. The spacious primary bedroom has a large reading nook and the ensuite only needs your personal touches and updates with a soaking tub, separate shower, double vanity, walk in closet, and lots of built-in cabinetry for linens/storage. The attached 2 car garage is air conditioned with a workshop/storage room, and the additional three bay garage has a separate gated entrance, workshop, elaborate man cave, half bath, storage bay, and air conditioning. There are 2 large back up generators, security system, tankless water heater, aerobic septic system, and so much more! Call to schedule your private tour today!' ,`Acres` = '1.0758' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TEXAS ACRES SECTION 2 BLK 11 LOT 14, 15, 16, 50, 51 & 52' ,`LotDesciption` = 'Water View' ,`LotSize` = '46860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Texas Acres Sec 2' ,`TaxAmount` = '7042' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359831' WHERE `Matrix_Unique_ID` = '213795886' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:28:40.057' ,`MLSNumber` = '38118589' ,`ListAgentFullName` = 'Sally Matthews' ,`ListOfficeName` = 'Navasota Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.484977' ,`Longitude` = '-95.985451' ,`PhotoCount` = '32' ,`PostalCode` = '77830' ,`RoomCount` = '8' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'South Main Street' ,`StreetNumber` = '380' ,`StreetSuffix` = '' ,`City` = 'Anderson' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1441' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Own a piece of History with this charming and renovated 1800s farmhouse, in the nostalgic town of Anderson, Texas. The home is located in the highly sought-after Anderson ISD. This is your white picket fence, slow the pace down opportunity. This bright, airy and open 3 bedroom, 1 and a half bath has new air conditioning, gas stove, and refrigerator. There is premium laminate wood flooring throughout the home. This property could also be used as a commercial office within walking distance of the courthouse in downtown Anderson. It is .14 miles from the historical Fanthrop Inn.' ,`Acres` = '' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'W ANDERSON, BLOCK 4, LOT 16' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '135 - Anderson-Shiro' ,`SchoolElementary` = 'ANDERSON-SHIRO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDERSON-SHIRO JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ANDERSON-SHIRO JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '9999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359831' WHERE `Matrix_Unique_ID` = '213807328' --> 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','213833048','1666359831','213833048','2022-10-21T06:14:47.417','29971121','Patti Lacy','Coldwell Banker Realty','','','29.839970','-95.713610','30','77449','7','240000.00','Active','Hawk Meadow','4643','Drive','Katy','2','1','4','1361','Single-Family','Fantastic 4 bedroom, 2 1/2 bath home! Quiet neighborhood. Laminate flooring downstairs in den & breakfast room. Gas Cook top. Cute breakfast room & den overlooking backyard. Half bath down. Breakfast bar. Refrigerator stays. NO back neighbors. Carpet upstairs in all 4 bedrooms. 2 car garage. Neighborhood park & pool within walking distance.','0.1351','25','','','','','Mud,Sellers Disclosure','1','','','Bear Creek South','Central Gas','1','LT 14 BLK 1 CYPRESS MEADOW SEC 4','Subdivision Lot','5887','Appraisal District','','350','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','M ROBINSON ELEMENTARY SCHOOL','CYPRESS PARK HIGH SCHOOL','THORNTON MIDDLE SCHOOL (CY-FAIR)','Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Cypress Meadow Sec 04','4688','2.796','Water District','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T06:37:29.280' ,`MLSNumber` = '85409894' ,`ListAgentFullName` = 'Stephen Warrell' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792380' ,`Longitude` = '-95.380436' ,`PhotoCount` = '25' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '549950.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage' ,`StreetNumber` = '725' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming craftsman home found in the heart of Norhill offers historic charm and character in abundance. Featuring high ceilings and lots of windows, this home is flooded with natural light on all sides which creates a spacious and inviting space. The living area is large and accommodating to a multitude of configuration options which are enhanced by the wood burning fireplace. Through the living room you open up into the dining room with a storage closet, built in buffet and access to the kitchen. The kitchen provides access to the utility area bedrooms and the bathroom as well as the back garden. The primary bedroom is spacious and has 2 closets, one of which is a walk in which is a rare find. In the back yard you are welcomed by a freshly painted deck and large green space that is fenced off from the driveway for convenience and safety for pets and children. An oversized 2 car garage with storage area is a great added value in this amazing home.' ,`Acres` = '0.1289' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 217 EAST NORHILL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`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` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'East Norhill' ,`TaxAmount` = '11333' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359831' WHERE `Matrix_Unique_ID` = '213836721' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:49:50.713' ,`MLSNumber` = '96958772' ,`ListAgentFullName` = 'Tina Reynolds' ,`ListOfficeName` = 'Allsource Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.279884' ,`Longitude` = '-94.820542' ,`PhotoCount` = '31' ,`PostalCode` = '77551' ,`RoomCount` = '0' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue R' ,`StreetNumber` = '5109' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Per Seller the 2 lots were combined in 2014. You can potentially separate back into 2 lots. Onus is on the buyer to confirm this information. \r\n\r\nInvestor Special! Unique, double-lot property offers 3 structures: One main home, an efficiency, and a storage building. Upgrade or tear down; a discerning eye can see all possibilities. The main structure is 2 stories, not in a flood zone, and none of the property/buildings have ever flooded. Sellers have done much of the interior demo for you! House could be remodeled into an Air BNB with a 2 bedroom apt downstairs, and 2 bedrooms up (1 bath per floor). Efficiency was built in 2019 and would be a great separate Air BNB income producer. Create your dream vacation home or rental, just a few short blocks from the beach. Lot is about 50\' wide and 120\' deep.' ,`Acres` = '0.1378' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 7 & 8 BLK 155 DENVER RESURVEY**' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`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` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'M B Menard' ,`TaxAmount` = '2798' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359831' WHERE `Matrix_Unique_ID` = '213870644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:27:22.810' ,`MLSNumber` = '97794127' ,`ListAgentFullName` = 'Tiffany Romero' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.412646' ,`Longitude` = '-95.567391' ,`PhotoCount` = '1' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 830' ,`StreetNumber` = '13790' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT opportunity to live within walking distance of Lake Conroe. This home is an amazing 3 bedroom with so much character. It is on 2 lots almost 3/4 of an acre total. If you love to cook and entertain than this is your home!! The gorgeous kitchen and family room are located upstairs with 3 balconies to have views from the second floor. Family room and Kitchen both have cedar beams which makes it such a rustic living area with Texas feel. Backyard has a separate fenced in area great for a pet. This property would also make a fun weekend lake house or a great investment property or airbnb. Owner has Access to boat launch, clubhouse and community park. There are two entrances to the property, off of FM830 leads to front of home and off of Woodland Manor Dr in Lakeview Manor you can enter from the back of property. Downstairs AC 2020, New water heater 2022' ,`Acres` = '0.2353' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEVIEW MANOR, BLOCK 1, LOT 8 and 16' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '30928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '212' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Lakeview Manor' ,`TaxAmount` = '6814' ,`TaxRate` = '2.1633' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359832' WHERE `Matrix_Unique_ID` = '213879452' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T07:30:54.623' ,`MLSNumber` = '33540282' ,`ListAgentFullName` = 'Lisa Grimes' ,`ListOfficeName` = 'Goolsby Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.069978' ,`Longitude` = '-95.594746' ,`PhotoCount` = '34' ,`PostalCode` = '77422' ,`RoomCount` = '7' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 696A' ,`StreetNumber` = '1817' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a home with big shade trees in the front yard and big open backyard? This brick beauty is a 3 bedroom, 1 bath, 2 car garage, and a shop. Sits on 2 acres cleared, shady, and on the corner. Possibilities are endless.' ,`Acres` = '2' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S/D TRS 42-42A (A0020 S F AUSTIN DIV 10), BLOCK 4, LOT 15-16' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'S/D Trs 42-42a' ,`TaxAmount` = '2967' ,`TaxRate` = '1.6567' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666359832' WHERE `Matrix_Unique_ID` = '213892915' --> 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','213908089','1666359832','213908089','2022-10-21T06:52:30.780','93657183','Lyssa Lechuga','New Home Star Texas, LLC','','','29.303244','-96.071489','17','77488','3','149999.00','Active','Golf Crest','2849','Drive','El Campo','1','0','3','1040','Single-Family','New construction ready for move-in immediately - This one story Plan with 3 bedrooms, 1 bath, one-story home is energy efficient, with an open concept kitchen overlooking the large living-dining combo, making this home perfect for entertaining. This home includes LED Lighting and vinyl plank flooring, and carpet in all bedrooms. Moen fixtures in a timeless chrome finish are placed throughout the home with white cabinetry. Beautiful black appliance package included, home is engineered and inspected by a third-party engineer, has a seer HVAC system, double pane insulated Low-E windows.\r\nFantastic Builder \'1-2-10\' Warranty','0.117','55','Censeo','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','','Central Electric','0','GOLF CREST EST. LOT 10','Cleared','7000','Appraisal District','','','1','Never Lived In','0','Electric Oven','0','','','','','Composition','180 - Wharton','CG SIVELLS/WHARTON ELEMENTARY SCHOOL','WHARTON HIGH SCHOOL','WHARTON JUNIOR HIGH','Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Builder','1','Traditional','Golf Crest Estate','','2.4815','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','213908121','1666359832','213908121','2022-10-21T07:00:33.470','98245593','Maria Cuevas','Kodu Realty, LLC','','','29.704895','-95.207711','32','77506','4','220000.00','Active','Randall','506','Street','Pasadena','2','0','4','1800','Single-Family','~OPEN HOUSE This Sunday OCTOBER 23 FROM 1-3PM~ \r\nStunning MOVE IN READY home just hit the market in Pasadena!! This beauty is completely remodeled with 4 bedrooms (oversized primary suite)! Updated kitchen with new installed countertops and stunning new floors throughout home. 2 Full bathrooms completely updated. Located in the heart of Pasadena! Easy access to 225, 610, and 45! Contact your favorite realtor for a private tour. Low Tax Rate.\r\nLocated in an established neighborhood and zoned to Pasadena school district.','0.155','6','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Pasadena','Central Gas','0','LT 2 BLK 2 PASADENA OUTLOT 104','Cleared','6750','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','41 - Pasadena','KRUSE ELEMENTARY SCHOOL','PASADENA HIGH SCHOOL','SOUTHMORE INTERMEDIATE SCHOOL','Supra Keybox','Seller','1','Traditional','Pasadena Outlot 104','2087','2.6514','Public Sewer,Public Water','1942','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','213908310','1666359832','213908310','2022-10-21T07:15:51.550','70369420','Lawrence Whiteing','Westside Realty','','','29.785595','-95.176290','22','77015','5','139500.00','Active','Frankie','614','Street','Houston','1','0','3','1092','Single-Family','Total renovation home with upgraded kitchen with granite countertops with new cabinets, upgraded bathroom, laminated flooring, with patio cover. huge fenced yard with a nice size storage building, new exterior HVAC, and new water heater','0.241','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','North Channel','Central Gas','0','LTS 2O & 22 BLK 183 CLOVER LEAF SEC 3','Cleared','10500','Appraisal District','','','0','','0','Freestanding Oven','0','','','Freestanding Range','','Composition','21 - Galena Park','NORTH SHORE ELEMENTARY SCHOOL','NORTH SHORE SENIOR HIGH SCHOOL','NORTH SHORE MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Ranch','Clover Leaf Sec 03','2374','2.5853','Public Sewer,Public Water','1946','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','213908439','1666359832','213908439','2022-10-21T07:44:37.610','69180809','Crystal Northcutt','Compass RE Texas, LLCKaty','','','29.749551','-95.390336','44','77006','8','767000.00','Active','Drew Street','812','Street','Houston','3','1','3','2879','Single-Family','Classic architectural design and desirable front facing end unit is one of 3 homes in this gated community of Montrose. Beautiful entry w/ 1st level bed/bath. Entertainers delight on the 2nd level w/ open concept kitchen/dining/living. Gourmet kitchen w/ 6 burner gas cooktop, oversized oven, large island w/ sink & wine fridge. Italian Carrara Marble throughout the kitchen. Jenn air appliances. Wood floors, gas log fireplace, balcony, half bath and surround sound complete this exquisite level. Owners retreat on 3rd level w/ oversized bedroom, surround sound, wine fridge & coffee bar area. Stunning bathroom w/ Carrara marble counters/floors, soaking tub &separate shower. Vast custom walk in closet. 4th level has bed/bath, game room w/wet bar, surround sound & expansive private covered rooftop terrace w/ downtown views. Plantation shutters, crown molding & high end finishes throughout. Walking distance to your favorite restaurants/hot spots on Fairview & Montrose Blvd.','0.0355','16','Arcada Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Montrose','Central Gas,Zoned','0','LT 3 BLK 1 ARCADA','Other','1546','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY','LAMAR HIGH SCHOOL (HOUSTON)','GREGORY-LINCOLN MIDDLE SCHOOL','Appointment Required,Controlled Access,Request Online Appointment,Supra Keybox','Appraisal District','4','Traditional','Arcada Sub','13903','2.3307','Public Sewer,Public Water','2012','Appraisal District'); --> New record created successfully