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-11-27T11:15:22.770' ,`MLSNumber` = '66087304' ,`ListAgentFullName` = 'David Edgerton' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.709552' ,`Longitude` = '-95.405178' ,`PhotoCount` = '18' ,`PostalCode` = '77030' ,`RoomCount` = '10' ,`ListPrice` = '1400000.00' ,`Status` = 'Active' ,`StreetName` = 'Southgate' ,`StreetNumber` = '2018' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Double Lot on picturesque Southgate Blvd - Land opportunity now available in Southgate, located minutes from the Texas Medical Center and Rice University. **Seller open to subdividing back to two lots** Perfect for builders or developers. The value is in the land. 2018 Southgate Blvd consists of a double lot totaling 13,200 sqft, including 113 ft of frontage (per HCAD). The west lot has a single story home that is in poor condition, and the east lot is vacant and cleared. The west lot dimensions are 52.8\' x 125\', and the east lot is 60\' x 110\'. Property is located toward the end of a quiet dead end street with no cut through traffic from Main St, as well as one of the few residential streets in all of Houston that has its own grassy/wooded median. Southgate is a desirable, established, and premier luxury neighborhood in Houston. Close proximity to the Medical Center, Hermann Park, Rice University, West University, Museum District, Montrose, and convenient access to downtown.' ,`Acres` = '0.303' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 18A 19 19A & 20A BLK 21 SOUTHGATE' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '13200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Southgate' ,`TaxAmount` = '26563' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651952' WHERE `Matrix_Unique_ID` = '205179936' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:07:33.180' ,`MLSNumber` = '45490081' ,`ListAgentFullName` = 'Amy Ennis' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.300783' ,`Longitude` = '-94.273455' ,`PhotoCount` = '28' ,`PostalCode` = '75929' ,`RoomCount` = '3' ,`ListPrice` = '244999.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2558' ,`StreetNumber` = '213' ,`StreetSuffix` = '' ,`City` = 'Broaddus' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2405' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FISHERMAN\'S DREAM!! This charming home with oversized garage is the perfect place to retreat and enjoy the quiet life in the quaint town of Broaddus. It is a short 5 minute drive from Sam Rayburn Reservoir with easy boat launch access. The house sits on 2 full acres with a small pond at the back of the property. It features an open floorplan, covered patio and extra parking for guests. You don\'t want to miss out on seeing this beautiful property!!' ,`Acres` = '2' ,`Area` = '78' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 433 W GRAHAM & IMPROVEMENT' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '232 - Broaddus' ,`SchoolElementary` = 'BROADDUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROADDUS HIGH SCHOOL' ,`SchoolMiddle` = 'BROADDUS HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'AB 433 W GRAHAM & IMPROVEMENT' ,`TaxAmount` = '2584' ,`TaxRate` = '1.4992' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651952' WHERE `Matrix_Unique_ID` = '205978586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:44:27.940' ,`MLSNumber` = '69522725' ,`ListAgentFullName` = 'Kenneth Purswell' ,`ListOfficeName` = 'Kenneth Purswell - Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.752469' ,`Longitude` = '-95.388767' ,`PhotoCount` = '50' ,`PostalCode` = '77006' ,`RoomCount` = '16' ,`ListPrice` = '1095000.00' ,`Status` = 'Active' ,`StreetName` = 'Peden' ,`StreetNumber` = '615' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2891' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remarkable Craftsman Home in Upper Montrose 3 Bedroom 3 Bath with Library/Study, Sunroom, 2 floor Den Garage Apartment 1 Bedroom 1 Bath .\r\nExtensive Reconstruction & Renovations in 1999, Additional Foundation Piers, Renewed Plumbing and Electrical plus Stand-By Generator, Hardwood Floors, Crown Molding, Insulated Windows and Walls, Recessed Lighting. Exceptional location close to Downtown, Memorial & Buffalo Bayou Parks, walk-able to schools, shop, restaurants. Home has been utilized as a Live Work Space in recent years. The Home was built in 1930 for prominent Railroad Executive' ,`Acres` = '0.1169' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 2 AVON PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '5090' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Avon Place' ,`TaxAmount` = '17966' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651952' WHERE `Matrix_Unique_ID` = '207528225' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:14:35.990' ,`MLSNumber` = '84495580' ,`ListAgentFullName` = 'Booker Terrell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194853' ,`Longitude` = '-95.126817' ,`PhotoCount` = '37' ,`PostalCode` = '77372' ,`RoomCount` = '9' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Rio Blanco Drive' ,`StreetNumber` = '27615' ,`StreetSuffix` = '' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2619' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This could be it! Buyers can install a second driveway, RV Pad, 20X30 shed and still have room for a pool. \r\n\r\nRio Vista is a highly sought-after acreage community established in Splendora, Tx. In the Rio Vista community you will find our must see elegant Mediterranean custom designed home. On 1.27 acres, this boastful open split floor plan furnishes this home with high ceilings, crown molding throughout, extended height baseboards, tiled flooring in common areas, and carpet in the bedrooms. The kitchen is outfitted with all stainless-steel appliances, has an island, granite countertops, rock paneled backsplash, tall cabinets, trey ceiling, and recessed L.E.D. lighting. The open concept flows from the kitchen into the living room, which possess large windows to maximize incoming natural light. \r\n\r\nLarge primary and secondary bedrooms and walk-in closets. Granite counter tops extends throughout all secondary bath areas. Large, covered patio deck with marble swirl epoxy flooring.' ,`Acres` = '1.27' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S827600 - RIO VISTA, BLOCK 1, LOT 78, ACRES 1.27' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '55321' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Rio Vista' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651953' WHERE `Matrix_Unique_ID` = '207595625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:33:50.823' ,`MLSNumber` = '4642735' ,`ListAgentFullName` = 'Tamintris Robinson' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434757' ,`Longitude` = '-95.434266' ,`PhotoCount` = '44' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '321900.00' ,`Status` = 'Active' ,`StreetName` = 'Whitney Reach' ,`StreetNumber` = '10238' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This HOME IS READY!!\r\nWe LOVE Realtors! NEW HOMES available call Tamintris for more details.\r\n \r\nRoom sizes have been estimated. Bring us your buyers! Room sizes are estimated. \r\nTaxes on CAD are currently for LOT value only! Agents, please advise your buyer once closed your buyer will have to pay. Taxes based on land and structure!!!\r\nAlvin ISD' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 5 (A0288 HT&BRR) BLK 1 LOT 17' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = '' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'SIERRA VISTA' ,`TaxAmount` = '1683' ,`TaxRate` = '3.606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651953' WHERE `Matrix_Unique_ID` = '209309079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:03:18.783' ,`MLSNumber` = '30579231' ,`ListAgentFullName` = 'Gary Reifel' ,`ListOfficeName` = 'Professional Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.933875' ,`Longitude` = '-95.684749' ,`PhotoCount` = '19' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '103000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 162' ,`StreetNumber` = '2312' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to country living. This 3-bedroom 2 bath home is on block and beam and has a 2-car garage. The 1216 square foot home needs some TLC. Has two living areas, with dining area as well. Home did not flood during Harvey. Come take a look! Many possibilities this home has to offer. Seller HAS PUT IN NEW AIR CONDITIONING AND HEATING SYSTEM.\r\nAppraisal District has 1216 square feet, seller says 1500 square feet.' ,`Acres` = '1' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MORRISON & COOPER AB 63 A C BELL S/D 1.00 ACRES PT LT 6' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Morrison & Cooper' ,`TaxAmount` = '1271' ,`TaxRate` = '1.9671' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651953' WHERE `Matrix_Unique_ID` = '209600620' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:32:37.257' ,`MLSNumber` = '65142445' ,`ListAgentFullName` = 'Lee Christensen' ,`ListOfficeName` = 'Kimberly Beggs' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.140600' ,`Longitude` = '-95.050062' ,`PhotoCount` = '45' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '582500.00' ,`Status` = 'Active' ,`StreetName` = 'Ector' ,`StreetNumber` = '4019' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home! This 2018 constructed 3 bed 2 bath over 1500 square foot home is move in ready as it comes furnished with very few exclusions! This has been a private family home, never rented. Whether you want to live full time or make it a getaway you will find this home has amenities that will give the entire family something to do! The fully fenced yard, garage, and under home party area with plenty of parking even outside the fence is a great feature. Yet, the VIEW from your balcony and from inside the living and kitchen area overlooking one of the beautiful canals is breathtaking! Water Views and steps away from the Gulf – get ready to enjoy island life! Sea Isle community boast two stores, restaurants, bars, marina, bait shop, pool, tennis/pickle ball court and the longest private fishing pier on the island! Park your car when you arrive - it is walkable, ride your bike, and most use a golf cart to travel through the various neighborhoods and beach areas.' ,`Acres` = '0.1439' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 15 LOT 884 SEA ISLE 4TH EXTENSION' ,`LotDesciption` = 'Water View' ,`LotSize` = '6270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '215' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Ext 4' ,`TaxAmount` = '7912' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651953' WHERE `Matrix_Unique_ID` = '209611148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:18:53.897' ,`MLSNumber` = '11998590' ,`ListAgentFullName` = 'Carlito Rivera' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = 'Juan Barron' ,`SellingOfficeName` = 'RE/ImageProperties and Investm' ,`Latitude` = '29.797267' ,`Longitude` = '-95.173358' ,`PhotoCount` = '21' ,`PostalCode` = '77015' ,`RoomCount` = '5' ,`ListPrice` = '234900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kirkaldy' ,`StreetNumber` = '238' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this newly remodeled 3 bedroom, 2 full bath home. Newly installed vinyl flooring through out common areas and new carpet in the bedrooms give this home a cozy feeling fresh paint interior and exterior, new appliances, cabinets, quartz counter-tops and many more. The 2 car garage and fenced in large backyard provides plenty of room for a pool or simply entertaining and activities. Located just minutes away from major shopping, schools and a college.' ,`Acres` = '0.2019' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 47 WOODFOREST SEC 17 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'HAVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest 17 & Rp' ,`TaxAmount` = '4105' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651953' WHERE `Matrix_Unique_ID` = '210252726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:07:32.553' ,`MLSNumber` = '7859474' ,`ListAgentFullName` = 'Lauren Friese' ,`ListOfficeName` = 'Tilbury Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816984' ,`Longitude` = '-95.339264' ,`PhotoCount` = '48' ,`PostalCode` = '77026' ,`RoomCount` = '8' ,`ListPrice` = '222897.00' ,`Status` = 'Active' ,`StreetName` = 'Melbourne' ,`StreetNumber` = '3202' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW PRIVACY Fence to be installed. Renovated Chic Bungalow energy eff. windows, doors; NEW A/C unit; Freshly painted interior light modern gray w/ white baseboard & window sashes, a beautiful contrast refinished deep mahogany original hardwoods. Kitchen: Custom ceiling high white trimmed cabinetry, modern polished nickel hardware, storage a solutions: built in Lazy Susan corner, built in pot and pan extending drawer, storage under the 48\" high granite top island. Granite Counters, White Subway tile back splash, Ceramic tile floors, modern faucet\'s and fixtures. Spa inspired Bathrooms are chic. A Family room right off the kitchen and Utility room with extra storage for everyone\'s favorite activity - \"Laundry\"! The upstairs : 2 bedrooms and study / office area w/ storage closet. The home is on a large Corner lot enclosed with a fence with single car garage. In rear of garage workshop w/ sink hook ups. Exterior: new hardi, paint & freshly landscaped yard. Includes Home warranty!' ,`Acres` = '0.2016' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 25A BLK 6 HUNTINGTON PLACE EXTN' ,`LotDesciption` = 'Corner' ,`LotSize` = '8783' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PAIGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Huntington Place Ext' ,`TaxAmount` = '2529' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651954' WHERE `Matrix_Unique_ID` = '211362385' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:54:04.110' ,`MLSNumber` = '53914321' ,`ListAgentFullName` = 'Robert Gresham' ,`ListOfficeName` = 'RE/MAX Eastside' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.854870' ,`Longitude` = '-95.005293' ,`PhotoCount` = '16' ,`PostalCode` = '77532' ,`RoomCount` = '3' ,`ListPrice` = '144900.00' ,`Status` = 'Active' ,`StreetName` = 'Stables Ln' ,`StreetNumber` = '3919' ,`StreetSuffix` = '' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'County living with no restrictions! Great location between Crosby and Baytown! This three bedroom home is move-in ready and sits on a quiet lot in Crosby. Nice size primary bedroom. Primary Bathroom has jacuzzi style bathtub, double sinks, and a separate shower. Bedroom two and three share a full bathroom with a shower/tub combo. Washer and dryer are staying with the home! Front porch is covered and is wheelchair accessible.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 3F-7 BLK 3 (LT 46B)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6970' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Elena Fruit & Cotton Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.0766' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651954' WHERE `Matrix_Unique_ID` = '211527842' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:51:05.243' ,`MLSNumber` = '15056988' ,`ListAgentFullName` = 'Ashly Singletary' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081577' ,`Longitude` = '-95.361550' ,`PhotoCount` = '29' ,`PostalCode` = '77386' ,`RoomCount` = '3' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Aspen Horizon' ,`StreetNumber` = '28126' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2479' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful Lennar home located in the Master-Planned living in Harmony Village! Zoned to highly acclaimed Conroe ISD schools. This home is conveniently located with easy access to the Grand Parkway and I-45, also many fine dining restaurants and shopping in The Woodlands! This home is on a larger lot and loaded with upgrades. It comes with the technology and smart home capabilities. New sliding glass doors that open into the backyard, overhead racks installed in the garage - the upgrade list goes on and on. Open concept kitchen with a perfect size island with granite countertops and stainless steel appliances. This home has 3 large bedrooms and great size closets, with easy access to attic space. Upstairs features a gameroom space with additional closets for plenty of storage. Harmony subdivision has 2 pools, 2 splash pads, 3 parks, gym, tennis and basketballs courts, as well as many walking trails. See list of all of the upgrades and in attachments.' ,`Acres` = '0.1774' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S571210 - HARMONY VILLAGE 10, BLOCK 3, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7727' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harmony Village 10' ,`TaxAmount` = '7862' ,`TaxRate` = '2.9587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651954' WHERE `Matrix_Unique_ID` = '211788546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:28:37.570' ,`MLSNumber` = '60533868' ,`ListAgentFullName` = 'Tamintris Robinson' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.436301' ,`Longitude` = '-95.435668' ,`PhotoCount` = '18' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '298900.00' ,`Status` = 'Active' ,`StreetName` = 'Whitney Reach' ,`StreetNumber` = '10135' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sierra Vista Community 4 bedroom - 2 bath - 2 car garage, fenced back yard. Tile in all wet areas - Sod in front and back yard along with landscaping. All Applicance are Frigidaire Stainless steel. Tile backsplash \r\nTaxes on CAD are currently for LOT value only!\r\n\r\nHome is move in ready!' ,`Acres` = '0.227' ,`Area` = '5' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 5 (A0288 HT&BRR) BLK 2 LOT 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9888' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '1690' ,`TaxRate` = '3.606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651954' WHERE `Matrix_Unique_ID` = '211814925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:51:56.613' ,`MLSNumber` = '81172487' ,`ListAgentFullName` = 'Adriane Taylor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.032662' ,`Longitude` = '-95.645042' ,`PhotoCount` = '35' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Telge Lake' ,`StreetNumber` = '15123' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2183' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4 BD spacious one-story located in the highly desirable Oakcrest subdivision in Cypress! Open concept floor plan w/ an eat-in kitchen. Huge kitchen contains an abundance of granite countertops and 42-inch cabinetry w/ a built-in desk next to the refrigerator. 3 designated bedrooms w/optional 4th off living rm has French doors & could serve as a home office. The Extra LARGE living room w/fireplace is centrally located within this home and overlooks the fully fenced-in backyard. The sizable primary bedroom is separate from the other secondary bedrooms and has an adjoining on-suite bath with dual closets, dual sinks, jetted tub, and separate shower! A 2-car garage and a shed in the backyard complete this home . HVAC is only 2yrs old & comes with warranty! Zoned to exemplary Tomball public schools! What are you waiting for? See it today!' ,`Acres` = '0.1685' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 4 OAKCREST NORTH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '795' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'WILDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakcrest North' ,`TaxAmount` = '6224' ,`TaxRate` = '2.8172' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651955' WHERE `Matrix_Unique_ID` = '211938665' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:59:25.617' ,`MLSNumber` = '35170051' ,`ListAgentFullName` = 'Jim Atkinson' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.498712' ,`Longitude` = '-94.949489' ,`PhotoCount` = '27' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue D' ,`StreetNumber` = '2570' ,`StreetSuffix` = '' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2167' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A great find with cottage charm! This lovely 3 bed 2 bath home is nestled on nearly 1.3 acres with a pond! The \"SIP Panel\" home features a spacious open floorplan with the kitchen front and center and no carpet. Completing the kitchen is a colossal sized eat-in island, gas range, stainless steel appliances and ample storage. Don’t forget to check out the impressive primary closet and bathroom too! Beyond the exposed beams, beautiful flooring and the core foam walls is a large wooden deck overlooking the backyard, perfect for autumn. Tour this beauty for yourself today!' ,`Acres` = '1.252' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS SUR PT OF LOT 7 (7-2) BLK 9 SAN LEON FARM' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '54537' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'San Leon Farm Home Tracts' ,`TaxAmount` = '6224' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651955' WHERE `Matrix_Unique_ID` = '212020145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:15:08.407' ,`MLSNumber` = '31941602' ,`ListAgentFullName` = 'Crystal Mason' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043740' ,`Longitude` = '-95.106648' ,`PhotoCount` = '16' ,`PostalCode` = '77336' ,`RoomCount` = '4' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Wateridge' ,`StreetNumber` = '25702' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION! Beautiful and spacious 4 bedroom- 3 bathroom home on a corner lot. Vaulted ceilings in living area and high ceilings in kitchen with open concept design. Game room/full bathroom and plenty of storage upstairs. Home modern farmhouse/ matte black finishes and fixtures throughout with stainless kitchen appliances..Huge front and back porches. Large garage, 8 foot doors throughout, and mud room! Easy access to 1960 for shopping/restaurants etc.. The approximate completion date is mid November. \r\nSchedule your tour today!' ,`Acres` = '0.2479' ,`Area` = '1' ,`BuilderName` = 'Kensli Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 WATER WONDERLAND U/R' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Water Wonderland U/R' ,`TaxAmount` = '689' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651955' WHERE `Matrix_Unique_ID` = '212250400' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:17:16.337' ,`MLSNumber` = '98097552' ,`ListAgentFullName` = 'Melissa Whitehead' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = 'Christina Williams' ,`SellingOfficeName` = 'Keller Williams Elite' ,`Latitude` = '30.103446' ,`Longitude` = '-94.893561' ,`PhotoCount` = '24' ,`PostalCode` = '77535' ,`RoomCount` = '7' ,`ListPrice` = '150000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 67631' ,`StreetNumber` = '75' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1190' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Front porch sitting, under the Texas skies, where the grass is greener... enjoy country living on acreage property at its best! This single owner home has brand new flooring along with a couple other improvements and is move in ready! The septic was last serviced on 8/2022 and the combo AC/Heater Unit was replaced in 11/2021. Ample parking as well as a storage shed for your extras! Property is being sold with adjoining property noted with Liberty County Appraisal District as County Road 6763 APN: 0078953-000414-000 Legal Description:WEST WOODLAND HILLS II, BLOCK 4, LOT 14 TR 1, ACRES 0.967. Seller does not have a survey, buyer will have to purchase if one is needed or desired to confirm boundary lines, lot dimensions, etc. Never Flooded!' ,`Acres` = '0.696' ,`Area` = '52' ,`BuilderName` = 'Clayton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WEST WOODLAND HILLS II, BLOCK 4, LOT PT 15, TRACT 1, ACRES .' ,`LotDesciption` = 'Cleared' ,`LotSize` = '30318' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West Woodland Hills II' ,`TaxAmount` = '662' ,`TaxRate` = '1.7512' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669651955' WHERE `Matrix_Unique_ID` = '212373956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:17:44.430' ,`MLSNumber` = '69165833' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.478134' ,`Longitude` = '-95.217751' ,`PhotoCount` = '50' ,`PostalCode` = '77546' ,`RoomCount` = '6' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Miami' ,`StreetNumber` = '2703' ,`StreetSuffix` = 'Court' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FABULOUS semi-custom Norwood home prestigious Boca Raton Estates. Walk through the front double doors and be welcomed by the beautiful 2 story foyer with a wrap around staircase. To the left of the entrance you will find a bright and private home office with french double doors. An inviting and elegant Formal Dining room is just to the right. The Living room is anchored by a stunning gas fireplace adorned with an exquisite Texas sized tile from floor to ceiling. Large gourmet kitchen with oversized island, Quartz countertops and SS appliances adjoins an amazing walk in pantry featuring an additional island and tons of storage. A spacious primary bath w/ dual sinks, soaking tub and HUGE double shower await you as part of your owner retreat. Upstairs great game room, three bedrooms, and a SECRET ROOM. Home sits on huge lot w/no backyard neighbors, a garage workshop and a Porte-Cochere. READY TO MOVE-IN!' ,`Acres` = '0.3136' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 184 M SLOAN SUR LOT 11 BLK 9 BOCA RATON SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13661' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Boca Raton Sec 2 96' ,`TaxAmount` = '10459' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651956' WHERE `Matrix_Unique_ID` = '212383646' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:22:14.490' ,`MLSNumber` = '76186668' ,`ListAgentFullName` = 'Grace Harris' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.421768' ,`Longitude` = '-95.558610' ,`PhotoCount` = '10' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '327990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ridgeview' ,`StreetNumber` = '13277' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1677' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lakeside living! Community has a private boat ramp w/park and pavilion. Beautiful stone & brick 1 story home with 3 beds, 2 baths & 2car on cul de sac lot! Inviting entry with leaded glass door and Crown molding. Vinyl wood plank flooring throughout the home, carpet in bedrooms only! Open kitchen with White cabinets and island overlooking the family room! Kitchen is equipped with granite countertops, custom designer backsplash & stainless steel appliances! The master suite is tucked away from the living room with a spacious master bath with separate tub & shower, double vanities with plenty of storage for you and your spouse! Big secondary bedrooms for the kiddos! Home includes a fenced backyard, structured wiring panel, USB outlets in Master and Kitchen and so much more! Willis ISD schools with low taxes and HOA dues. Call for showing today!' ,`Acres` = '0.319904' ,`Area` = '39' ,`BuilderName` = 'KENDALL HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE HILLS 02, BLOCK 10 LOT 33' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '196' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Hills' ,`TaxAmount` = '' ,`TaxRate` = '2.2948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651956' WHERE `Matrix_Unique_ID` = '212553483' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:17:14.853' ,`MLSNumber` = '84401067' ,`ListAgentFullName` = 'Scarlett Snell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Kristina Davidson' ,`SellingOfficeName` = 'Executive Real Estate' ,`Latitude` = '30.078586' ,`Longitude` = '-95.777946' ,`PhotoCount` = '31' ,`PostalCode` = '77447' ,`RoomCount` = '3' ,`ListPrice` = '255000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Rustic Brick' ,`StreetNumber` = '22719' ,`StreetSuffix` = 'Avenue' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this great one story home that features an open floor plan and amazing backyard! Stepping into the formal entry you\'ll immediately notice how light and bright this home is. Right off the entry is your formal dining room which can be used as a flex space to create any room to fit your needs. As you enter the large kitchen you\'ll appreciate the open floor plan of this wonderful home. The kitchen features an undermount sink, freestanding electric range, loads of counter space, and granite counters. Continuing through the home you also notice all the arched doorways and the fresh carpet (installed Sept. 2022). Enjoy your own primary suite equipped with a garden tub and separate shower. Out back you\'ll find a large covered patio, huge spacious yard, and no back neighbors. If this home isn\'t amazing enough this home\'s community also features great amenities like a gorgeous pond and fantastic playground! Come see this home quick!' ,`Acres` = '0.1506' ,`Area` = '35' ,`BuilderName` = 'LGI' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 BAUER LANDING SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6559' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '99' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bauer Landing' ,`TaxAmount` = '5651' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651956' WHERE `Matrix_Unique_ID` = '212573663' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:04:34.753' ,`MLSNumber` = '64526125' ,`ListAgentFullName` = 'Suzie Ford Walker' ,`ListOfficeName` = 'Hatch Agency' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.774404' ,`Longitude` = '-95.480249' ,`PhotoCount` = '34' ,`PostalCode` = '77024' ,`RoomCount` = '12' ,`ListPrice` = '999999.00' ,`Status` = 'Active' ,`StreetName` = 'Chimney Rock' ,`StreetNumber` = '259' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 259 Chimney Rock. If you love nature but want to live in the city, look no further! This incredible mid century modern home situated on a 40,000+ square foot lot is the perfect cross between the fast pace of city living and the calming oasis that the serene backyard gives. Originally built in 1954, the kitchen and utility room were updated in 2006. Leaving the modern feel but making it a chefs dream. The floor to ceiling windows throughout allow for natural light to pour into the home and gives incredible views of the property. The backyard is an entertainers dream with a massive patio, Koi pond, 2 decks, and a yard that is a child\'s paradise for endless adventures! Not only does this property back up to Spring Branch but behind that is St. Mary\'s Seminary. In the front of the home the rainbow drive and privacy wall allows for at least 7 cars not including the garage.' ,`Acres` = '0.9262' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Close In' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 & TR 15B BLK 1 TRS SEC 14 15B HUNTLEIGH' ,`LotDesciption` = 'Other' ,`LotSize` = '40347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Huntleigh' ,`TaxAmount` = '21028' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651956' WHERE `Matrix_Unique_ID` = '212742647' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:14:02.230' ,`MLSNumber` = '30419425' ,`ListAgentFullName` = 'Nancy Bilderback' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.187038' ,`Longitude` = '-95.692755' ,`PhotoCount` = '33' ,`PostalCode` = '77362' ,`RoomCount` = '11' ,`ListPrice` = '700000.00' ,`Status` = 'Active' ,`StreetName` = 'Mildred' ,`StreetNumber` = '36099' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom 5 bedroom home with 3 full baths and 2 car attached garage on 3 wooded acres that includes a guest house and workshop! Bring your horses or business - no restrictions! This home has 2 bedrooms down including a newly added huge primary bedroom and ensuite bath w/walk-in closet! Guest bedroom is also down and has access to a full bathroom! The large kitchen has been beautifully updated and perfect for those who love to cook and entertain - with custom cabinets, granite counters, stainless steel applicances including a VIKING 6 BURNER STOVE, and a SUB ZERO REFRIGERATOR! Private guest house in back that has it\'s own kitchen, bedroom and full bath - perfect for in-laws, guests or a teenagers hangout! Large workshop in back as well for the handy man that can be used as a garage (has room for 4 cars) or just extra storage. Come live in the country but be close to everything! Restaurants and shopping are just a short drive to Tomball & Magnolia!' ,`Acres` = '3' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '3 ACRES OUT OF LOTS 1&2, BLOCK 1 OF MILL CREEK FOREST' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '130680' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Forest' ,`TaxAmount` = '4215' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank,Well' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651956' WHERE `Matrix_Unique_ID` = '213070510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:14:29.623' ,`MLSNumber` = '62122920' ,`ListAgentFullName` = 'Somer Padilla' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.055386' ,`Longitude` = '-95.562711' ,`PhotoCount` = '34' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '384000.00' ,`Status` = 'Active' ,`StreetName` = 'Brackenton Crest' ,`StreetNumber` = '9410' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2301' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor Only. Tenants in place for 2 year lease. Gorgeous one story home in the desirable master planned golf course community. Features both formals PLUS a flex space between the two secondary bedrooms. Guest full bathroom was just completely updated and includes a new frameless shower glass. The natural light that exudes through this home showcases the new luxury plank flooring beautifully...absolutely no carpet! Open floor plan with an oversized kitchen w/recently painted cabinets, under cabinet lighting, and new charcoal stainless appliances. New ceiling fans, lighting fixtures, trim and walls just painted, roof installed 2015, and freshly painted garage floors with a durable finish. Enjoy your morning coffee with views of the new landscaping from your charming front porch, or covered back patio. Amenities include lakes, parks, tennis courts, fitness center, sports complex, pools, lazy river, and equestrian center. Zoned to top rated Klein ISD w/easy access to Grand Pkwy.' ,`Acres` = '0.1522' ,`Area` = '14' ,`BuilderName` = 'David Weekly' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 59 BLK 1 GLEANNLOCH FARMS SEC 33' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '6628' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms Sec 33' ,`TaxAmount` = '6314' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651957' WHERE `Matrix_Unique_ID` = '213081797' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:24:05.263' ,`MLSNumber` = '6661703' ,`ListAgentFullName` = 'MaryAnn Locknar' ,`ListOfficeName` = 'Locknar Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729228' ,`Longitude` = '-95.537250' ,`PhotoCount` = '42' ,`PostalCode` = '77063' ,`RoomCount` = '10' ,`ListPrice` = '384900.00' ,`Status` = 'Active' ,`StreetName` = 'Beverlyhill' ,`StreetNumber` = '9630' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2476' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to tree lined streets and HUGE property lots less than 10 miles west of the Galleria. Tanglewilde subdivision has it\'s own park and it shares a neighborhood pool with sister neighborhood (Westmont) all within walking distance of any section. 1.5 Story property with 2 bedrooms down and 2 HUGE bedrooms up. This house SPARKLES! It is super CLEAN! Enjoy all the updates and improvements including soft close cabinets in the kitchen/breakfast area, downstairs has new, consistent tile flooring, upstairs has new carpet, fresh paint, New wooden privacy fence with ornate iron gates, walkways, appliances, lighting with dimmers, new security system, and landscaping. Make your appointment to see this beauty today!' ,`Acres` = '0.2654' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 17 TANGLEWILDE SEC 5' ,`LotDesciption` = 'Ravine,Subdivision Lot' ,`LotSize` = '11560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'EMERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Tanglewilde Sec 05' ,`TaxAmount` = '6013' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651957' WHERE `Matrix_Unique_ID` = '213124262' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:37:14.943' ,`MLSNumber` = '21345790' ,`ListAgentFullName` = 'Phuc Nguyen' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680928' ,`Longitude` = '-95.837073' ,`PhotoCount` = '41' ,`PostalCode` = '77406' ,`RoomCount` = '13' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Sparkling Stream' ,`StreetNumber` = '10530' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST REDUCED PRICE! Welcome to this grand, luxurious, 2-story home nested in the quiet Candela neighborhood. Home features custom-installed, luxurious-lightings, radiating beautifully in foyer and living room, upgraded 8-feet doors, double-door entrance, and upgraded master bathtub. Home features high ceiling, an open floor plan, and view from opening through rails from second level, perfect for large gatherings. Granite countertops, drapes for windows, crown-molding, custom-shelved in study, large stand-alone primary shower, and spacious utilities space. Outdoor structures are built mainly with bricks throughout.' ,`Acres` = '0.2166' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANDELA SEC 2, BLOCK 2, LOT 14' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9433' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651957' WHERE `Matrix_Unique_ID` = '213223826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:02:39.520' ,`MLSNumber` = '10110896' ,`ListAgentFullName` = 'Kayla Verret' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Regina Pope' ,`SellingOfficeName` = 'Shaw Real Estate' ,`Latitude` = '29.424331' ,`Longitude` = '-95.369582' ,`PhotoCount` = '31' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '290000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Tiffany' ,`StreetNumber` = '9825' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This home sits on a 1 acre lot in a quiet area. This home features 3 bedrooms 2 full baths and a garage apartment with its own full bath. This home has a large covered back patio to sit under to enjoy some rest and relaxation. This home also has a propane tank to supply gas to the home. This home will not last long so call and schedule your appointment.' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'LEEDY ESTATES (A0584 A J WATTS) LOT 28B ACRES 1.00' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Leedy Estates' ,`TaxAmount` = '6014' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669651957' WHERE `Matrix_Unique_ID` = '213290183' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:13:39.740' ,`MLSNumber` = '40455140' ,`ListAgentFullName` = 'Summer Davis' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.125661' ,`Longitude` = '-95.542487' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '12' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Wooded Way' ,`StreetNumber` = '7806' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Elegant four bedroom and three & half bath custom home sits on a huge lot in the prestigious golf community of Augusta Pines. Features custom cabinetry w/built ins in formal living & study, hardwood flooring, trey ceilings w/mood lighting, designer fixtures, double pane windows w/plantation shutters, surround sound & an abundance of natural light throughout. Gourmet kitchen has breakfast bar, custom island, stainless steel Thermador appliances, 5 burner gas stove, double oven, granite countertop & walk in pantry are all sure to make any chef\'s dream come true. Primary bedroom is sure to please w/views overlooking pool and an en suite has his & hers separate sinks & walk in closet w/built ins. Two addt\'l rooms are downstairs w/adjoining hollywood bath. Game room & addt\'l bedroom upstairs w/private bath. Beautiful tropical oasis awaits you outside w/private pool & spa, huge covered patio, home generator, backyard mosquito system & 3 car garage w/pebble tec floor.' ,`Acres` = '0.6544' ,`Area` = '14' ,`BuilderName` = 'Rosemond Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 AUGUSTA PINES SEC 3' ,`LotDesciption` = 'Corner,In Golf Course Community' ,`LotSize` = '28507' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'METZLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Augusta Pines Sec 03' ,`TaxAmount` = '19536' ,`TaxRate` = '2.864' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651958' WHERE `Matrix_Unique_ID` = '213505248' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:38:38.260' ,`MLSNumber` = '98052201' ,`ListAgentFullName` = 'Gaye Watkins' ,`ListOfficeName` = 'RE/MAX Integrity II' ,`SellingAgentFullName` = 'Troy Johnson' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '30.424256' ,`Longitude` = '-95.631632' ,`PhotoCount` = '36' ,`PostalCode` = '77356' ,`RoomCount` = '9' ,`ListPrice` = '520000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Marietta' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous One Story home in Bentwater located on a quiet Cul-de-Sac and walking distance to the Country Club, Sports Facility, Pool and Tennis Courts. This home has a circle driveway and 3 car garage with workshop along with a huge Texas Basement. Wood floors in living, dining, study, and kitchen along with newish carpet in guest bedrooms. Built-in entertainment center in living area and great storage through out the home. Wonderful open floor plan with high ceilings makes for easy entertaining. Details also include Techshield wood decking, tank less water heater, hurricane straps, new roof 2019. New a/c in 2021 that is 17 Seer, ductwork also replace. WHOLE HOUSE GENERATOR. Views from your screened-in porch include the waterfall and patio area under your retractable awning looking out to the new fence.\r\nalong with the lush landscaping and mature trees.' ,`Acres` = '0.3306' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 19, BLOCK 2, LOT 14' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '14403' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1146' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '7791' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651958' WHERE `Matrix_Unique_ID` = '213515956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:07:50.713' ,`MLSNumber` = '94964839' ,`ListAgentFullName` = 'Carlazeli Garcia' ,`ListOfficeName` = 'Ross & Marshall Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722655' ,`Longitude` = '-95.632229' ,`PhotoCount` = '43' ,`PostalCode` = '77082' ,`RoomCount` = '4' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Naomi Hollow' ,`StreetNumber` = '13802' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 13802 Naomi Hollow Lane! At 2,500 heated square feet, this 4 bedroom, 2.5 bathroom home has plenty of space! Home sits on a corner lot showing pride and joy. Property features new paint, updated kitchen and bathrooms, plus more! The addition of the covered patio with a ceiling fan makes it the perfect area for entertaining. Its subdivision has exclusive access to Brays Bayou Park, next to the community pool and playground. Brays Bayou Park is a 337 acre multi-use area and includes 5+ miles of hike and bike trails. \r\n\r\nHome has lifetime transferable foundation warranty! Never flooded! No Mud taxes and low HOA fees.\r\n\r\nBe sure to check out the virtual tour, our open house this Saturday or Sunday (12-3PM), and schedule your showing today!' ,`Acres` = '0.1309' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 102 BLK 5 (ORIG RES L BK 7) WESTHOLLOW VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'Enclosed' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westhollow Village Sec 01 Correcti' ,`TaxAmount` = '5822' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651958' WHERE `Matrix_Unique_ID` = '213522529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:15:03.400' ,`MLSNumber` = '98460357' ,`ListAgentFullName` = 'Javier Valencia' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759366' ,`Longitude` = '-95.877741' ,`PhotoCount` = '31' ,`PostalCode` = '77494' ,`RoomCount` = '4' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Angel Trumpet' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 bed 3 full bath home in the Firethorne master planned community! Offering trails, pools, gym and parks! You don\'t want to miss this opportunity, low taxes, and an excellent school district. This home features high ceilings open concept with plenty of room to entertain, updated wooden floors, modern kitchen with a breakfast bar, wood cabinets and a walk in pantry, If you like natural light this home has floor to ceiling windows that will illuminate your entire kitchen and living area! The Primary bedroom at rear end of the home includes double sinks and a disconnected tub and shower. 3 additional spacious bedrooms and office space to work from home. Plenty of shopping & dining in close proximity. Great location right off Texas Heritage Parkway & I-10 very easy commute. This home will impress you even more when you see it in person!' ,`Acres` = '0.1377' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE WEST SEC 12, BLOCK 5, LOT 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Firethorne West Sec 12' ,`TaxAmount` = '7704' ,`TaxRate` = '2.5848' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669651958' WHERE `Matrix_Unique_ID` = '213535423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:14:10.233' ,`MLSNumber` = '97843402' ,`ListAgentFullName` = 'Shawn Saxton' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.940777' ,`Longitude` = '-95.200451' ,`PhotoCount` = '23' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '297500.00' ,`Status` = 'Active' ,`StreetName` = 'Starry Summer' ,`StreetNumber` = '12435' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful like new home built by Saratoga in 2019! Upon entering the foyer this Elise plan offers a spacious formal dining room that can dual as a living area as well! The kitchen is a chef\'s DREAM that features granite countertops, stainless steel appliances, and a large walk in pantry. The kitchen also has an island and breakfast seating area that overlooks the spacious family room which makes it perfect for entertaining! This home also offers a flex/study room and covered back patio for your enjoyment! The exceptionally spacious primary bedroom features a luxury en-suite bath with a spacious walk in closet, double sinks, separate shower and a soaking tub! This home is zoned to the award winning Humble ISD and is close to lots of shopping and major highways! The only thing this home is missing is you! Look no further! Welcome Home! Buyer to verify all info.' ,`Acres` = '0.1332' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 SUNSET RIDGE SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Ridge' ,`TaxAmount` = '7435' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651959' WHERE `Matrix_Unique_ID` = '213544242' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:12:09.010' ,`MLSNumber` = '21636434' ,`ListAgentFullName` = 'Louis Salas' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.168897' ,`Longitude` = '-94.997697' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '739000.00' ,`Status` = 'Active' ,`StreetName` = 'Shaman' ,`StreetNumber` = '18515' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1808' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction with a Great Room is the center of attention, featuring an open floor concept with living, dining, and kitchen. The great room features recessed lighting. The kitchen\'s large island will be the center of your entertainment with family and friends that continues on one of the two desks that the home sports with amazing distant beach views or the spacious outside grounds with spaces to enjoy in the shade. The home has four bedrooms and 3 baths. The primary bedroom is very large and has a walk-in closet and a walk-in shower/frameless glass. The other bedrooms are large and comfortable. One car garage/storage and outdoor shower. The location is perfect for permanent residence or vacation rentals. Subdivision amenities offer a beautiful swimming pool, tennis court, boat launch, fishing pier, and a short ride to the beach. Call Now!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Jerry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 17 BLK 2 INDIAN BEACH SEC 1' ,`LotDesciption` = 'Water View' ,`LotSize` = '21980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '267' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Indian Beach' ,`TaxAmount` = '367' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651959' WHERE `Matrix_Unique_ID` = '213559660' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:05:27.900' ,`MLSNumber` = '78313150' ,`ListAgentFullName` = 'Bob Azzarello' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Heather Karnowski' ,`SellingOfficeName` = 'Connect Realty' ,`Latitude` = '29.765650' ,`Longitude` = '-95.546233' ,`PhotoCount` = '17' ,`PostalCode` = '77024' ,`RoomCount` = '10' ,`ListPrice` = '849990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Beauregard' ,`StreetNumber` = '12331' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3531' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Straight outta Wanda-vision! Needless to say get Vision involved and this becomes your slice of mid-century charm in highly desirable Frostwood! Never before on the market! This has been a family\'s home since the early 1960\'s. A true time capsule that is ready for someone with vision to create a stunning future! Leaded glass windows. French doors. Pocket doors. Gas fireplace w gas logs. Gazebo. Landscaped courtyard entry. Tons of storage. Gas line for dryer. Dishwasher. Well kept, incredible location, zoned to desirable schools, shopping, and dining. City Center just minutes away! Make it yours TODAY!' ,`Acres` = '0.3036' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 FROSTWOOD SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '13225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '256' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Frostwood Sec 01' ,`TaxAmount` = '18155' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651959' WHERE `Matrix_Unique_ID` = '213592896' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:07:33.180' ,`MLSNumber` = '48140078' ,`ListAgentFullName` = 'Kayla Sorrell' ,`ListOfficeName` = 'Pop Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783287' ,`Longitude` = '-95.424631' ,`PhotoCount` = '33' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '579000.00' ,`Status` = 'Active' ,`StreetName` = 'Arabelle' ,`StreetNumber` = '5715' ,`StreetSuffix` = 'Crest' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2879' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape the hustle and bustle of city life while still being in the middle of it all. This home creates a warm feel that will stand the test of time. This home will check off every item on your list - Gated community, modern and contemporary touches, 3 Stories, 4 bedrooms, 3.5 baths, Home Study, Media Room, and overlooking the community lake is your rooftop Terrace and backyard. You\'ll enjoy the functional floor plan, high ceilings, all the natural light dancing throughout the home, large bedrooms, and more. Never be left out of the fun with this open-concept living/dining/and kitchen area. Begin and/or end your day in your backyard or rooftop terrace. Location! Location! Location! Minutes to everything with quick access to 10, 610, 290, and 45 - makes it a commuter\'s dream. This home is perfect for you! Thanks for visiting!' ,`Acres` = '0.0458' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 2 COTTAGE GROVE SEC 8 R/P' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '1997' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2549' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Cottage Grove Sec 08 Rep 01' ,`TaxAmount` = '12020' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651959' WHERE `Matrix_Unique_ID` = '213621767' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:37:11.980' ,`MLSNumber` = '52182361' ,`ListAgentFullName` = 'Jimi Jordan' ,`ListOfficeName` = 'Xterra Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201507' ,`Longitude` = '-97.846506' ,`PhotoCount` = '33' ,`PostalCode` = '78749' ,`RoomCount` = '7' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Danli' ,`StreetNumber` = '3905' ,`StreetSuffix` = 'Lane' ,`City` = 'Austin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently reduced wonderfully remodeled home. Seller\'s offering appliance allowance and willing to pay title. Just a few minutes from down town. New floors, carpet, counters, interior and exterior paint, new HVAC, New Primary bathroom remodeled his and her walk in shower, His and her vanities. New fence, deck and updated landscaping make this home feel like new. Located in the Austin city limits and convenient to the hill country parks and lakes. Great for Families and Professionals alike. This price will not last, book your showing today.' ,`Acres` = '0.1326' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 21 BLK I MAPLE RUN SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5776' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '111 - Austin' ,`SchoolElementary` = 'COWAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOWIE HIGH SCHOOL (AUSTIN)' ,`SchoolMiddle` = 'COVINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Maple Run Sec 08' ,`TaxAmount` = '7615' ,`TaxRate` = '2.1767' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651959' WHERE `Matrix_Unique_ID` = '213629739' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:32:23.903' ,`MLSNumber` = '95350905' ,`ListAgentFullName` = 'Debra Bunton' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960161' ,`Longitude` = '-95.202407' ,`PhotoCount` = '33' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Gramina' ,`StreetNumber` = '11914' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LIKE NEW BUILT 3/22! Extended entry offers spacious home office and media room with French doors. Formal dining flows into open family room with wood mantel fireplace and wall of windows offering lots of natural light. Kitchen has a walk-in pantry and generous island with bar stool space. Primary suite includes entry to bath with dual vanities, garden tub, separate shower and two walk-in closets. Guest suite offers a private bath. High ceilings and abundant closet space add to this four-bedroom design. Extended covered backyard patio, sizeable backyard with trees and no back neighbors. Star Furniture in Family room includes leather sofa, 2 chairs/ottoman, 3 tables=($6.9K), stainless steel 3-door GE refrigerator=($2K) and custom remote window shades=($7K) will stay with any accepted offer. Amenities and activities abound in this neighborhood surrounded by trees, trails, parks, pool, splashpad, fishpond, pavilion, nearby schools, and so much more!' ,`Acres` = '0.1926' ,`Area` = '1' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 GROVES SEC 34' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '8390' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1088' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Groves Sec 34' ,`TaxAmount` = '2339' ,`TaxRate` = '3.5373' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651960' WHERE `Matrix_Unique_ID` = '213696147' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:07:32.553' ,`MLSNumber` = '54773911' ,`ListAgentFullName` = 'Amy Lampman' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.137184' ,`Longitude` = '-95.049776' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Cantina' ,`StreetNumber` = '22122' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CANAL front FULLY FURNISHED 3 bedroom, 2.5 bath beach house. Open concept with large sectional couch, kitchen with GRANITE COUNTERTOPS , ISLAND and SS appliances. LIGHT AND BRIGHT with WHITE CABINETS and DESIGNER TOUCHES. NORTH and SOUTH facing DECKS with FABULOUS SUNSET VIEWS. Lower DECK offers entertaining area with TV, BAR , FIREPIT, colorful LOUNGE CHAIRS, BOAT DOCK with LIFT, BULKHEAD and STORAGE. Whether you are looking for a relaxing home, weekend get away, or income property this is the one for you. Short golf cart ride to marina, restaurant, beach, pool tennis courts and other amenities. CALL TODAY for your PRIVATE TOUR of PARADISE!! Washer, Dryer & Refrigerator to stay with the home.\r\n\r\nLocation in highly desired SEA ISLE' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SEA ISLE SEC 24 (2006), ABST 121, BLOCK 1, LOT 8, ACRES 0.11' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sea Isle Sec 24' ,`TaxAmount` = '13927' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651960' WHERE `Matrix_Unique_ID` = '213732733' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:47:25.027' ,`MLSNumber` = '24357814' ,`ListAgentFullName` = 'Brenda Malone' ,`ListOfficeName` = 'Bluebonnet Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.221636' ,`Longitude` = '-95.502886' ,`PhotoCount` = '42' ,`PostalCode` = '77384' ,`RoomCount` = '12' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Emery Mill' ,`StreetNumber` = '23' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom, 2.5 bath, w/Game room, Study, Extra Room on cul-de-sac street! Completely Remodeled designer kitchen boasts New cabinets, quartz countertops, backsplash, farm sink, stainless appliances! Flowing layout gives versatile space w/custom design elements everywhere! NO carpet downstairs, beautiful wood look & easy maintenance vinyl plank wood floors installed 2021! Washroom w/new cabinets! Master bath remodeled including master closet system. Extra room downstairs for exercise space, baby room or craft room. An Oversized paver patio is perfect for entertaining with an outdoor grill/fireplace. 2.5 car Tandem garage w/side entrance. 4- ZONE High Efficiency HVAC system W/Ultraviolet Light! Quick & easy access to FM1488 & I-45, Minutes away from The Woodlands Mall, dining & shopping , and a short drive to Jones State Forest trails for nature lovers.. Zoned to Woodlands Schools. Walking distance to local park! Don\'t miss this remarkable find!' ,`Acres` = '0.193' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 86, BLOCK 2, LOT 30' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8405' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DAVID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 86' ,`TaxAmount` = '8166' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651960' WHERE `Matrix_Unique_ID` = '213763181' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:00:55.267' ,`MLSNumber` = '48554465' ,`ListAgentFullName` = 'Kim Palomino' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.201679' ,`Longitude` = '-95.446416' ,`PhotoCount` = '50' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Threadtail' ,`StreetNumber` = '8109' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3917' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Impressive Highland Homes Middleton plan on a cul-de-sac street in the master planned community of Harpers Preserve adjacent to The Woodlands and zoned to Conroe ISD. This home has it all including a backyard paradise with pool, gazebo and large covered patio. With 5 bedrooms, study, formal dining, game room, media room and oversized 3-car garage there is nothing this house does not offer. Two bedrooms down, including the primary bedroom and a full bath. The main living area, both downstairs bedrooms, and the office have engineered hardwood. Upstairs are three more bedrooms, two full baths, game room and media room. This special home will not last long! The Upgrade List and Survey are in the Document Section.' ,`Acres` = '0.211' ,`Area` = '15' ,`BuilderName` = 'Highland' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572700 - HARPER\'S PRESERVE 01, BLOCK 8, LOT 51' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9190' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1128' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harpers Preserve' ,`TaxAmount` = '15947' ,`TaxRate` = '3.0088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651960' WHERE `Matrix_Unique_ID` = '213813119' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:26:42.150' ,`MLSNumber` = '74239770' ,`ListAgentFullName` = 'Eric Thomson' ,`ListOfficeName` = 'Crossvine Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.385838' ,`Longitude` = '-95.373699' ,`PhotoCount` = '45' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Ski Texas' ,`StreetNumber` = '6210' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2983' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One-of-a-kind, NEVER FLOODED, lakefront home with soaring ceilings and lots of natural sunlight! This home boasts two expansive master suites (one up and one down) and could function as a multi-generational home. Enclosed boat house with boat lift and rooftop deck on private lake built for water sports! Home also includes two additional bedrooms for rest of family. Open floor plan, great for entertaining. Country living with close-knit community only minutes from Hwy 288, Houston Medical Center, and upcoming Manvel Town Center. Cost of water only $15 per month TOTAL with community water well!' ,`Acres` = '0.7576' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SKI TEXAS S/D (A0663 T F PINKNEY) BLK 1 LOT 4 (UND LAKE & PA' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '33001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ski Texas Sub' ,`TaxAmount` = '9048' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651961' WHERE `Matrix_Unique_ID` = '213856838' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:23:31.880' ,`MLSNumber` = '70733082' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.203058' ,`Longitude` = '-95.517902' ,`PhotoCount` = '39' ,`PostalCode` = '77381' ,`RoomCount` = '12' ,`ListPrice` = '770000.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Cloud' ,`StreetNumber` = '83' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3234' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Village Builders home on a wooded lot in Cochran\'s Crossing! Nestled in the heart of The Woodlands, across from serene pond & close to all amenities - walk to Galatas Elementary! This home features a driveway gate, hardwood floors, brand new interior paint and new carpet, new fridge and new alarms and stunning trim work throughout. Open concept island kitchen with granite counters, double ovens & upgraded custom cabinetry opens to breakfast room & den with cozy gas fireplace; formal dining with chair rail; primary retreat down; 3 bedrooms & game room up; sparkling pool with new pump. No issues during Harvey!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'VILLAGE BUILDERS' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL COCHRANS CR 28, BLOCK 5, LOT 10' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '10549' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'THE WOODLANDS COCHRANS CROSSING' ,`TaxAmount` = '9845' ,`TaxRate` = '2.0869' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651961' WHERE `Matrix_Unique_ID` = '213871335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:02:01.050' ,`MLSNumber` = '71741670' ,`ListAgentFullName` = 'Michael Evans' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.650986' ,`Longitude` = '-95.490922' ,`PhotoCount` = '30' ,`PostalCode` = '77035' ,`RoomCount` = '13' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Cerritos' ,`StreetNumber` = '5831' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located 2 story home on a large corner lot in the very well established Westbury subdivision. You will immediately fall in love with this property sitting amongst mature trees, fully sodded lawn and a large fully fenced backyard. Home has 3 bedrooms (all up), 2 full baths upstairs, 1/2 bath downstairs and a 2 car detached garage. Recently the home has been updated to include energy efficient windows, laminate and carpet flooring, stainless steel appliances, new cabinets, quartz countertops, tile backsplash. NEVER FLOODED' ,`Acres` = '0.2282' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 75 WESTBURY SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9941' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 03' ,`TaxAmount` = '6001' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651961' WHERE `Matrix_Unique_ID` = '213883241' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:14:06.100' ,`MLSNumber` = '32036094' ,`ListAgentFullName` = 'Amy Yoder' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932724' ,`Longitude` = '-95.615695' ,`PhotoCount` = '35' ,`PostalCode` = '77065' ,`RoomCount` = '10' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood Blossom' ,`StreetNumber` = '13023' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3397' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Wortham Estates two story brick home. This Home features grand two story entry, formal living, dining, light filled family room with gas fireplace, open concept to kitchen and breakfast area. 1st floor Primary bedroom has high ceilings, crown molding and large windows. Upstairs are 3 additional bedrooms, 2 bathrooms, large game room and office with built in cabinetry.' ,`Acres` = '0.1848' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 4 WORTHAM ESTATES SEC 2 2ND AMND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wortham Estates' ,`TaxAmount` = '7259' ,`TaxRate` = '2.341' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651961' WHERE `Matrix_Unique_ID` = '213918586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:23:17.950' ,`MLSNumber` = '72983150' ,`ListAgentFullName` = 'Lisa Finley' ,`ListOfficeName` = 'Word Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.572375' ,`Longitude` = '-95.396431' ,`PhotoCount` = '50' ,`PostalCode` = '77584' ,`RoomCount` = '12' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Gladewater' ,`StreetNumber` = '11405' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Beautiful Shadow Creek Ranch Home offers a Spacious Open Floor Plan, perfect for entertaining. Family Room with Fireplace, High Ceilings, Large Bay Windows, with pool view and opens to the Luxurious Kitchen. Granite Countertops, 48” Glass Front Cabinets, New Dishwasher (2022), Wolf Brand Cooktop, New Roof (2018), AC Maintenance (2019) Great, Formal Dining Room with a Butler\'s Pantry, and much more! Gameroom includes mounted television with stereo system for surround sound in home. The Primary Bedroom features a Sitting Area with a Luxury Bath, that includes Jet Tub with large separate Shower. Huge walk-in with Closet with Double Rods. Secondary bedroom has a private bathroom. Upstairs home office or study great for kids. Entertain your guest at the Poolside, and enjoy the Lake Feature, and Outdoor Gas Grill with NO BACK NEIGHBORS!!!! This Beautiful 2-Story All Brick Home has so much more to offer and is in excellent condition!!! Convenient access to Medical Center, and Beltway 8.' ,`Acres` = '0.218' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-8A (PEARLAND) BLK 3 LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MAREK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'NOLAN RYAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf-8a Pear' ,`TaxAmount` = '13118' ,`TaxRate` = '2.9209' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651962' WHERE `Matrix_Unique_ID` = '213923152' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:27:33.360' ,`MLSNumber` = '45729670' ,`ListAgentFullName` = 'Alex Berry' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.791700' ,`Longitude` = '-95.403238' ,`PhotoCount` = '44' ,`PostalCode` = '77008' ,`RoomCount` = '16' ,`ListPrice` = '2050000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashland' ,`StreetNumber` = '1130' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An exceptional home for the most discerning buyer, with a prime Heights location on an oversized lot. This home exudes style and checks all the boxes. An extraordinary 23 ft entryway sets the tone as you enter. High ceilings and generous room sizes throughout. Impressive eat-in kitchen with massive island, built-in breakfast table seating, Thermador appliances, Sonic ice maker, custom wine closet and more. Primary bedroom downstairs has dual closets with an exclusive-use washer and dryer. Upstairs features a second primary bedroom with en suite bath; two additional bedrooms; gameroom with an oversized balcony and massive storage closet; media room; and utility room. Enjoy the outdoors on one of the many covered porches, and bask in the knowledge that you CAN have it all: a pool and yard, complete with fire pit, Travertine decking and playhouse. Plenty of off-street parking in the circle driveway. Non-contributing in the Houston Heights West Historic District. *all info per Seller' ,`Acres` = '0.197' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 29 & 30 BLK 205 HOUSTON HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '36620' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651962' WHERE `Matrix_Unique_ID` = '213942109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:32:10.177' ,`MLSNumber` = '71631719' ,`ListAgentFullName` = 'Karen Sumner' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.890272' ,`Longitude` = '-95.553986' ,`PhotoCount` = '50' ,`PostalCode` = '77040' ,`RoomCount` = '4' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashburton' ,`StreetNumber` = '15422' ,`StreetSuffix` = 'Drive' ,`City` = 'Jersey Village' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5037' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Regal Custom 4 Bedroom Home on an oversized corner lot. Incredible floorplan with spacious rooms and high ceilings. Main living area with a Kitchen featuring Solid Oak cabinetry, overlooking the wonderful family room with gorgeous gas fireplace. Wet bar overlooks the front living area making for a desirable open plan space. Master suite is downstairs. 3 bedrooms up. Second staircase leads to the gameroom. The moulding throughout the home is solid oak. This home was built from the ground up with consideration to safety and solid structure. Home has an Engineered foundation with over 80 Engineer supervised piers. Including under the back porch and gated Port Cochlear. Hurricane strapping from baseplate to ceilings.Back up electrical outlets for generator for power loss. Fire proof 3/4 plywood under furnaces. Extra large water line into home for better water pressure and a Separate water line for irrigation system . Work shop in garage with garage door to back yard. EXTRA PARKING!!' ,`Acres` = '0.4318' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'W 91.93 FT OF LT 25 BLK 55 JERSEY VILLAGE' ,`LotDesciption` = 'Corner' ,`LotSize` = '18810' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jersey Village' ,`TaxAmount` = '14185' ,`TaxRate` = '2.7758' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651962' WHERE `Matrix_Unique_ID` = '213975190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:33:41.933' ,`MLSNumber` = '9610694' ,`ListAgentFullName` = 'Veronica Lozada' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.867811' ,`Longitude` = '-95.789618' ,`PhotoCount` = '41' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Arcola Glen' ,`StreetNumber` = '23922' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2837' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 1-story custom waterfront home in the only gated section of Elyson. Inside, discover an impressive rotunda entry, wood & tile floors, raised ceilings, elegant lighting & fans, dazzling natural light w/spectacular lake views & so much more. Dining room opens to an immaculate island kitchen w/Quartz countertops, marble backsplash, premium SS appliances & a huge walk-in pantry. Welcoming family room w/wood beams & new speakers in a raised ceiling, a gorgeous gas-log fireplace & a wall of glass overlooking the covered patio, fenced yard & lake behind the home. Posh owner’s suite offers a raised ceiling, lake views, walk-in closets (connect to laundry room w/tons of built-ins) & a gorgeous ensuite bath. Wrap yourself in luxury in this spa-like ensuite w/an oversized walk-in shower, soaking tub & dual vanities. Guest bedrooms are also spacious w/large closets & easy access to a full bath. Media room w/pre-wired sound. Covered patio w/ceiling fan overlooks the lake. Sprinkler system.' ,`Acres` = '0.1902' ,`Area` = '25' ,`BuilderName` = 'Drees Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 1 ELYSON SEC 16' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8287' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '13114' ,`TaxRate` = '3.5368' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651962' WHERE `Matrix_Unique_ID` = '213997513' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:44:38.830' ,`MLSNumber` = '25195999' ,`ListAgentFullName` = 'Jackie Greer' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.302033' ,`Longitude` = '-94.903378' ,`PhotoCount` = '46' ,`PostalCode` = '77554' ,`RoomCount` = '9' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'Tiki' ,`StreetNumber` = '323' ,`StreetSuffix` = 'Drive' ,`City` = 'Tiki Island' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '2' ,`SqFtTotal` = '2890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous one of a kind property in Tiki. Kitchen completely updated with an open concept & huge island. The primary suite is totally remodeled, owners took 2 bedrooms & made 1 large bedroom with 2 separate baths; one updated to include a freestanding soaker tub & lots of extras. Through the large walk-in closet that contains washer/dryer connections is the other bath with a large walk-in shower. Extra bedroom & bath on 1st floor has a Murphy bed. Upstairs are 2 rooms with a full bath that could be used as bedrooms/office/bunk room. Entertaining area & a restaurant-style wet bar on the main floor. This is a party waiting to happen. This uniquely beautiful property has a pool & oversized spa. The backyard also has a double boat slip & both open & covered spaces downstairs & up. A breakwater wall is being built & dredging approved to make for easy access in & out of canal. Can be sold commercial with restrictions. You will not find another home like this in Tiki Island, a must see!!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOTS 59 THRU 63 TIKI ISLAND SEC 15A' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '13112' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Freestanding Range,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,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Tiki Island 15a Th' ,`TaxAmount` = '11451' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651963' WHERE `Matrix_Unique_ID` = '214213679' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:18:03.743' ,`MLSNumber` = '8416091' ,`ListAgentFullName` = 'Jennifer Bean' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827998' ,`Longitude` = '-95.427185' ,`PhotoCount` = '25' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '559500.00' ,`Status` = 'Active' ,`StreetName` = 'Gardenia' ,`StreetNumber` = '1070' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Opportunity to own in Garden Oaks. This home is 3 bedroom and 2 full bathrooms on a 7,134 sq foot lot. There is a large 2 car garage, extended driveway, porte-cochere and driveway gate. This home has hardwood floors and tile. Kitchen is equipped with stainless steel appliances. The kitchen opens to the dining room and cozy den. Spacious primary bedroom and secondary bedrooms. Great backyard for grilling and entertaining.' ,`Acres` = '0.168' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Garden Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 53 GARDEN OAKS SEC 5' ,`LotDesciption` = 'Other' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Garden Oaks Sec 05' ,`TaxAmount` = '11128' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1947' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651963' WHERE `Matrix_Unique_ID` = '214220564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:39:20.927' ,`MLSNumber` = '31519033' ,`ListAgentFullName` = 'Teresa Sartin' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = 'Clayton Daugherty' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '29.767602' ,`Longitude` = '-95.758042' ,`PhotoCount` = '39' ,`PostalCode` = '77450' ,`RoomCount` = '6' ,`ListPrice` = '270000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hidden Canyon' ,`StreetNumber` = '914' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1711' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom, 1 story home in Cimmaron! This home features a gorgeous ATRIUM with an outlet AND gas connection! The Primary suite includes an oversized shower as well as his and hers WALK IN CLOSETS. Both additional bedrooms also include walk in closets. Living room homes vaulted ceilings as well as a wood burning fireplace. With a fully fenced in backyard this is a perfect family home!!' ,`Acres` = '0.2576' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 5 CIMARRON SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '11220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '462' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Sec 02' ,`TaxAmount` = '4059' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651963' WHERE `Matrix_Unique_ID` = '214329987' --> 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','214330899','1669651963','214330899','2022-11-27T12:57:41.803','2268880','Shannon DeGroat','New Home Star Texas, LLC','','','29.427195','-95.451773','3','77583','11','395990.00','Active','Amador Peak','10623','Drive','Rosharon','2','1','3','2101','Single-Family','The Edward-a one of a kind floor plan you must see. As you walk through the front door, a study sits off to the right. The extended foyer leads you past two bedrooms, the laundry room, and not just one, but two bathrooms. A set of stairs off of the garage takes you up to the additional bonus room, unfinished to add your own special touch. The kitchen overlooks the family room and offers plenty of countertop and cabinet space. The café is connected to the kitchen and offers direct access outside to the covered patio. Directly off of the family room is the owners suite with a double sink vanity, a soaking tub and separate shower with a big walk-in closet.','','5','Davidson Homes','','Electric Dryer Connections,Washer Connections','','Mi/Lenders Approval,Mud','1','','0','Alvin North','Central Gas','1','SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 1 LOT 6','Subdivision Lot','7500','Survey','','1295','1','Never Lived In','2','','0','','','Gas Cooktop','','Other','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Appointment Required','Seller','1','Traditional','Sierra Vista West','','3.6007','Other Water/Sewer','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','214332999','1669651963','214332999','2022-11-27T12:57:29.197','10617363','Shannon DeGroat','New Home Star Texas, LLC','','','29.376190','-95.456813','3','77583','11','439990.00','Active','Plumas Run','10530','Drive','Rosharon','3','0','4','2623','Single-Family','Hello George! From the long entry way leading to the front door, to the extended foyer leading into the family room and kitchen area, this one-story home has it all. The first two bedrooms are located at the front of the home that are split by a full sized bathroom. Further down, off the foyer, is the laundry room, access to the 3-car garage and the third bedroom that has its own bathroom. Work from home with no interruptions in the study or turn that space into a formal dinning room. The kitchen is open to the family room and the café area with a door leading out to the covered back patio. The owners suite includes a double sink vanity, a separate shower and soaking tub with a huge walk-in closet.','','5','Davidson Homes','','','','Mi/Lenders Approval,Mud','1','','','Alvin North','Central Gas','1','SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 3 LOT 5','Subdivision Lot','7500','Survey','','1295','1','Never Lived In','3','','0','','','Gas Cooktop','','Other','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Appointment Required','Seller','1','Traditional','Sierra Vista West','','3.6','Other Water/Sewer','2022','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214336109','1669651963','214336109','2022-11-27T12:57:14.627','57013567','Shannon DeGroat','New Home Star Texas, LLC','','','29.432837','-95.445460','3','77583','11','449990.00','Active','Homewood Point','1818','Lane','Rosharon','3','0','4','2623','Single-Family','Hello George! From the long entry way leading to the front door, to the extended foyer leading into the family room and kitchen area, this one-story home has it all. The first two bedrooms are located at the front of the home that are split by a full sized bathroom. Further down, off the foyer, is the laundry room, access to the 3-car garage and the third bedroom that has its own bathroom. Work from home with no interruptions in the study or turn that space into a formal dinning room. The kitchen is open to the family room and the café area with a door leading out to the covered back patio. The owners suite includes a double sink vanity, a separate shower and soaking tub with a huge walk-in closet.','','5','Davidson Homes','','Electric Dryer Connections,Washer Connections','','Mi/Lenders Approval,Mud','1','','','Alvin North','Central Gas','1','SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 4 LOT 11','Subdivision Lot','9307','Survey','','1295','1','Never Lived In','3','','0','','','Gas Cooktop','','Other','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Appointment Required','Seller','1','Traditional','Sierra Vista West','','3.6007','Other Water/Sewer','2022','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214336537','1669651963','214336537','2022-11-27T12:56:59.073','21891510','Shannon DeGroat','New Home Star Texas, LLC','','','29.376190','-95.456813','4','77583','12','499990.00','Active','Homewood Point','1806','Lane','Rosharon','3','1','4','2796','Single-Family','Welcome to the Philip, a charming two-story home. Work from home? No problem, a study is located on the main level, tucked away from the rest of the home to get work done in peace and quiet. Stainless steel appliances, 42\" upper cabinets, a gas range and a huge walk-in pantry are all included in the kitchen. Large windows line the family room and café area to let in an ample amount of sunshine. The laundry room and owners suite are conveniently located on the main level as well. Up to the second floor, you will find an enormous game room, two additional bedrooms that share a full sized bathroom and an en suite with a walk-in closet.','','5','Davidson Homes','','Electric Dryer Connections,Washer Connections','','Mi/Lenders Approval,Mud','1','','','Alvin North','Central Gas','1','SIERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 4 LOT 8','Subdivision Lot','8011','Survey','','1295','1','Never Lived In','2','','0','','','Gas Cooktop','','Other','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Sierra Vista West','','3.6007','Other Water/Sewer','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:56:41.120' ,`MLSNumber` = '4823205' ,`ListAgentFullName` = 'Shannon DeGroat' ,`ListOfficeName` = 'New Home Star Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.427331' ,`Longitude` = '-95.451196' ,`PhotoCount` = '4' ,`PostalCode` = '77583' ,`RoomCount` = '13' ,`ListPrice` = '495990.00' ,`Status` = 'Active' ,`StreetName` = 'Amador Peak' ,`StreetNumber` = '10618' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2796' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the Philip, a charming two-story home. Work from home? No problem, a study is located on the main level, tucked away from the rest of the home to get work done in peace and quiet. Stainless steel appliances, 42\" upper cabinets, a gas range and a huge walk-in pantry are all included in the kitchen. Large windows line the family room and café area to let in an ample amount of sunshine. The laundry room and owners suite are conveniently located on the main level as well. Up to the second floor, you will find an enormous game room, two additional bedrooms that share a full sized bathroom and an en suite with a walk-in closet' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Davidson Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mi/Lenders Approval,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IERRA VISTA WEST SEC 7 (A0329 LAV NAV CO) BLK 2 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651964' WHERE `Matrix_Unique_ID` = '214337428' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:50:07.480' ,`MLSNumber` = '61686125' ,`ListAgentFullName` = 'Julie Upton' ,`ListOfficeName` = 'Pearwood Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.301870' ,`Longitude` = '-94.907538' ,`PhotoCount` = '37' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Admiral' ,`StreetNumber` = '341' ,`StreetSuffix` = 'Circle' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated waterfront property has so much to offer...walk into an open concept floorplan with a large family room with high ceilings & a fireplace, kitchen with large island & granite countertops, breakfast room overlooking the bay; 2 bedrooms downstairs & a full bath; 2 bedrooms upstairs, both feature balconies. The primary bedroom has an en suite bath complete with a garden tub, separate shower, his & hers closets & dual sinks. A second upstairs bedrooms also has an en suite bath. Outdoors you will find a bar with roll up window downstairs adjacent to a storage room, boat house with boat lift, fenced side yard perfect for pets or a pool, spacious area under the home for entertaining as well a spacious upper deck. This home has been well maintained & shows like a model home. Other features include luxury vinyl flooring throughout, plantation shutters, double pane windows, cargo lift & more! The location is convenient to the open bay which also offers magnificent views.' ,`Acres` = '0.104' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 LOT 28 BLK 1 TIKI YACHT CLUB COLONY' ,`LotDesciption` = 'Cul-De-Sac,Waterfront' ,`LotSize` = '4530' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Yacht Club Colony' ,`TaxAmount` = '10513' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651964' WHERE `Matrix_Unique_ID` = '214388548' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:09:25.310' ,`MLSNumber` = '50795379' ,`ListAgentFullName` = 'Amanda Smith' ,`ListOfficeName` = 'Boulevard Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.621076' ,`Longitude` = '-95.591848' ,`PhotoCount` = '40' ,`PostalCode` = '77478' ,`RoomCount` = '7' ,`ListPrice` = '483000.00' ,`Status` = 'Active' ,`StreetName` = 'Montclair' ,`StreetNumber` = '611' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two-story, 4 bed, 3 1/2 bath home is loaded with potential. Impressive high cathedral ceilings bring a sense of grandeur to this spacious family room with built-in cabinetry on one side and a wood burning/gas fireplace adorning the other. Salt water resort-style pool with screened in enclosure, making it perfect for entertaining guests. Additional room on first floor can be used as mother-in-law’s suite or game room -- this square footage not included in the total sf of the house. Primary suite is located on the first floor featuring plenty of space and an en suite bath with separate shower and whirlpool tub. Additional features of this home include four bedrooms and four baths in all, ample closet / storage space, and two-car, attached garage and oversized driveway. Don\'t miss out on this wonderful opportunity - call today for a showing! Room dimensions are approximate, must be verified.' ,`Acres` = '0.2383' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 6, BLOCK 1, LOT 44' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '415' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Split Level' ,`Subdivision` = 'Sugar Creek Sec 6' ,`TaxAmount` = '8477' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651964' WHERE `Matrix_Unique_ID` = '214421873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:10:51.183' ,`MLSNumber` = '98179878' ,`ListAgentFullName` = 'Judy Doggett' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.498636' ,`Longitude` = '-95.074042' ,`PhotoCount` = '20' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Tuscan Village' ,`StreetNumber` = '1536' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1948' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely home situated within this \"Over 55\" communty in the master planned community of Tuscan Lakes with many activities should you want to participate. This home is located just at the end of Tuscan Village Drive so there is very little traffic. Neutral colors throughout with extended wood entry/family room/kitchen.\r\nFunctional island kitchen gives the cook additional storage and work space. Primary bedroom is generous size, bathroom has dual sinks and walk in shower. Study with French doors opens into the entry. Backyard has built-in outdoor grill and nice extended sitting area. Neighborhood maintains and mows the front yard, and backyard has plenty of space to have a garden, or extended patio. The village amenities include large clubhouse, amazing pool area and social activities. Don\'t miss this opportunity to live here. Esy access to I45 between Houston and Galveston.' ,`Acres` = '0.1288' ,`Area` = '33' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAGE AT TUSCAN LAKES SEC 4 PH 2 (2015) ABST 19, BLOCK 1,' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SILBERNAGEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Village At Tuscan Lakes Sec 4' ,`TaxAmount` = '10467' ,`TaxRate` = '3.2297' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651964' WHERE `Matrix_Unique_ID` = '214507603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:14:34.320' ,`MLSNumber` = '90750486' ,`ListAgentFullName` = 'Melissa Whitehead' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.092077' ,`Longitude` = '-95.266556' ,`PhotoCount` = '42' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Sundance Spring' ,`StreetNumber` = '24490' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Oh my goodness! Diamond in plain sight and priced to sell! Tucked away in a beautiful golf course community, walking trails and parks, this one owner home is impeccably maintained. So many updates; granite countertops and backsplash, newer flooring throughout (luxury vinyl planks, tile, carpet) the home, tile surround on fireplace, under cabinet lighting, additional cabinets added in half and master bath, climate controlled \"Texas Attic Space\" for ample storage, added energy saving features which include a solar attic ventilation fan and spray foam insulation, NEWER HVAC 2019 with transferable warranty. A home made for gatherings with an open concept kitchen/living area, loft style game room upstairs, formal dining area (can also be used as an office/study space) and a spacious backyard with no back neighbors. The yard is beautifully landscaped throughout and easily maintained with a full wifi controlled sprinkler system. A DEFINITE MUST SEE! Call today to schedule your showing!' ,`Acres` = '0.135' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S835100 - RIVERWOOD AT OAKHURST 01, BLOCK 1, LOT 20' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '5881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding 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,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oakhurst' ,`TaxAmount` = '6784' ,`TaxRate` = '3.0681' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651964' WHERE `Matrix_Unique_ID` = '214542161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:17:56.443' ,`MLSNumber` = '4342665' ,`ListAgentFullName` = 'Shannoan Parker' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.161910' ,`Longitude` = '-95.585298' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '477790.00' ,`Status` = 'Active' ,`StreetName` = 'Dripping Ledge' ,`StreetNumber` = '27208' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2-story home, The Ellington Floor plan with 4 bedrooms and 2 1/2 baths. The interior offers a high ceiling profile on both floors with an open floor plan. This home is featured with: Smart features controlling the two-car garage, 1st and 2nd-floor temperature, smart door lock, and the GE stainless oven. Cat 6 cable was installed in 4 areas with two spares on 2nd the floor. Kitchen stainless package with granite tops, trash drawer, grand island with seating for 6 comfortably, 5 piece GE stainless kitchen package, BENCH WINDOW, and walk-in pantry. Bathrooms with engineered stone tops, master bath includes rock shower floor and SOAKING TUB. The half bath has a glass bowl sink and linen closet. The home has Pre-wiring for the alarm. WiFI booster is installed. The home is pre-piped for whole-house water filtration. 2 car garage with a landing. Tankless water heater. The covered outdoor patio includes recessed lighting, a ceiling fan box, an electrical outlet, and one gas' ,`Acres` = '0.1943' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S740213 - NORTHGROVE 13, BLOCK 1, LOT 18' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '8463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Northgrove 13' ,`TaxAmount` = '3000' ,`TaxRate` = '3.2087' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651965' WHERE `Matrix_Unique_ID` = '214545375' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:13:15.997' ,`MLSNumber` = '49615165' ,`ListAgentFullName` = 'Gary Reifel' ,`ListOfficeName` = 'Professional Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.027465' ,`Longitude` = '-95.598972' ,`PhotoCount` = '26' ,`PostalCode` = '77422' ,`RoomCount` = '4' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 651' ,`StreetNumber` = '3711' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DIAMOND IN THE ROUGH---This 4-bedroom 2 full bath country home sits on one acre and on the corner. 2 car garage detached, storage building and plenty of elbow room. On the interior, the house needs some finishing touches and there is no central a/c or heat, however, all ducts and vents are in place in the attic and ready for hook up. Bathrooms are beautiful as well as rooms are large, indoor utility and basically a well-built home. Formal dining room and large family room. This brick home is on a slab and then raised on block and beam and well done.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8A3A SM WILLIAMS (NE/2) ACRES 1.00' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'SM Williams' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651965' WHERE `Matrix_Unique_ID` = '214558908' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:07:33.180' ,`MLSNumber` = '96492789' ,`ListAgentFullName` = 'Jude Mustafa' ,`ListOfficeName` = 'SKW Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.761230' ,`Longitude` = '-95.887952' ,`PhotoCount` = '45' ,`PostalCode` = '77423' ,`RoomCount` = '8' ,`ListPrice` = '584990.00' ,`Status` = 'Active' ,`StreetName` = 'Aralia' ,`StreetNumber` = '30015' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2865' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16, Block 3 Jordan Ranch Section 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6045' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651965' WHERE `Matrix_Unique_ID` = '214566939' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:48:51.743' ,`MLSNumber` = '18284978' ,`ListAgentFullName` = 'Robert Byas' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.713917' ,`Longitude` = '-95.356265' ,`PhotoCount` = '18' ,`PostalCode` = '77004' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Grantwood' ,`StreetNumber` = '5110' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2689' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location. Very private street with only a few homes. Convenient to medical center, down town, sport arenas. 4 bedrooms. 2.5 bathrooms. Private lot. Investors - perfect for your next project. Older home could use a nice complete updating (BnB) or other residential or commercial business.' ,`Acres` = '0.2121' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 31A ABST 75 H TIERWESTER' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tierwester' ,`TaxAmount` = '4201' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651965' WHERE `Matrix_Unique_ID` = '214571398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:07:33.180' ,`MLSNumber` = '2580142' ,`ListAgentFullName` = 'Angela Moore' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781522' ,`Longitude` = '-95.290251' ,`PhotoCount` = '49' ,`PostalCode` = '77020' ,`RoomCount` = '10' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Exchange' ,`StreetNumber` = '414' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1830' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulously UPDATED home in great east side neighborhood, easy commute to downtown and all attractions. Primary bedroom and ensuite bathroom upstairs for quiet oasis. Two large bedrooms down with updated full bathroom. Spacious kitchen opens on to open living/dining space. Newly added covered deck with limitless entertainment possibilities. 2020 ROOF, upgraded AC SYSTEM, upgraded double pane windows plus new gutter system. Built security cameras, ring doorbell and large screen control panel remain with the property. Extra secure gate and exterior door locks. Ceiling fans with dimmers throughout. Lovely established garden, new fully fenced back yard. French drains added for drainage protection.' ,`Acres` = '0.1253' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 50 BLK 2 DENVER HARBOR SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCROGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Harbor Sec 02' ,`TaxAmount` = '2795' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651966' WHERE `Matrix_Unique_ID` = '214665118' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:04:15.487' ,`MLSNumber` = '80486683' ,`ListAgentFullName` = 'Zhaoqi Li' ,`ListOfficeName` = 'Agent Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.942993' ,`Longitude` = '-95.174429' ,`PhotoCount` = '38' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '585000.00' ,`Status` = 'Active' ,`StreetName` = 'Easton Gate' ,`StreetNumber` = '15406' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4973' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wow, this stunning 6 bedroom 6.5 bathroom house offers 4973 sqft of living. Located in a gated community, in the beautiful neighborhood of Lakewood Pines. It features open floor plan. Big windows let in plenty of natural light. Common area of first floor has luxury hardwood floor. Kitchen boast beautiful white cabinetry, granite countertops, and stainless steel appliances. On the first floor, you will find spacious living area, and a formal dinning area. Large backyard with cover patio, great for entertaining. The primary suite is very spacious, there is enough space for adding a reading area by the huge windows. The primary bathroom offers dual sinks, separate shower and tub. Did I mention this home has 5 additional bedrooms, and total of 6.5 bathrooms, call to schedule your showings, and make this your dream home!' ,`Acres` = '0.2078' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 LAKEWOOD PINES SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9053' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Pines' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651966' WHERE `Matrix_Unique_ID` = '214702791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:44:47.160' ,`MLSNumber` = '58141037' ,`ListAgentFullName` = 'Michael Sifuentes' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817324' ,`Longitude` = '-95.395643' ,`PhotoCount` = '44' ,`PostalCode` = '77018' ,`RoomCount` = '5' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = '34th' ,`StreetNumber` = '305' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This new construction features a luxury & contemporary look & feel from the exterior to the interior. You will love the modern style layout and floorplan. There is plenty of natural light with high ceilings. Open concept is great for entertaining. Each room has its own personal ensuite! These luxury homes will include a mud room, elegant electric fireplace, tankless water heater, 16ft walk in kitchen pantry, Samsung Appliances - Touch screen Family Hub Refrigerator with Wi-Fi connectivity, stair lighting & a French drain system . This home also comes with a good size backyard for your loved pets. Every detail was carefully thought of by our award winning designer. Come make your appointment today. Next-door at 307 E 34th st. & and this home at 305 mirror each other except for a few different items selected. The kitchen, primary bath & powder rooms change up these beautiful homes.' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = 'Canopy Home Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 26 & 27 BLK 21 INDEPENDENCE HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Independence Heights' ,`TaxAmount` = '23307' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651966' WHERE `Matrix_Unique_ID` = '214724149' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:44:24.523' ,`MLSNumber` = '15989781' ,`ListAgentFullName` = 'Michael Sifuentes' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.817355' ,`Longitude` = '-95.395866' ,`PhotoCount` = '38' ,`PostalCode` = '77018' ,`RoomCount` = '5' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = '34th' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This new construction features a luxury & contemporary look & feel from the exterior to the interior. You will love the modern style layout and floorplan. There is plenty of natural light with high ceilings. Open concept is great for entertaining. Each room has its own personal ensuite! These luxury homes will include a mud room, tankless water heater, 16ft walk in kitchen pantry, Samsung Appliances - Touch screen Family Hub Refrigerator with Wi-Fi connectivity, stair lighting & a French drain system . This home also comes with a good size backyard for your loved pets. Every detail was carefully thought of by our award winning designer. Come make your appointment today. Next-door at 305 E 34th St. & and this home at 307 mirror each other except for a few different items selected. The kitchen, primary bath & powder rooms change up these beautiful homes.' ,`Acres` = '0.0689' ,`Area` = '9' ,`BuilderName` = 'Canopy Home Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 26 & 27 BLK 21 INDEPENDENCE HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Independence Heights' ,`TaxAmount` = '23307' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651966' WHERE `Matrix_Unique_ID` = '214724569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:05:29.477' ,`MLSNumber` = '73744498' ,`ListAgentFullName` = 'JD Adamson' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797741' ,`Longitude` = '-95.380092' ,`PhotoCount` = '19' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Patton' ,`StreetNumber` = '1313' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1775' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller! Gated community overlooking a quiet park in Heights/Greater Heights. Convenient access to 610 and I-45 and nearby local favorite hot spots and eateries. This 3 bed/ 2.5 bath open floorplan residence features first-floor living areas and shows like new construction! A functional, sure-to-impress kitchen features granite countertops, a new gas range, walk-in pantry, and a custom copper sink. Hardwood flooring and solid-panel wainscotting in the dining, high ceilings, and crown moldings throughout. Perfectly-sized outdoor patio space with historic brick paver flooring. All bedrooms and a full-size laundry room with a built-in ironing board upstairs. Fantastic primary suite with en suite boasts dual vanities, two closets, a jetted tub, and a front balcony with lovely views and a hidden laundry passage. Tankless water heater, wooden plantation shutters, and more! NOT in a flood zone. The lock-and-leave home is meticulously maintained and is ready for immediate move-in!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 OLMSTEAD PARK' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '3839' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Craftsman,Traditional' ,`Subdivision` = 'OLMSTEAD PARK' ,`TaxAmount` = '9323' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651967' WHERE `Matrix_Unique_ID` = '214737526' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:07:41.087' ,`MLSNumber` = '54947890' ,`ListAgentFullName` = 'Chelsea Boone' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835871' ,`Longitude` = '-95.414993' ,`PhotoCount` = '6' ,`PostalCode` = '77018' ,`RoomCount` = '3' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak' ,`StreetNumber` = '910 1/2' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS and BUILDERS! The DEAL you\'ve been searching for has arrived! This location is unmatched and a great place to start your next custom build! Close to The Heights, Shephard Park, Resturants, and Nightlife. With quick and easy access to 610! This is a great investment on a BIG lot. There is a two-story brick 3 bedroom 2 bathroom house, covered carport and metal shed on the property. It is livable and this property was recently cash flowing as a rental property. Don\'t let this oppurnity slip by for you to come build multiple single family homes or townhomes. Schedule your private tour today!' ,`Acres` = '0.4337' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Shepherd Park Plaza Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 DESAI' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18893' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DURHAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Desai Add' ,`TaxAmount` = '9775' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651967' WHERE `Matrix_Unique_ID` = '214793539' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:55:50.123' ,`MLSNumber` = '88273214' ,`ListAgentFullName` = 'Judith Lopez' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.843789' ,`Longitude` = '-95.770268' ,`PhotoCount` = '23' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Tuscany Ridge' ,`StreetNumber` = '22714' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL ONE STORY THREE BEDROOM HOME IN HIGHLY SOUGHT AFTER VENTANA LAKES. THIS HOME FEATURES AN OPEN CONCEPT LIVING AND DINING ROOM AREA. AN ISLAND KITCHEN WITH STUNNING GRANITE COUNTER-TOPS. REFRIGERATOR, DRYER, WASHER AND WATER SOFTNER TREATMENT INCLUDED. LARGE PRIVATE PRIMARY BEDROOM WITH EN-SUITE BATH , A GARDEN TUB SEPARATE SHOWER, DUAL SINKS AND LARGE WALK-IN CLOSET. TWO BEDROOMS WITH A FULL BATH. THE HOME OFFERS SMART HOME TECHNOLOGY, TANKLESS WATER HEATER, AND FRONT AND BACK WATER SPRINKLER SYSTEM AND ALSO INCLUDED IS A BEAUTIFUL EXTENDED PATIO . VENTANA LAKES COMMUNITY FEATURE POOLS, PARK SPLASH PAD, AND WALKING PATHS THROUGHOUT THE COMMUNITY. KISD SCHOOLS AND AN EASY ACCESS TO TX 99, BELTWAY AND I-10. PLENTY OF RESTAURANTS , SHOPPING CENTERS AND ENTERTAINMENT . SCHEDULE YOUR APPOINTMENT TODAY!' ,`Acres` = '0.1492' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 VENTANA LAKES EAST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'VENTANA LAKES' ,`TaxAmount` = '6705' ,`TaxRate` = '3.2357' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651967' WHERE `Matrix_Unique_ID` = '214819945' --> 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','214823957','1669651967','214823957','2022-11-27T11:56:31.820','36614439','Christina Williams','Keller Williams Elite','Christina Williams','Keller Williams Elite','29.811223','-95.048348','17','77562','1','65000.00','Option Pending','Battlebell','610','Road','Highlands','1','0','1','432','Single-Family','Looking for something to call your own? Maybe a new investment property? This cozy one bedroom home is ready for a new owner. Located in Highlands it is in a great location with a short drive to Houston and walking distance to stores and restaurants.','0.124','2','','','','','Sellers Disclosure','','','','Baytown/Harris County','Window Unit','0','TR 3G-2 BLK 16 ELENA FRUIT & COTTON FARMS C','Other','5401','Appraisal District','','','0','','0','','0','','','','','Composition','23 - Goose Creek Consolidated','HOPPER/HIGHLANDS ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Other Style','Elena Fruit and Cotton Farms C','234','2.575','Public Sewer,Public Water','1974','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:07:51.587' ,`MLSNumber` = '96232626' ,`ListAgentFullName` = 'Erica Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.967610' ,`Longitude` = '-95.506035' ,`PhotoCount` = '45' ,`PostalCode` = '75862' ,`RoomCount` = '6' ,`ListPrice` = '224000.00' ,`Status` = 'Active' ,`StreetName` = 'Westlake' ,`StreetNumber` = '55' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lake Livingston\'s prestigious gated waterfront community, Westlake Shores. An exquisite modern elevation w/ modern finishes that is right on the golf course. You are welcomed w/ a luxurious ground staircase at ground level leading up to the main level & for convenience there are two separate stairways leading up to an enclosed porch on the backside of the house w/ spectacular views of the golf course that will WOW guests. The sleek sliding doors open up to the spacious great room, perfect for entertaining & family gatherings. An impressive gourmet kitchen adorned w/ beautiful crafted cabinetry, & an oversized island. Two primary bedrooms offer substantial space & the notable primary bath w/ double sinks & vanity area. A community that checks all the boxes, features a beautiful 18-hole golf course, 9 interior lakes for fishing, Country Club w/ pro shop, Bar & Grill, putting greens, wildlife, tennis & pickle ball courts, RV park, marina village resort, boat storage, & stunning sunsets.' ,`Acres` = '0.1259' ,`Area` = '43' ,`BuilderName` = 'Raa Innovations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Walker County - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 09, BLOCK 20 LOT 28' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '5483' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2508' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westwood Shores Sec 9' ,`TaxAmount` = '111' ,`TaxRate` = '2.4708' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651967' WHERE `Matrix_Unique_ID` = '214837165' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:19:08.653' ,`MLSNumber` = '44362755' ,`ListAgentFullName` = 'Erica Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.931345' ,`Longitude` = '-95.334152' ,`PhotoCount` = '49' ,`PostalCode` = '75862' ,`RoomCount` = '9' ,`ListPrice` = '432000.00' ,`Status` = 'Active' ,`StreetName` = 'Candlestick' ,`StreetNumber` = '42' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2 story, 3 Bedroom, 3 Bath #LakeLife at its best w/ breathtaking views of the lake. Equipped w/ modern finishes & design, open floor plan, vinyl plank, lots of windows throughout the home bringing in natural light & the most spectacular views & sunsets. An impressive gourmet kitchen adorned w/ double oven, beautiful crafted cabinetry & oversized island w/ breakfast bar, area that flows into the dining area w/ floor to ceiling windows, & into the oversized Great Room that opens out to a beautiful extensive covered outdoor living deck area w/ double sided fireplace. All bedrooms offer substantial space & the Notable primary suite holds breathtaking views and provides a luxurious oversized shower and separate soaking tub. This prestigious gated community checks all the boxes, a beautiful 18-hole golf course, 9 interior lakes for fishing, Country Club w/ pro shop, Bar & Grill, putting greens, wildlife, tennis & pickle ball courts, RV park, marina village resort, & boat storage.' ,`Acres` = '0.1925' ,`Area` = '42' ,`BuilderName` = 'RAA Innovations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 04, BLOCK 70 LOT 13' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '8385' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2508' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westwood Shores Sec 4' ,`TaxAmount` = '68' ,`TaxRate` = '2.4708' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651968' WHERE `Matrix_Unique_ID` = '214840415' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:12:38.137' ,`MLSNumber` = '94451091' ,`ListAgentFullName` = 'Erica Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.967610' ,`Longitude` = '-95.506035' ,`PhotoCount` = '47' ,`PostalCode` = '75862' ,`RoomCount` = '10' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Westwood' ,`StreetNumber` = '88' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2369' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous retreat in incomparable Westwood Shores, a prestigious gated waterfront community on Lake Livingston. Welcome entry to this pristine floor plan, which exudes beauty & a sense of calm from the breathtaking views of the interior lake and golf course this home backs up to. Open plan w/ high ceilings & warm welcoming aesthetic. Ideal kitchen design that flows into the grand living area & a pleasantly oversized dining room both great space for entertaining but also a warm and functional setting for the family. 2 oversized bedroom suites offer guest & residents utmost comfort and privacy. 2 outdoor living areas, large windows to the wide covered patio w/ outdoor kitchen.This prestigious gated community checks all the boxes, a beautiful 18-hole golf course, 9 interior lakes for fishing, Country Club w/ pro shop, Bar & Grill, putting greens, wildlife, tennis & pickle ball courts, RV park, marina village resort, & boat storage.' ,`Acres` = '0.2225' ,`Area` = '43' ,`BuilderName` = 'Raa Innovations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Walker County - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 03, BLOCK 62 LOT 03' ,`LotDesciption` = 'Cleared,Greenbelt,In Golf Course Community,On Golf Course,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '9690' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2508' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westwood Shores Sec 3' ,`TaxAmount` = '115' ,`TaxRate` = '2.4708' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651968' WHERE `Matrix_Unique_ID` = '214841043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:21:16.057' ,`MLSNumber` = '37925027' ,`ListAgentFullName` = 'Erica Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.939362' ,`Longitude` = '-95.330687' ,`PhotoCount` = '50' ,`PostalCode` = '75862' ,`RoomCount` = '9' ,`ListPrice` = '364000.00' ,`Status` = 'Active' ,`StreetName` = 'Sawgrass' ,`StreetNumber` = '13' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2102' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A stunning fusion of modern architecture integrated w/ the natural beauty of a golf course & nature beyond. Majestically situated on a quiet cul-de-sac & golf course. High 2 Story Ceiling in the Living area Conveying an Open, Airy, Atmosphere. Elegant Accents are on trend in the Kitchen Comprised of an island kitchen, bar seating, quartz countertops, state of the art cabinetry, overlooking the living room, all with a breathtaking view of the golf course and nature beyond. The Large Primary Suite Includes floor-to-ceiling sliding glass doors that provide a seamless space combining the interior and the exterior to create multi-functional areas to relax, work, or entertain, and of course a Luxe Bathroom, double sinks, a generous size walk in closet. Feel worlds away in 1,200+ acre waterfront residential resort community on Lake Livingston w/ its peaceful lifestyle and lots centered around recreational lakes. Boat, fish, explore, & enjoy stunning wildlife on the water. Attention to detail!' ,`Acres` = '0.2277' ,`Area` = '42' ,`BuilderName` = 'Raa Innovations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 03, BLOCK 62 LOT 13' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '9920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2508' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westwood Shores Sec 3' ,`TaxAmount` = '106' ,`TaxRate` = '2.4708' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651968' WHERE `Matrix_Unique_ID` = '214841068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:05:37.120' ,`MLSNumber` = '29494530' ,`ListAgentFullName` = 'Erica Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.976826' ,`Longitude` = '-95.167385' ,`PhotoCount` = '3' ,`PostalCode` = '77340' ,`RoomCount` = '8' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Greentree' ,`StreetNumber` = '2136' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2701' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built to live effortlessly & elegantly in renowned Elkins Lake. This custom build SINGLE STORY, eludes an ambiance that is both soothing & dramatic. Impressive grand foyer double iron doors w/ high arched entry. Features 14 ft ceilings, vessel sinks, vinyl plank throughout, built-in wet bar, a formal study 3 bedroom, 3 full bath. A chef’s kitchen features an oversized island, a breakfast bar, 48 \" stove w/ 8 burners, double ovens, double wide refrigerator, & beautifully crafted cabinets. Tranquil primary suite provides luxurious shower w/ separate soaking tub & 2 closets. Enclosed lanai, w/ floor-to-ceiling glass pocket doors & outdoor kitchen provides a seamless space combining the interior & the exterior to create multi-functional areas to relax, work, or entertain. Amenities: 3 lakes, 2 swimming pools, 4 tennis & pickle ball courts, 2 quarter mile walking trails, outdoor exercise stations, playgrounds, ball fields, “Bark Park”, basketball area, picnic areas, cafe, & several parks.' ,`Acres` = '' ,`Area` = '42' ,`BuilderName` = 'Raa Innovations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Trinity Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'A0568 STEPHANES, CHARLES,TRACT 1 PT OF,164.6 ACRES' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9396' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '198' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Elkins Lake Sec 03' ,`TaxAmount` = '572' ,`TaxRate` = '1.5582' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651968' WHERE `Matrix_Unique_ID` = '214841073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:30:41.290' ,`MLSNumber` = '25577004' ,`ListAgentFullName` = 'Erica Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.930552' ,`Longitude` = '-95.336617' ,`PhotoCount` = '30' ,`PostalCode` = '75862' ,`RoomCount` = '9' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Lake' ,`StreetNumber` = '46' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'An elegant retreat in incomparable Westwood Shores! This is the ultimate open floor plan for living and entertaining. High ceilings artfully creating a sense of life in harmony with nature. Ideal kitchen design with a passthrough that leads to a functional flex room that can be utilized as a study or dining room. Kitchen adorned with beautiful crafted towering cabinets, impressive island, & breakfast bar that opens into a grand living area with a double sided fireplace adjoin the living area & outdoor living providing subtle warmth and ambiance. A notable primary suit w/ a luxurious soaking tub, walk in shower, double vanities.2nd level features 3 spacious bedrooms, a loft, & oversized balcony combining the interior & the exterior to create multi-functional areas to relax, work, or entertain. Feel worlds away in this neighborly community, w/ its peaceful lifestyle and lots centered around recreational lakes. Boat, fish, explore, enjoy the stunning sunsets & wildlife all year round.' ,`Acres` = '0.2667' ,`Area` = '42' ,`BuilderName` = 'RAA Innovations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 04, BLOCK 67 LOT 17' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '11618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2508' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westwood Shores Sec 4' ,`TaxAmount` = '95' ,`TaxRate` = '2.4708' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651969' WHERE `Matrix_Unique_ID` = '214841157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T12:20:39.960' ,`MLSNumber` = '68983328' ,`ListAgentFullName` = 'Wendy Ahmad' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = 'Judy Walker' ,`SellingOfficeName` = 'RE/MAX Universal' ,`Latitude` = '29.960293' ,`Longitude` = '-95.656374' ,`PhotoCount` = '32' ,`PostalCode` = '77429' ,`RoomCount` = '7' ,`ListPrice` = '509000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cypress Pass' ,`StreetNumber` = '12719' ,`StreetSuffix` = 'Loop' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2158' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a large backyard? This custom 3 bedroom, 2.5 bath victorian house sits proudly on a beautiful oversized lot. The recently remodeled kitchen features sleek granite counters, tons of cabinets and a counter breakfast bar! Entertainment sized living room with a brick accent fireplace, warm wood floors and neutral paint colors welcome you in. The formal dining is conveniently located off the kitchen and with easy access to the living room. Upstairs you will find a huge owners suite with bay windows and an impressive ensuite bathroom featuring two sinks, sit in vanity and two closets! All of the bedrooms are generous in size. This property also features a garage apartment with two bedrooms, living area and a full bathroom, a separate building that can be used as a workshop or extra storage! Endless possibilities! LOW Tax rate, NO restrictions, Water well and so much more. Do not miss this incredible opportunity.' ,`Acres` = '0.651' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 40 BLK 2 CYPRESS PASS ESTATES U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '28358' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SAMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Cypress Pass Estates' ,`TaxAmount` = '6983' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651969' WHERE `Matrix_Unique_ID` = '214894398' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:53:27.030' ,`MLSNumber` = '37079072' ,`ListAgentFullName` = 'Angela Angers' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = 'Chris Bell' ,`SellingOfficeName` = 'CENTURY 21 Western Realty' ,`Latitude` = '30.185532' ,`Longitude` = '-95.208409' ,`PhotoCount` = '50' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '525000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Misty Lake' ,`StreetNumber` = '24041' ,`StreetSuffix` = 'Circle' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mediterranean style home on over 2 acres that has stalls in shop for horses and is fenced. Automatic gate at both points of entry of circle drive, has keypad and remotes. Drive up to porte-cochere area entry. Home is filled with details including tray ceilings, art niches, and custom tile. Kitchen has large island, real wood cabinetry, and double ovens. Home has reverse osmosis water system. Detached garage has plenty of storage space. Shop is 36x36 and has two horse stalls and room for RV parking. It has water and electricity.' ,`Acres` = '2.018' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'NORTHCREST RANCH 03, BLOCK 2, LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '87904' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Northcrest Ranch 03' ,`TaxAmount` = '7503' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651969' WHERE `Matrix_Unique_ID` = '214930685' --> 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','214933964','1669651969','214933964','2022-11-27T11:05:42.780','53580894','Wanda Pearson','Keller Williams Realty -SW','','','29.556254','-95.435710','45','77584','7','389900.00','Active','Ivory Terrace','2906','Lane','Pearland','2','0','4','2332','Single-Family','Honey, STOP THE CAR! Welcome to this outstanding Perry build in pristine condition. Upon entry, you are greeted by an elegant, 11 foot extended entryway that escorts you past secondary bedrooms, a formal dining room, a beautiful kitchen with granite countertops on to your fabulous and open family room. You will enjoy tons of natural light with many walls of windows. Peek to admire your luxurious back garden that boasts of fruit trees, plants and vegetable garden boxes. The generously sized primary suite includes such poplar primary bath amenities as a soaking garden tub, separate vanities, stand alone glass enclosed shower and an oversized walk-in closet. This fabulous home is located in the highly sought after, master planned community of Shadow Creek Ranch. Positioned just off the Hwy. 288 corridor and only 10 miles from the Texas Medical Center! Easy access to \r\nshopping, eateries, downtown, sports arenas and airports. Enjoy the perks of walking trails, lakes, pools, and parks.','0.1705','38','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Pearland','Central Gas','1','SHADOW CREEK RANCH SF-57 PARTIAL REPLAT NO 1, BLOCK 1, LOT 2','Cleared,Subdivision Lot','7425','Appraisal District','','1000','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','19 - Fort Bend','BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)','WILLOWRIDGE HIGH SCHOOL','MCAULIFFE MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Shadow Creek Ranch Sf-57 Pt Rep 1','9406','3.2123','Other Water/Sewer','2017','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:48:09.610' ,`MLSNumber` = '76652721' ,`ListAgentFullName` = 'Vera Mitrofanova' ,`ListOfficeName` = 'VAM Real Estate Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.891029' ,`Longitude` = '-95.688819' ,`PhotoCount` = '46' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Park Sage' ,`StreetNumber` = '18210' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2430' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This immaculate and so loved by the current original owner house by KB Homes in the heart of Cypress features 3 bedrooms, 2 full bathrooms, den that open up to the dining, spacious office, formal living room with fireplace that opens up to the kitchen with silestone countertops and a plethora of cabinets and storage, breakfast nook. Huge primary bedroom with large bathroom that has separate shower, jacuzzi bathtub and two sinks. Carpet is only in the bedrooms. Covered patio, corner lot that offers a big yard and slab for your shed. Laundry room with lots of shelves. Garage has epoxy flooring. This house is one of a kind and offers everything you can think of. Surround system throughout the whole house. Full house gutters. Washer, dryer and fridge stay. Schedule your private showing today!' ,`Acres` = '0.2089' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 2 WESTGATE SEC 13' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westgate Sec 13' ,`TaxAmount` = '6769' ,`TaxRate` = '2.671' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651969' WHERE `Matrix_Unique_ID` = '214962605' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T11:47:52.920' ,`MLSNumber` = '75832089' ,`ListAgentFullName` = 'Nancy Ware' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820543' ,`Longitude` = '-95.781785' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Wren Valley' ,`StreetNumber` = '3214' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic location, just minutes from Grand Parkway/99. Beautiful five bedroom home on oversized lot. You are going to love what\'s upstairs. With four secondary bedrooms, a game room AND a media room everyone has space to do what they want to do. Additionally, there is a bonus room upstairs that could potentially be used as a 6th bedroom. Great kitchen with lots of cabinet space and a HUGE pantry. You\'ll love the large owner\'s suite, with beautiful bathroom and HUGE walk in closet. Outdoor living can be anything you want it to be; with over 10,400 sq ft, this lot is one of the larger ones in in the neighborhood. Quick drive to HWY 290 or I10. Churches, dining, and shopping nearby. Zoned to highly rated Katy ISD' ,`Acres` = '0.2406' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 MORTON CREEK RANCH SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10479' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'LEONARD ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton Creek Ranch' ,`TaxAmount` = '13917' ,`TaxRate` = '3.3333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651970' WHERE `Matrix_Unique_ID` = '214975994' --> 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','215000648','1669651970','215000648','2022-11-27T11:59:26.600','54107601','Rusty Shannon','Patti Shannon Properties','','','29.938584','-96.037622','17','77423','0','749000.00','Active','Bonanza','12199','Place','Brookshire','0','0','0','','Single-Family','Fair Weather Field Hangar on the runway. Recently Completed 70 ft x 80 ft Hangar. Hangar is Insulated - also an Insulated 60 wide x 16 tall Hydraulic Door, 24 ft Hunter Industrial Ceiling Fan, Water well, Aerobic system installed for black water, French Drains for gray water, LED Stadium Lighting inside, Automatic Outdoor LED Lighting, Sealed Concrete Floor, Antenna Mast Pier, Parking Apron for Aircraft and another for Automobiles, Electric Garage Door, Raised and Limed Foundation. Ready for your aircraft - you can also rent your extra hangar space to help cover your note.','1','26','','','','','Sellers Disclosure','','','','Hempstead','No Heating','1','S474600 FAIR WEATHER FIELD BLK 1 LOT 4 ACRES 1.0','Airpark','43560','Appraisal District','','900','0','','2','','0','','','','','Aluminum','24 - Hempstead','HEMPSTEAD ELEMENTARY SCHOOL','HEMPSTEAD HIGH SCHOOL','HEMPSTEAD MIDDLE SCHOOL','Appointment Required,Controlled Access,Lockbox Back,Request Online Appointment','','1','Barndominium,Other Style','Fair Weather Field','1672','1.8575','Aerobic,Well','2022','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215003436','1669651970','215003436','2022-11-27T12:33:34.180','23280613','Nicole Chandler','Lee DeForke Jr.','','','29.437902','-95.262547','35','77511','10','390000.00','Active','Shane Trail','1744','Drive','Alvin','3','1','5','2711','Single-Family','Charming, like new home ready for its new owners. This home features a spacious open floor plan for ease of entertaining and family time, the kitchen is sure to please the chef in your life complete with stainless steel appliances. Work from home? You\'re covered, the spacious office is waiting for your personal touches. Upstairs holds an oversized game room with the four additional bedrooms and two full baths. Did we mention the abundance of storage space in this home, not only are the closets spacious but there is a tremendous amount of walk-in attic space, that\'s right no climbing that little hide-away staircase with your holiday decor! As a bonus the primary suite is located on the first floor overlooking the backyard and community pond. This home has it all, call today for your private showing, it won\'t last long!','0.1364','5','','','','','Sellers Disclosure','1','','','Alvin South','Central Gas','1','SUNSET RANCH SEC 1 (A0420 HOOPER & WADE) (ALVIN) BLK 3 LOT 2','Waterfront','5942','Appraisal District','','625','0','','2','','0','','','','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required,Lockbox Front','Seller','2','Traditional','Sunset Ranch Sec 1','9350','2.8854','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215051718','1669651970','215051718','2022-11-27T12:15:48.107','335504','Martha Gomez','Martha Turner Sotheby\'s International Realty','','','29.731413','-95.613028','29','77082','6','289000.00','Active','Ashford Pine','12811','Drive','Houston','2','0','3','1468','Single-Family','Charming 1 story home located in the desirable Ashford Park. Completely open concept floor plan, the kitchen offers an oversized island and brand new appliances. The huge living room boasts high ceilings and wall of built-ins; the bedrooms have brand new carpet and the windows have been replaced with double pane windows. Perfect size if it is your first home or you are looking to downsize. Come to the backyard oasis to relax in your own private pool during the Houston summer months. Easy access to restaurants and shopping. This home is ready for you.','0.1263','31','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','0','Wood Burning Fireplace','1','Alief','Central Gas','1','LT 12 BLK 3 ASHFORD PARK SEC 1','Subdivision Lot','5500','Appraisal District','','595','0','','2','','1','In Ground,Salt Water','','Electric Cooktop','','Composition','2 - Alief','HEFLIN ELEMENTARY SCHOOL','AISD DRAW','O\'DONNELL MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Ashford Park','4267','2.4411','Public Sewer,Public Water','1977','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','215072029','1669651970','215072029','2022-11-27T12:39:46.650','28234962','Rusty Cable','Vanacor Properties','','','29.753192','-95.610343','28','77077','10','329000.00','Active','Beaconshire','1555','Road','Houston','2','1','4','2403','Single-Family','Energy Corridor, Great Neighborhood with pool and tennis courts, close to Terry Hershey Park, schools, and dining, secluded and quite culdesac lot with landscaping provided. 4 Bedrooms and 2.5 Bath home ready for you to move into immediately. Primary Suite includes Stand Up shower, Jetted tub, dual sinks and a large walk-in closet.Upstairs has a large room that can be used as a gameroom or 4th bedroom. Ceiling fans have been installed in all bedrooms, kitchen remodel completed that gives a more modern take on traditional. Make an appointment to come view this very livable home.','','31','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Energy Corridor','Central Electric','1','LT 101 STONEHENGE SEC 3 U/R R/P','Cul-De-Sac,Patio Lot','4336','Appraisal District','','789','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Cooktop,Freestanding Range','','Composition','27 - Houston','DAILY ELEMENTARY SCHOOL','WESTSIDE HIGH SCHOOL','WEST BRIAR MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Stonehenge Sec 03 U/R R/P','','','Public Sewer,Public Water','1984','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','215076705','1669651970','215076705','2022-11-27T11:45:51.990','62225648','Cy Uchendu','Intercity, Realtors','','','29.584051','-95.473359','7','77053','5','215000.00','Active','GOLD BRIDGE COURT','16703','','Houston','2','0','3','','Single-Family','','','38','','','','','Mud','','','','Missouri City Area','Central Electric','0','BENCHMARK SEC 1,BKL 2, LOT 25','Corner','','','','341','0','','2','','0','','','','','Composition','19 - Fort Bend','BLUE RIDGE ELEMENTARY SCHOOL (FORT BEND)','WILLOWRIDGE HIGH SCHOOL','MCAULIFFE MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','BENCHMARK','','','Public Water','1983','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','215082074','1669651970','215082074','2022-11-27T11:11:45.440','79724426','Zunaira Zaki','Key 2 Texas Realty','','','29.866632','-95.476806','29','77088','3','292000.00','Active','Fairway','7219','Court','Houston','2','0','3','1516','Single-Family','Welcome to 7219 Fairway, a stunning Inwood Forest home with three bedrooms, two full bathrooms, a spacious living room, a formal dining room, a beautiful kitchen, and plenty more! Upon entering, you will be led to an open-concept dining room that flows into the living room with views of the backyard. The kitchen features ample counter space, quartz countertops, and all new stainless steel appliances. The primary and secondary bedrooms feature airy windows and large closets. New shingles were installed in August 2022. The home is within walking distance from a Lone Star College Campus and significant hiking trails. This remodeled home is meticulously designed to elevate its structure. Don\'t miss out on this great opportunity and schedule a tour today!','0.1776','11','','','','','Sellers Disclosure','1','','1','Northwest Houston','Central Gas','1','LT 9 BLK 5 INWOOD FOREST SEC 2','Cul-De-Sac,Subdivision Lot','7735','Appraisal District','','300','0','','2','','0','','','Gas Range','','Composition','1 - Aldine','SMITH ACADEMY','EISENHOWER HIGH SCHOOL','HOFFMAN MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Inwood Forest Sec 02','4243','2.5119','Water District','1967','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','215091438','1669651970','215091438','2022-11-27T11:31:41.380','68873312','Ernesto Jimenez','HomeSmart','','','30.131528','-95.793063','2','77355','5','619000.00','Active','Camwood','460','','Magnolia','3','1','4','2752','Single-Family','Virtual tour is of previous home built with similar floor plan. Under Construction! This exceptional home offers many upgrades to enjoy sitting on 1.38 acres. This spacious kitchen has stainless steel appliances, a double oven, quartz countertops, a tile backsplash, a large island, recessed lighting, a walk-in pantry, and a built-in microwave. The spacious primary bedroom comes complete with a spacious bathroom and a large closet with ample space. The primary bathroom features a stand alone tub and separate shower with his and her vanity areas. Engineered hardwood flooring throughout with tile flooring in wet areas. Utilize a spacious oversized attached garage.','','15','Marielle Homes','','Electric Dryer Connections','','No Disclosures','1','Gas Connections','1','Magnolia/1488 West','Central Electric','1','CLEAR CREEK FOREST 11, BLOCK 6, LOT 29','Subdivision Lot,Wooded','60450','Appraisal District','','175','1','To Be Built/Under Construction','2','Double Oven,Electric Oven','0','','','Gas Cooktop','','Composition','36 - Magnolia','J.L. LYON ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Leave Business Card,Supra Keybox','Builder','1.5','Traditional','Clear Creek Forest','','','Septic Tank,Well','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215096908','1669651970','215096908','2022-11-27T11:17:12.717','83025107','Kurt Lutzow','AVOREC','','','30.216588','-95.341443','39','77302','6','229950.00','Active','Sun View','16196','Lane','Conroe','2','0','3','1383','Single-Family','Fall in love with this move-in ready, turnkey 3 bedroom/2 full bath home located in the acclaimed Conroe ISD, on the edge of The Woodlands and Conroe. The recent renovation includes all new light fixtures, stainless steel appliances, new kitchen and bathroom faucets and water heater. This charming single-story home has a large fenced in backyard perfect for entertaining or expansion. Living area has a cathedral ceiling, lots of windows and kitchen open to living area, making for a space everyone will enjoy hanging out in. Laminate tile throughout and Pecs piping. A full two-car garage. Low Taxes, No MUD tax and enjoy all the new amenities in the area for shopping and entertainment!','0.17','19','','','Electric Dryer Connections,Washer Connections','','Estate,No Disclosures','1','','0','Conroe Southeast','Central Electric','1','SUMMERSET ESTATES 01, BLOCK 1, LOT 17','Subdivision Lot','7405','Appraisal District','','103','0','','2','Electric Oven','0','','','Electric Range','','Composition','11 - Conroe','SAN JACINTO ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Summerset Estates 01','3968','1.8488','Public Sewer,Public Water','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215107786','1669651970','215107786','2022-11-27T12:07:58.747','29246541','Lida Aria','Main Realty','','','29.557276','-95.601780','50','77479','10','439900.00','Active','BRATTON','4031','Street','Sugar Land','2','0','4','2544','Single-Family','Beautifully ONE STORY WITH 3 CAR GARAGE AND PLENTY YARD FOR POOL. ONE OF THE LARGEST AND PRIVATE lots IN THE NEIGHBORHOOD LOCATED IN the heart of Sugar Land! You have first greeted an open floor plan with formal dining, study OR 4 TH BEDROOM with French doors, and a huge family room with vaulted ceilings and a wall of windows that let in tons of natural light—upgraded gourmet kitchen with SS appliances. Fantastic master retreat with oversized master bathroom w/ large walk-in his & her closets. Large secondary bedrooms. Come home and unwind on your beautiful patio w/ lush landscaping. you are zoned to ALL exemplary schools. Minutes away from many amenities. Easy access to major highways. Low tax rate and so much more!','','29','PERRY HOMES','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Sugar Land South','Central Gas','1','LT 30 BLK 1 SEC 2 OXFORD','Cul-De-Sac,Greenbelt,Subdivision Lot','17483','Appraisal District','','850','0','','3','Convection Oven,Electric Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','COMMONWEALTH ELEMENTARY SCHOOL','CLEMENTS HIGH SCHOOL','FORT SETTLEMENT MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','OXFORD/COMMONWEALTH','','2.2','Public Sewer,Public Water','1989','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','215109675','1669651970','215109675','2022-11-27T11:58:45.463','13628459','Janice Poscovsky','Spouses Selling Houses','','','29.572536','-95.579315','37','77459','9','338500.00','Active','Cotter Lake','4919','Drive','Missouri City','2','1','4','2272','Single-Family','The security of suburbia with the accessibility typically found in the city, this prime location in highly sought after First Colony is conveniently located to local and national groceries, coffee shops, a movie theater, wonderful restaurants and retail shopping. Zoned to highly rated schools it\'s been recently refreshed with full interior paint and new upstairs carpet. An east facing home, its primary bedroom is down with ensuite bath. New 3 inch blinds on all windows and a spacious kitchen with granite counters, lots of cabinets plus an island workspace. The kitchen sink window looks out into the fenced back yard and the driveway door to the kitchen makes grocery unloading a breeze. HOA amenities include the Aquatic center with Olympic lap pool and leisure pool that has lazy river, splash pad, vortex pool and tube slide within walking distance and a Pickleball court not too far away.','0.1799','29','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Levee District,Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Missouri City Area','Central Gas','1','LAKE COLONY SEC 2, BLOCK 1, LOT 31','Subdivision Lot','7836','Appraisal District','','812','0','','2','Gas Oven','0','','','Gas Range','','Composition','19 - Fort Bend','AUSTIN PARKWAY ELEMENTARY SCHOOL','ELKINS HIGH SCHOOL','FIRST COLONY MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Lake Colony Sec 2','6468','2.71','Public Sewer,Public Water,Water District','1988','Appraisal District'); --> New record created successfully