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-05T20:36:51.683' ,`MLSNumber` = '68062869' ,`ListAgentFullName` = 'Sara Blumenfeld' ,`ListOfficeName` = 'Delta Vee Realty-One LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594275' ,`Longitude` = '-94.997782' ,`PhotoCount` = '38' ,`PostalCode` = '77586' ,`RoomCount` = '7' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Baywood' ,`StreetNumber` = '719' ,`StreetSuffix` = 'Drive' ,`City` = 'Seabrook' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2378' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction in Seabrook right behind Maas Nursery. First level is 2089 sq ft and second level is 289 sq ft. 12x12 pilings. Open concept living/dining/kitchen areas, stainless steel appliances, quartz counters, soft-close drawers, under-counter lighting. Ten foot ceilings. Primary bedroom is on the first level with a large walk-in closet. Two of the three secondary bedrooms are on the first level and share a bathroom. The other secondary bedroom is on the second level with its own bathroom. Duralux premium luxury waterproof wide-plank vinyl throughout with premium Sentinil underlayment providing thermal and noise protection. Mud room adjacent to utility room. Large walk-in attic storage, covered back porch. 50 gallon hot water heater. 5 Ton Carrier HVAC system. BRAND NEW EVERYTHING means lower maintenance costs! Radiant attic barrier. Private waterfront area for this community has a large fire pit area and a beach area, just down the street from the home.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'C4 Built' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Baywood Place' ,`TaxAmount` = '' ,`TaxRate` = '2.4137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667725848' WHERE `Matrix_Unique_ID` = '207159085' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:33:27.343' ,`MLSNumber` = '20134366' ,`ListAgentFullName` = 'Sara Blumenfeld' ,`ListOfficeName` = 'Delta Vee Realty-One LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.594275' ,`Longitude` = '-94.997782' ,`PhotoCount` = '37' ,`PostalCode` = '77586' ,`RoomCount` = '6' ,`ListPrice` = '539900.00' ,`Status` = 'Active' ,`StreetName` = 'Baywood' ,`StreetNumber` = '723' ,`StreetSuffix` = 'Drive' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2338' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction in Seabrook right behind Maas Nursery. 12x12 pilings. Beautiful trees behind and across the street. Nine foot ceilings with trayed ceiling in living room and primary bedroom. Open concept living/dining/kitchen areas, stainless steel appliances including refrigerator, quartz counters, soft-close drawers, under-counter lighting. Duralux premium luxury waterproof wide-plank vinyl throughout with premium Sentinil underlayment providing thermal and noise protection. Primary bath has large shower and double sinks. The two secondary bedrooms share the other bathroom. 50 gallon hot water heater. 5 Ton Carrier HVAC system. BRAND NEW EVERYTHING means lower maintenance costs! Radiant attic barrier. Private waterfront area for this community has a large fire pit area and beach area just down the street from the home.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'C4 Built' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Blk 1 Baywood Place' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Baywood Place' ,`TaxAmount` = '' ,`TaxRate` = '2.4137' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667725848' WHERE `Matrix_Unique_ID` = '207159177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:07:49.493' ,`MLSNumber` = '24095919' ,`ListAgentFullName` = 'Alexander Gough' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730740' ,`Longitude` = '-95.503314' ,`PhotoCount` = '44' ,`PostalCode` = '77063' ,`RoomCount` = '9' ,`ListPrice` = '424500.00' ,`Status` = 'Active' ,`StreetName` = 'Chris' ,`StreetNumber` = '3207' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2562' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '10 minutes from Uptown Houston, in the established suburbs that connect with Briarmeadow Park, is a classic yet modern 4 bedroom, 2.1 bath, 2552 sqft home that\'s been newly renovated. Step inside the foyer from a gated driveway & into a designers dream living room with vaulted ceilings and a cutting black brick fireplace. Keep everyone engaged from the newly designed kitchen with custom cabinetry, granite countertops, & stainless steel appliances. Peek through the servers window in the kitchen out to the den which includes a half bath, a laundry room, and a set of french doors that lead you to the covered back porch with a low maintenance backyard. The master suite has private porch access, hardwood floors, & a renovated bathroom with built-in shelving & walk-in closets. 3 additional bedrooms all spacious with sizable closets and another full bath leave you with plenty of space. Schools, parks, shops are all within blocks away and a short drive to the famous Houston Galleria. Book It!' ,`Acres` = '0.1835' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 2 BRIARMEADOW SEC 02' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '760' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PINEY POINT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarmeadow Sec 02' ,`TaxAmount` = '10007' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725848' WHERE `Matrix_Unique_ID` = '209954104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:28:01.813' ,`MLSNumber` = '4916547' ,`ListAgentFullName` = 'Candelaria Hernandez' ,`ListOfficeName` = 'MDK Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.872019' ,`Longitude` = '-95.666807' ,`PhotoCount` = '18' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Stonechase' ,`StreetNumber` = '6515' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1930' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house will not last on the market. New floors, carpet, ceiling, fans, light fixtures and fresh paint in the surrounding home. The bonus man cave/theater room will include negotiable theater seating. Incredible custom trim work inside such as ShipLap, Beadboard panels, Board & Batten accent walls, LifeProof flooring, updated hvac vent covers, complete exterior power washed driveway, sidewalk, gutters and bricks. Brand new recently installed roof and negotiable new Samsung range. Contact agent for all showings.' ,`Acres` = '0.1567' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 7 STONE CREEK SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HOLMSLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Sec 01' ,`TaxAmount` = '6044' ,`TaxRate` = '3.071' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725849' WHERE `Matrix_Unique_ID` = '210449749' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:32:11.157' ,`MLSNumber` = '36769182' ,`ListAgentFullName` = 'Shirley Stewart' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973975' ,`Longitude` = '-97.902204' ,`PhotoCount` = '36' ,`PostalCode` = '78640' ,`RoomCount` = '12' ,`ListPrice` = '1775000.00' ,`Status` = 'Active' ,`StreetName` = 'Stageline' ,`StreetNumber` = '119' ,`StreetSuffix` = 'Drive' ,`City` = 'Kyle' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TRANQUILITY, PEACE,SECLUSION! A very private property that evokes a calm as you enter the property. Texas Hill Country at its finest. Blanco River front with seclusion all around the property. Home has been completely updated with split floor plan. Guest suite with living, kitchen, bedroom and bath. A Gourmet kitchen with custom LaCanche range, 2 ovens, gas and convection. Custom cabinets with soft close and Sub Zero refrigerator. Geo thermal HVAC, 20,000 gallon Rainwater tank with filtration system for primary water source and a well for backup. Well water is used to water lawn and plants. Wet weather creek in back of home which is surrounded by native trees. Abundant wildlife surrounds the property plus fishing and swimming in the Blanco River. Screened porch to enjoy the outdoors. \"Almost off the the grid just add solar\". Street side of property can be sub divided and add another home. Also, property can be connected to water and sewer at street. THE VISTA\'S ARE MAGNIFICENT' ,`Acres` = '3.523' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Stove' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Heat Pump,Other Heating,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A0361 JOHN PHARASS SURVEY, ACRES 3.523, AND BLANCO RIVER CRO' ,`LotDesciption` = 'Greenbelt,Waterfront,Wooded' ,`LotSize` = '153462' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '121 - Hays Consolidated' ,`SchoolElementary` = 'BLANCO VISTA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HAYS HIGH SCHOOL' ,`SchoolMiddle` = 'WALLACE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'ABSTRACTS IN HAYS ISD' ,`TaxAmount` = '5277' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725849' WHERE `Matrix_Unique_ID` = '211870249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:48:55.860' ,`MLSNumber` = '53028660' ,`ListAgentFullName` = 'Shane Terry' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040166' ,`Longitude` = '-95.585137' ,`PhotoCount` = '16' ,`PostalCode` = '77375' ,`RoomCount` = '9' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Harston' ,`StreetNumber` = '10914' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2513' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this Beautiful 2 Story, 4 Bedroom, 2 1/2 Bath, home with Soaring Ceilings, and Spacious Open Concept Living. Featuring a Private First Floor Primary Suite Includes Double Sinks and Generous Walk-In Closet! Working from Home can also be a Breeze in the Private Office/Flex Space located in the Front of the Home. Stunning Natural Light from the Plentiful Windows Surrounding the Home. Sizable Bedrooms and a Game Room is located Upstairs! The Backyard features a Covered Patio that\'s Perfect For Entertaining Family and Friends. Zoned to the Exemplary Klein ISD school district. Easy access to The Woodlands Mall, Shopping, Dining, I45, Hwy 249 and the Grand Parkway. This home has so much to offer!' ,`Acres` = '0.1289' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 5 ASHFORD PLACE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Place Sec 04' ,`TaxAmount` = '6948' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725849' WHERE `Matrix_Unique_ID` = '212021964' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:07:23.333' ,`MLSNumber` = '88704575' ,`ListAgentFullName` = 'Alexander Gough' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = 'Alexander Gough' ,`SellingOfficeName` = 'Texas Ally Real Estate Group,' ,`Latitude` = '29.661857' ,`Longitude` = '-94.902596' ,`PhotoCount` = '50' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '514900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Beasley Reef' ,`StreetNumber` = '226' ,`StreetSuffix` = 'Drive' ,`City` = 'Beach City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3677' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'At the end of a cul-de-sac, in the private community of The Oaks @ Houston Point in Baytown is a gorgeous 4 bed, 3 & a half bathroom, 3677 sqft home that sits on just over an acre of land. Step into the foyer from your covered front porch and you are met by an office on your right with double crown molding, french doors, and plenty of natural sunlight, and a dining room on your left that leads you to the kitchen. The Kitchen is fully equipped with a walk-in pantry, built in wine rack, stainless steel appliances, an eat in bar, plenty of cabinet space, and a kitchen island. The kitchen opens to the living room with a brick wood burning fireplace and access to your covered back porch and fenced in backyard. There are 2 Master suites, each with tray ceilings, walk-in closets, his & her vanities, a whirlpool tub, and separate shower. 2 additional guest beds & baths give you all the room you can ask for.\r\nEnjoy boating, fishing, and other recreational water activities on nearby Trinity Bay' ,`Acres` = '1.075' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 THE OAKS @ HOUSTON POINT' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '46827' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1348' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oaks/Houston Point' ,`TaxAmount` = '9155' ,`TaxRate` = '2.15' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725849' WHERE `Matrix_Unique_ID` = '212231021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:32:08.910' ,`MLSNumber` = '32762736' ,`ListAgentFullName` = 'Maria Saldivar' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472004' ,`Longitude` = '-95.160842' ,`PhotoCount` = '32' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkham' ,`StreetNumber` = '548' ,`StreetSuffix` = '' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Sellers!! This gorgeous one-story architecturally designed home built by Perry Homes in the desirable Westover Park Community offers four-sided masonry w/ full Artisan Antique Brick and Alamo Stone. Home features an open floor plan with 12 ft ceilings and 8 ft doorways. Beautifully sophisticated in style, the entry and spacious dining room are perfect for entertaining family and guests The HEART of this home, the kitchen offers 42\" dark wood cabinetry, granite countertops, stone backsplash, breakfast bar, large walk-in pantry and a breakfast area. Adjoining is the immense living room, which features a gas/wood burning fireplace, ideal for memorable gatherings. The Primary bedroom is located in the rear of the home. This home is complete with three additional bedrooms, the extra room, an office/study room and two-car garage.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTOVER PARK SEC 11B (2011) ABST 606, BLOCK 1, LOT 19, ACR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '605' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westover Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725849' WHERE `Matrix_Unique_ID` = '212280760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:05:22.623' ,`MLSNumber` = '16896483' ,`ListAgentFullName` = 'Alexander Gough' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688582' ,`Longitude` = '-95.420748' ,`PhotoCount` = '34' ,`PostalCode` = '77025' ,`RoomCount` = '7' ,`ListPrice` = '434500.00' ,`Status` = 'Active' ,`StreetName` = 'Lorrie' ,`StreetNumber` = '8427' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '5 Minutes from NRG Stadium in the established neighborhood of Knollwood, is a fully remodeled, 3 bed, 2 bath, 1672 sqft home, ready for a buyer. Walk passed the flowerbeds, under the covered patio, and into your open concept living room with hardwood flooring, LED lighting, and all new energy efficient windows that fill the room with natural sunlight. The living room opens up to your stunning kitchen with granite countertops, custom cabinetry, all new electric stainless steel appliances, and an eat-in kitchen island, with room left over for the kitchen table that looks out across a big backyard. The guest bath has been fully re-modeled from the re-finished bath & shower, to the herringbone pattern tile floors. Down the hall there are 2 sizable guest bedrooms with spacious closets. And the large master suite includes a gorgeous refinished tile shower that will make you late for work most mornings. Schools, restaurants, & parks are all within walking distance & downtown is 10 min away.' ,`Acres` = '0.2204' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 KNOLLWOOD VILLAGE SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Knollwood Village Sec 09' ,`TaxAmount` = '7761' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725850' WHERE `Matrix_Unique_ID` = '212320404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:15:29.417' ,`MLSNumber` = '51497716' ,`ListAgentFullName` = 'Evan Howell' ,`ListOfficeName` = 'Evan S. Howell, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718497' ,`Longitude` = '-95.660693' ,`PhotoCount` = '23' ,`PostalCode` = '77082' ,`RoomCount` = '6' ,`ListPrice` = '199950.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Rock' ,`StreetNumber` = '15702' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3-2-2 HAS POTENTIAL NEEDS SOME COSMETIC SOLD AS IS SEE ATTACHMENTS AL SHOULD BE SIGNED WITH OFFER.' ,`Acres` = '0.1492' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 FORESTVIEW SEC 2, SEE ATTACHED EXCEPTION' ,`LotDesciption` = 'Corner' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'REES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forestview Sec 02' ,`TaxAmount` = '3946' ,`TaxRate` = '2.405' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725850' WHERE `Matrix_Unique_ID` = '212353640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:21:10.093' ,`MLSNumber` = '37865734' ,`ListAgentFullName` = 'Dequaidrian Dorough' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.850325' ,`Longitude` = '-95.810849' ,`PhotoCount` = '12' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '313000.00' ,`Status` = 'Active' ,`StreetName` = 'Laird Knoll' ,`StreetNumber` = '25246' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1989' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HONEY STOP THE CAR!!! Welcome home to this beautiful two-story house, in the heart of Katy Tx, in the family-friendly Katy Manor subdivision. You\'ll be wowed when you open the front door and continue down the hallway to the very spacious Family room, which flows into the Dining room and Kitchen, or you can step outside on your covered patio with no back neighbors and enjoy the view. When you go upstairs, it opens up to the game room, and right next to it is the Master suite with a separate tub, shower, and double sinks. This home is zoned in the award-winning Katy ISD and the 5A Division 1 State Champion Paetow Panthers Football Team!' ,`Acres` = '0.117' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 KATY MANOR SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor Sec 5' ,`TaxAmount` = '7475' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667725850' WHERE `Matrix_Unique_ID` = '212457339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:21:48.907' ,`MLSNumber` = '26502293' ,`ListAgentFullName` = 'James Henderson' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.647691' ,`Longitude` = '-95.484887' ,`PhotoCount` = '50' ,`PostalCode` = '77035' ,`RoomCount` = '8' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Duxbury' ,`StreetNumber` = '5603' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic remodel in Westbury taken down to the studs! Beautiful kitchen features custom cabinets with built in wine rack, concrete counter tops, stainless appliances with gas stove, and deep under-mount sink. Master bedroom features enlarged bathroom with walk in glass shower, dual sinks, concrete counters, vaulted ceiling, huge walk in closet and custom cedar barn doors! All NEW electrical, plumbing, flooring, driveway, HVAC and paint. Indoor laundry and walk in pantry. Giant picture window overlooks backyard entertainer’s delight, complete with spacious deck with pergola (2020), new pine wood perimeter fence and gate. Home video surveillance system, monitored alarm system, mounted electronics, garage door, front door and thermostat controlled by smartphone. Premium home warranty, with one year of fees to be paid by seller from date of sale. Whole home 22 kW Generac standby generator that runs off natural gas line for continuous use (2022) Never flooded!' ,`Acres` = '0.1983' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 112 WESTBURY SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8640' ,`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` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 04' ,`TaxAmount` = '7808' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725850' WHERE `Matrix_Unique_ID` = '212801386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:08:21.613' ,`MLSNumber` = '74524944' ,`ListAgentFullName` = 'Dory Gordon' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.121215' ,`Longitude` = '-95.382179' ,`PhotoCount` = '25' ,`PostalCode` = '77386' ,`RoomCount` = '6' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Jewel Point' ,`StreetNumber` = '3707' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1302' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! You will love this beautifully maintained 3 bedroom craftsman! Stylishly updated with trending grays and white paint colors along with beautiful wood look tile flooring in all rooms. Check out the remodeled kitchen with all stainless steel appliances, sleek granite countertops, extra tall craftsman cabinets with lots of storage space. The bathrooms have been updated as well, carrying the same stylish theme throughout the house. Ceiling fans in the living room and all bedrooms plus new window blinds throughout the house. Fully fenced, huge backyard that is perfect space for weekend BBQs or a chef\'s garden!' ,`Acres` = '0.1675' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S688206 - LEGENDS RUN 06, BLOCK 2, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7297' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Legends Run 06' ,`TaxAmount` = '3985' ,`TaxRate` = '2.8187' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725850' WHERE `Matrix_Unique_ID` = '212861585' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:53:50.990' ,`MLSNumber` = '59638641' ,`ListAgentFullName` = 'Claudia Parr' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560801' ,`Longitude` = '-95.132923' ,`PhotoCount` = '25' ,`PostalCode` = '77062' ,`RoomCount` = '14' ,`ListPrice` = '267500.00' ,`Status` = 'Active' ,`StreetName` = 'Buoy' ,`StreetNumber` = '843' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this four bedroom, two & 1/2 bath home on a nice, fenced corner lot. The floor plan features both formals plus kitchen, breakfast and den with fireplace and skylights. There is a game room between den and garage. The kitchen has quartz countertops with subway tile backsplash, and the fireplace is in the corner. Both baths have had updating and the bedrooms are located in a split arrangement with an interior utility nicely placed near the secondary bedrooms. The exterior has recently been repainted as has much of the interior. There are extra glass front cabinets in the breakfast room. The living dining features 2 inch white blinds .The driveway is gated providing parking with a carport. The game room can serve any purpose. The home is located within walking distance of the elementary and the intermediate school. Bring your clients over for a look. You won\'t be disappointed.' ,`Acres` = '0.2153' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 28 CAMINO SOUTH SEC 3 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9380' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '77' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WHITCOMB ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'CLEARLAKE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Camino South' ,`TaxAmount` = '6770' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725851' WHERE `Matrix_Unique_ID` = '212983681' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:09:43.607' ,`MLSNumber` = '61569753' ,`ListAgentFullName` = 'Chelsea Gunn' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.533238' ,`Longitude` = '-95.224563' ,`PhotoCount` = '20' ,`PostalCode` = '77581' ,`RoomCount` = '13' ,`ListPrice` = '334900.00' ,`Status` = 'Active' ,`StreetName` = 'Gulfton' ,`StreetNumber` = '1113' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-story 4 bedroom home located in the highly sought-after Sunset Meadows community in East Pearland! This light & bright home boasts updates that include fresh texturing and paint, stylishly updated lighting, throughout the first-floor living space that includes a combined formal living and dining room with French doors, an inviting family room with a charming brick fireplace and a soaring ceiling, and a wide entrance to the sunlit breakfast room and kitchen with stainless appliances including double ovens and a gas cooktop. Also on the first floor, find the utility room with ample storage space & updated designer tile flooring, as well as the generous master suite with a soaking tub & a seamless glass shower. Upstairs, you’ll find\r\nthree bedrooms, one of which is large enough to easily convert to a game room or flex space as desired. Outside, enjoy the spacious yard with mature trees or take advantage of the community pool & playgrounds. Home has NEVER flooded!' ,`Acres` = '0.1446' ,`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` = 'SUNSET MEADOWS-NASAWOOD (A0111 PERRY & AUSTIN) (PEARLAND) BL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6299' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '363' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'RUSTIC OAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Meadows-Nasawood' ,`TaxAmount` = '6597' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725851' WHERE `Matrix_Unique_ID` = '213054675' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:33:36.063' ,`MLSNumber` = '57663251' ,`ListAgentFullName` = 'Cathy Stubbs' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.533113' ,`Longitude` = '-95.570636' ,`PhotoCount` = '40' ,`PostalCode` = '77479' ,`RoomCount` = '13' ,`ListPrice` = '875000.00' ,`Status` = 'Active' ,`StreetName` = 'Tamarino Park' ,`StreetNumber` = '6210' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FALL IN LOVE with this magnificent brick & stone 2-story luxury home located on a quiet tree-lined street in sought-after Riverstone Community. Custom-built by David Weekley featuring large rooms with high ceilings and classic finishes. Expansive open floor plan with combined family room, breakfast area, and kitchen. Fabulous built-in cabinetry throughout home. Two staircases and two bedrooms down! Cozy gas-log fireplace. Large 1st floor owner\'s suite. Plenty of room for family and extended family in this 5114 sq ft, 5-bedroom home that also includes a HOME OFFICE, GAME ROOM, and MEDIA ROOM! New interior paint and updated LED daylight lighting. Beautifully landscaped private back yard with covered patio is perfect for entertaining. Open green space across the street. Phenomenal Riverstone amenities include: water parks, fitness centers, clubhouse, playgrounds, tennis, golf, parks, trails and more. Top-ranked FBISD Schools. Oversized 3-car attached garage. Schedule a private tour today.' ,`Acres` = '0.2466' ,`Area` = '29' ,`BuilderName` = 'David Weekley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'THE ORCHARD AT RIVERSTONE SEC 2, BLOCK 3, LOT 4' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '10742' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Orchard At Riverstone' ,`TaxAmount` = '14870' ,`TaxRate` = '2.6729' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725851' WHERE `Matrix_Unique_ID` = '213377700' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:02:18.020' ,`MLSNumber` = '44710168' ,`ListAgentFullName` = 'Kim Fazzino' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.035346' ,`Longitude` = '-95.218676' ,`PhotoCount` = '34' ,`PostalCode` = '77339' ,`RoomCount` = '8' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Cove' ,`StreetNumber` = '2279' ,`StreetSuffix` = 'Trail' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in the gated community of Deer Cove. Oversized lot with no back neighbors makes this the perfect spot for your dream home ! Home features formal dining and cozy den as you enter foyer. Kitchen is open to den and the floorplan is perfect for entertaining. Primary suite it privately located on first floor and has extra sitting room that would also be a great study/home office. Enjoy spending time looking through the the windows overlooking private wooded reserve. Primary bath features separate tub and shower and has a huge closet. Upstairs has large gameroom, 3 secondary rooms and guest bath. Walking distance to Deer Ridge Park with horse stables, tennis courts, and more ! Upfront Kingwood allows for quick access to 59! Be sitting at the Astros game in 30 minutes or Bush Intercontinental Airport in 15 minutes ! Great location and great privacy. This home has it all ! Roof 2021, 1 HVAC 2022' ,`Acres` = '0.299' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 DEER COVE R/P' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '13024' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1145' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Deer Cove' ,`TaxAmount` = '9290' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725851' WHERE `Matrix_Unique_ID` = '213552331' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:24:46.757' ,`MLSNumber` = '3145009' ,`ListAgentFullName` = 'Lana Sanders' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483036' ,`Longitude` = '-94.934792' ,`PhotoCount` = '32' ,`PostalCode` = '77539' ,`RoomCount` = '13' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = '20TH' ,`StreetNumber` = '1026' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning, custom home with water views from every room. Move in ready and well equipped. New AC with warranty. Just a quick boat ride to open water, Top Water Grille or Pier 6. A laid back vibe, it’s located a block from the bay or ride up to Kemah or Margaritaville (2024). As you enter the home, you will be impressed by its pristine condition, arched ceilings and amenities. An open concept Living and Dining plan, makes full use of the whole space. The kitchen features tall cabinets and soft close drawers, SS appliances, pantry, granite and backsplash. The wood look tile is easy to maintain and there are shutters throughout. On the first floor there is a Bedroom/Study and full Bath. Expansive decks to enjoy the breezes. Head upstairs and there is Bedroom 2 with full Bath, a niche space for reading nook, gaming, toys or a dog suite. Down the hall is the private Primary Suite featuring a walk in shower and a generous walk in closet with built ins. See the video and drone shots!' ,`Acres` = '0.0769' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOT 37 BLK 190 SAN LEON' ,`LotDesciption` = 'Water View' ,`LotSize` = '3350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '6203' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725852' WHERE `Matrix_Unique_ID` = '213554374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:07:41.443' ,`MLSNumber` = '23594175' ,`ListAgentFullName` = 'Susana Villicana' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.721672' ,`Longitude` = '-95.588663' ,`PhotoCount` = '33' ,`PostalCode` = '77082' ,`RoomCount` = '7' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Louvre' ,`StreetNumber` = '3415' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious Royal Oaks Country Club Location! just remodeled, new flooring, carpet, and painted one-story home on a golf course and pool. Contemporary 4- 5 bedrooms and 4 full baths. The home has a formal dining, study, and very spacious floor plan: Granite Counters, Stainless Appliances, Luxury Home Great for corporate.' ,`Acres` = '0.2107' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 12' ,`LotDesciption` = 'Other' ,`LotSize` = '9180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Royal Oaks Country Club' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725852' WHERE `Matrix_Unique_ID` = '213558467' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:00:52.300' ,`MLSNumber` = '36614592' ,`ListAgentFullName` = 'Errol Nolan' ,`ListOfficeName` = 'Olympic Realty LLC' ,`SellingAgentFullName` = 'Errol Nolan' ,`SellingOfficeName` = 'Olympic Realty LLC' ,`Latitude` = '29.766621' ,`Longitude` = '-95.734620' ,`PhotoCount` = '22' ,`PostalCode` = '77450' ,`RoomCount` = '8' ,`ListPrice` = '259900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Westgreen' ,`StreetNumber` = '1239' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2109' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come and Check out this Opportunity! Spacious 4 bedroom Home with formal living and Dining large cover patio. Have tons of potential and great bones in a prime area.' ,`Acres` = '0.202' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 10B & 11A BLK 20 MEMORIAL PARKWAY SEC 6 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MEMORIAL PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Pkwy Sec 06 R/P' ,`TaxAmount` = '4662' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725852' WHERE `Matrix_Unique_ID` = '213628515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:09:07.523' ,`MLSNumber` = '52560168' ,`ListAgentFullName` = 'Karina Najera' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657669' ,`Longitude` = '-95.220944' ,`PhotoCount` = '22' ,`PostalCode` = '77587' ,`RoomCount` = '6' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue J' ,`StreetNumber` = '809' ,`StreetSuffix` = '' ,`City` = 'South Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1186' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out this charming home featuring 4 bedrooms, 1 bath and a LARGE gorgeous fully fenced back yard with a screened in back patio.The kitchen offers granite countertops and a new backsplash. Wood and title flooring throughout. UPDATES include: New AC and furnace (December 2021), new fence (2021), roof (2014), interior paint (2022), water filter system and more! Near Gulf freeway and the beltway. NO HOA. Don\'t miss out on this great opportunity!' ,`Acres` = '0.163' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'South Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 244 SOUTH HOUSTON' ,`LotDesciption` = 'Other' ,`LotSize` = '7100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'PEARL HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Houston' ,`TaxAmount` = '3217' ,`TaxRate` = '2.8255' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725852' WHERE `Matrix_Unique_ID` = '213644563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:06:16.083' ,`MLSNumber` = '22937243' ,`ListAgentFullName` = 'Azeez Elegbeji' ,`ListOfficeName` = 'The Elegbeji Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745705' ,`Longitude` = '-95.873741' ,`PhotoCount` = '32' ,`PostalCode` = '77494' ,`RoomCount` = '4' ,`ListPrice` = '365990.00' ,`Status` = 'Active' ,`StreetName` = 'Vernon Forest Ct' ,`StreetNumber` = '29203' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two-story house offers 4 bedrooms, 2.5 baths and 2 car garage.Soaring ceilings, open-concept floorplan provides a seamless flow between the kitchen and living room. Spacious kitchen with beautiful granite countertops and plenty of counter and cabinet space. Huge owner\'s suite with double sinks and oversized shower. There\'s flex space on the second floor for you to design the perfect space for entertainment. Extend your living outside with your nice covered patio and luscious green backyard. Plenty of shopping, dining, and entertainment options nearby. Tamarron offers everything you are looking for in a family friendly community- resort pool, splash-pad, fitness center, lakes & walking trails all included and ready for you!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Tamarron Sec 22, Block 4, Lot 28' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725852' WHERE `Matrix_Unique_ID` = '213732956' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:54:05.713' ,`MLSNumber` = '88859021' ,`ListAgentFullName` = 'Marvy Mendoza' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.655933' ,`Longitude` = '-95.296422' ,`PhotoCount` = '27' ,`PostalCode` = '77061' ,`RoomCount` = '4' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Evans' ,`StreetNumber` = '7227' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2067' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recent remodeled 4/5 bedroom, 1.5 Story home on 3/4 Acre, from new SIDING, plumbing, electrical, HVAC to additions. An Incomparable opportunity that won\'t come again. The updates to this home showcase the work of a true craftsman! The first floor offers open concept, living room stretching across the dining, continuing into a kitchen that is a chef\'s delight! Here you will find granite counter tops, walk-in pantry, adjacent to the kitchen is an indoor wash room. All 4 Spacious bedrooms are downstairs. Huge Primary w/massive bedroom closet. This home has been entirely restored and is turn-key ready. Porch and Backyard has 2 sheds and a green house. BONUS: Storage or guest room 300 sq ft next to the house. There is a 16x10 cement base for more storage building or garage. Easy access, 45, 610, 288, Beltway 8, and Hwy 35 to Pearland. Steps to Hobby Airport, minutes to Medical Center, Stadiums, etc. Garden Villas is where the pecan trees canopy over the streets and all peacocks roam freely.' ,`Acres` = '0.7461' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 24 GARDEN VILLAS' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '32500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN VILLAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Garden Villas' ,`TaxAmount` = '2637' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725853' WHERE `Matrix_Unique_ID` = '213734774' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:04:15.110' ,`MLSNumber` = '29524573' ,`ListAgentFullName` = 'Ashley Davis' ,`ListOfficeName` = 'Results Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.430272' ,`Longitude` = '-94.906598' ,`PhotoCount` = '44' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '700000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 223' ,`StreetNumber` = '1397' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Future you\'ve dreamed of awaits you. Coffee under the front porch watching the deer stroll casually as the sun rises, and a fishing rod and an adult beverage watching the sun go down. The breathtaking homefr4ont offers 12+/- Acres of fenced property ready for the horses, cattle, goats or whatever brings you happiness. Big farewell to deed restrictions and pricey HOA\'s, there\'s none of that here. The custom-built farmhouse presents you with just under 4,000 sqft and enormous amounts of outdoor living space, built with family in mind! located in the coveted Tarkington ISD, this one offers it all so come look at it yourself!' ,`Acres` = '12.185' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '000155 A CHERRY, TRACT 4, ACRES 12.185' ,`LotDesciption` = 'Cleared' ,`LotSize` = '530779' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'A Cherry' ,`TaxAmount` = '9129' ,`TaxRate` = '1.5226' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667725853' WHERE `Matrix_Unique_ID` = '213735060' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:36:17.613' ,`MLSNumber` = '12052195' ,`ListAgentFullName` = 'Emily Green' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Emily Green' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.613811' ,`Longitude` = '-95.056426' ,`PhotoCount` = '38' ,`PostalCode` = '77331' ,`RoomCount` = '3' ,`ListPrice` = '469999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Canary' ,`StreetNumber` = '130' ,`StreetSuffix` = 'Lane' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2571' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Paradise where you have lake life and country life all in one! This home sits on 1.4 acres and offers 3 bedrooms with a huge hobby room, 2 1/2 bathrooms, a sun deck, covered patio, and nice, big shop to store all of your outdoor toys in!' ,`Acres` = '1.3956' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PARADISE COVE, BLOCK 4, LOT 10-13, ACRES 1.3956' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '60792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '80' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Paradise Cove' ,`TaxAmount` = '6680' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725853' WHERE `Matrix_Unique_ID` = '213868470' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:18:38.047' ,`MLSNumber` = '83226423' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Gayla Gayden' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.738640' ,`Longitude` = '-96.168241' ,`PhotoCount` = '22' ,`PostalCode` = '77474' ,`RoomCount` = '11' ,`ListPrice` = '256990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Waterside' ,`StreetNumber` = '1261' ,`StreetSuffix` = 'Trace' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! The Easton by D.R. Horton in the New D. R. Horton Community called Westward Pointe in Sealy! Grand entry with gorgeous High Ceilings, Beautiful Wood Vinyl Floors throughout! Open Concept for entertainment! Casual Dining Room & Amazing Family Room with Wall of Windows overlooking your Covered Patio! Family Rm flows gracefully into the Casual Dining & Gourmet Kitchen W/Upgraded Granite Countertops, Large Eat-in Island W/Deep Under-mount Stainless Sink, Pull-Out Swan Kitchen Faucet, Stainless Steel Appliances, Tall Beautiful Shaker Cabinets & Walk In Spacious Pantry! The Owner\'s Suite features Plush Carpeting & Luxurious Bath w/Dual Deep Undermount Sinks, DuPure Drinking Water Filter System, Tall Shaker Cabinets with Granite Counters, Oversized Shower & Walk-in Closet! 3 Private Guest Bedrms, Granite on Full Bathrooms Vanity! \"Smart Home Automation allows you to control lighting, deadbolt locks, thermostat & Control from anywhere! NO FLOODING! Wonderful Amenities!' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Westward Pointe Lot: 4 / Block: 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'WESTWARD POINTE' ,`TaxAmount` = '' ,`TaxRate` = '3.079' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667725853' WHERE `Matrix_Unique_ID` = '213876921' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:23:11.163' ,`MLSNumber` = '21413395' ,`ListAgentFullName` = 'Jasmine Seastrunk' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.020690' ,`Longitude` = '-95.286669' ,`PhotoCount` = '11' ,`PostalCode` = '77338' ,`RoomCount` = '7' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Freedom River' ,`StreetNumber` = '20542' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning traditional home in Humble! This 3 bedroom, 2 bath ranch features an open concept floor plan, tile and luxury vinyl flooring in the common areas, and formal dining room - perfect for entertaining! The kitchen is light, bright, and boasts granite counters, serving bar, pantry, and matching appliance package - any chef\'s dream! Relax in the luxurious primary suite featuring oversized vanity with Hollywood lighting, walk-in closet, and garden tub with separate shower stall. Nestled on an oversized corner lot with private back yard, side yard, and covered patio, there\'s so much space for BBQs! Conveniently located, enjoy ease of access to local shopping, restaurants, and so much more! This one is an absolute must see!' ,`Acres` = '0.1484' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 5 DEERBROOK ESTATES SEC 10' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Deerbrook Estates Sec 10' ,`TaxAmount` = '5210' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725854' WHERE `Matrix_Unique_ID` = '213938667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:26:00.370' ,`MLSNumber` = '20148667' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Natalie Tye' ,`SellingOfficeName` = 'Monarch Real Estate & Ranch' ,`Latitude` = '29.739369' ,`Longitude` = '-96.169621' ,`PhotoCount` = '21' ,`PostalCode` = '77474' ,`RoomCount` = '11' ,`ListPrice` = '272990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Thornbird' ,`StreetNumber` = '1281' ,`StreetSuffix` = 'Trail' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One Story Home The Gaven Plan by D.R. Horton! Under Construction! Brick and Stone Elevation! Covered Patio! Gorgeous Vinyl Floors throughout! Granite Countertops in all the Full Bathrooms! This home is perfect for entertaining! Outstanding Open Floor Plan! Dramatic Gourmet Kitchen with stunning Granite Countertops, Large Eat-in Island with Deep Under-mount Stainless Sink, Tall Shaker Cabinets W/Hardware on Cabinets & Draws , Stainless Steel Appliances, Walk In Pantry & More! Gourmet Kitchen gracefully flows into your Casual Dining area & Amazing Family Area with Wall of Windows! The Private Owner\'s Suite features High Ceilings, Luxurious Bathroom built for 2 with His & Her Deep Undermount Sinks, Granite Vanity, Oversized Shower W/Seamless Glass Door & Walk-in Closet! Linen Nook! Energy Efficient Home: HERS Energy Rated! Blinds Included! \"Smart Home System, which allows you to control lights, locks, & thermostat! Covered Patio! NO FLOODING! The New Community Westward Pointe in Sealy!' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Westward Poine Lot: 3 /Block: 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'WESTWARD POINTE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667725854' WHERE `Matrix_Unique_ID` = '213944396' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:35:05.903' ,`MLSNumber` = '21998782' ,`ListAgentFullName` = 'Gabriel Mendoza' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = 'Gabriel Mendoza' ,`SellingOfficeName` = 'Orchard Brokerage' ,`Latitude` = '30.217946' ,`Longitude` = '-95.428152' ,`PhotoCount` = '30' ,`PostalCode` = '77385' ,`RoomCount` = '13' ,`ListPrice` = '309000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lace Flower' ,`StreetNumber` = '9897' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2319' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. This lovingly maintained residence checks all the boxes. This 4 bed/3 bath home has plenty of room to entertain with an ideal floor plan. The spacious family room welcomes guests to gather around the fireplace, perfect for the upcoming chilly nights. Stainless steel appliances, tile backsplash, and a breakfast bar are a few kitchen highlights. The breakfast nook and dining room are tucked away for privacy. Located on the second floor, the primary bedroom features a pristine en-suite bath with a garden tub and separate shower. The game room is ready to be filled with memories and can also be turned into a media room, play room, or extra living space. Relax outside under the large covered patio where the ceiling fans will help guests say cool during the hot Texas summers. Grocery stores, restaurants, and I-45 are just up the road for your convenience. Come see your new oasis! Welcome home!' ,`Acres` = '0.1262' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S720809 - MONTGOMERY CREEK RANCH 09, BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5497' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '322' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 09' ,`TaxAmount` = '6369' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725854' WHERE `Matrix_Unique_ID` = '214021577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:59:50.637' ,`MLSNumber` = '24717884' ,`ListAgentFullName` = 'Katelyn Pham' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.819277' ,`Longitude` = '-95.282750' ,`PhotoCount` = '33' ,`PostalCode` = '77028' ,`RoomCount` = '7' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue' ,`StreetNumber` = '7949' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is being sold AS-IS. From seller\'s experience since buying the home, it has never flooded. Great starter home or investment property in a quiet neighborhood with 4 bedrooms, and 2 full baths. New Carpet, New Roof (2021); Wall Unit (2022); Water heater (2022). Seller does not have a survey; buyer will have to purchase it if needed.' ,`Acres` = '0.0964' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 4 LIBERTY ROAD MANOR SEC 19 U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Liberty Road Manor Sec 19 U/R' ,`TaxAmount` = '1864' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725854' WHERE `Matrix_Unique_ID` = '214021840' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:40:07.457' ,`MLSNumber` = '6339776' ,`ListAgentFullName` = 'Alison Griggs' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.539843' ,`Longitude` = '-95.066682' ,`PhotoCount` = '26' ,`PostalCode` = '77573' ,`RoomCount` = '8' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Pelican' ,`StreetNumber` = '106' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPEN HOUSE SUNDAY NOVEMBER 6, 11:00AM - 2PM. \r\nAbsolutely gorgeous Perry Home. Light and bright, walls of windows, very open, high ceilings, island kitchen w/ recent ( 2020 ) cabinets & counters is open to living area and back yard w/ patio. All bathrooms remodeled in 2020, new exterior paint in progress. Versatile floor plan; office w/French doors has closet and could be a 4th bedroom, formal den could be library/office ( as is now ). This home has a sophisticated, updated, low maintenance, & private feel . Located on a corner lot, in a quiet cul de sac, inside a relatively small neighborhood (62 homes), where opportunity to buy rarely knocks. South Shore Harbor Resort & Fitness Center are within walking distance and can be accessed via neighborhood gate. Walking distance to 8 restaurants, grocery and golf course.' ,`Acres` = '0.2029' ,`Area` = '33' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MARINA PALMS SEC 1 (2002) ABST 18, BLOCK 1, LOT 36, ACRES 0.' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '8839' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marina Palms Sec 1 2002' ,`TaxAmount` = '7240' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725854' WHERE `Matrix_Unique_ID` = '214037107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:36:36.770' ,`MLSNumber` = '48098347' ,`ListAgentFullName` = 'Cindy Kipling' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.481917' ,`Longitude` = '-95.217273' ,`PhotoCount` = '37' ,`PostalCode` = '77546' ,`RoomCount` = '11' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Daytona' ,`StreetNumber` = '2414' ,`StreetSuffix` = 'Court' ,`City` = 'Friendswood' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story home with pool in highly desirable FISD neighborhood w/5 large bedrooms and with 4 full baths! Rare Dual staircase that leads upstairs w/one side located in kitchen and the other in the front foyer! Dramatic 2 story ceilings in the foyer and the den! The staircase and catwalk have upgraded wrought iron spindles. Updated tile with decorative inserts also found on the risers with wood like steps. The foyer is flanked by the dining room and the study which could be a formal living. Open living is found towards the back of home with the den, breakfast room, and the marvelous kitchen with enormous amount of cabinet and counter space and island. Large primary suite has a great ceiling design and his/her closets. A 2nd bedroom down makes easy access for older parents or even a nursery! Upstairs has Jack and Jill bath set up and then another bedroom upstairs by large game room. Newer AC units, solar screens, outdoor toilet for pool convenience. Low HOA fees' ,`Acres` = '0.3151' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 645 & 184 G PATTERSON SUR & M SLOAN SUR LOT 1 BLK 1 BOC' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Boca Raton Sec 1 93' ,`TaxAmount` = '9314' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725855' WHERE `Matrix_Unique_ID` = '214052043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:05:12.623' ,`MLSNumber` = '35461853' ,`ListAgentFullName` = 'Maggie McFarland' ,`ListOfficeName` = 'Re/Max Pearland Home Team' ,`SellingAgentFullName` = 'Roberto Garza' ,`SellingOfficeName` = 'Keller Williams HoustonCentral' ,`Latitude` = '29.552411' ,`Longitude` = '-95.239101' ,`PhotoCount` = '32' ,`PostalCode` = '77581' ,`RoomCount` = '6' ,`ListPrice` = '295000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Shady Creek' ,`StreetNumber` = '2905' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic 3 bedroom home located in the community of Woodcreek. Completely updated home features large family room with vaulted ceiling. Kitchen/breakfast area, located off living room, boasts crisp white cabinets, quartz countertops and equipped with stainless steel appliances. Huge primary bedroom with en-suite bath includes dual sinks, quartz top vanity & gorgeous oversized walk-in shower, crown molding and walk-in closet. Vinyl plank flooring throughout home. Fresh exterior paint, updated roof & solar screens. Large covered patio and storage shed. Schedule your showing today to see what all this home has to offer!' ,`Acres` = '0.1928' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WOODCREEK SEC 2 (PEARLAND), BLOCK 14, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SHADYCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodcreek' ,`TaxAmount` = '5319' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725855' WHERE `Matrix_Unique_ID` = '214054221' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:35:15.323' ,`MLSNumber` = '25311187' ,`ListAgentFullName` = 'Cathy Crawford' ,`ListOfficeName` = 'TAS Realty Group' ,`SellingAgentFullName` = 'Moji Oladunjoye' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.636791' ,`Longitude` = '-95.319951' ,`PhotoCount` = '34' ,`PostalCode` = '77048' ,`RoomCount` = '5' ,`ListPrice` = '230000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'El Topacio' ,`StreetNumber` = '6222' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Want to be \"Home for the Holidays\"? This is your chance! And, this home is the perfect place to invite your family to celebrate! Very spacious main living area truly the \"Heart\" of the home. You\'ll love working in the over-sized, eat-in kitchen that overlooks the living area. Kitchen with granite counters, mosaic glass backsplash and black appliances. Split bedroom floor plan features the primary bedroom nestled to the rear of the home. Primary bathroom is generously sized, a comfortable place to start the day. Backyard features an extended patio area, located just off your spacious kitchen. Soft grey paint and faux wood blinds recently added.' ,`Acres` = '0.095' ,`Area` = '3' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 5 EL TESORO SEC 2 R/P & EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'El Tesoro Sec 2' ,`TaxAmount` = '5464' ,`TaxRate` = '3.0707' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725855' WHERE `Matrix_Unique_ID` = '214220468' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:39:35.120' ,`MLSNumber` = '80665956' ,`ListAgentFullName` = 'Wanda Baptista' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768195' ,`Longitude` = '-95.640821' ,`PhotoCount` = '0' ,`PostalCode` = '77077' ,`RoomCount` = '6' ,`ListPrice` = '398750.00' ,`Status` = 'Active' ,`StreetName` = 'Briarhills' ,`StreetNumber` = '14438' ,`StreetSuffix` = 'Parkway' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2285' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has been fully renovated and remodeled! Situated in the energy corridor with easy access to I-10, Beltway 8, H 6, it has high ceilings with an open floor plan. New flooring, double pane windows, custom cabinets, crafted wood counter tops, new plumbing, electric wiring, and light fixtures. Bonus room of 183sf is not calculated in the total square footage of the home. Walk out your back door and enjoy popular Hersey Park bike and walking trails. Community amenities include pool, tennis courts and playgrounds. Everything has been done at this home, just move in!' ,`Acres` = '0.1569' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RES A2 BLK 3 (001,407*TR A1) BRIARHILLS SEC 1' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '6833' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '916' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarhills Sec 01' ,`TaxAmount` = '6281' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725855' WHERE `Matrix_Unique_ID` = '214249985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:01:42.530' ,`MLSNumber` = '54400705' ,`ListAgentFullName` = 'Errol Nolan' ,`ListOfficeName` = 'Olympic Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.057879' ,`Longitude` = '-95.383383' ,`PhotoCount` = '19' ,`PostalCode` = '77373' ,`RoomCount` = '8' ,`ListPrice` = '313000.00' ,`Status` = 'Active' ,`StreetName` = 'Blodgett Peak' ,`StreetNumber` = '23642' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Largest plan in the community with 4 bedrooms, 3 bath with a large game room Loft area. 2 rooms down and up. Large open flow kitchen, dining and living room. Located near major highways both 45, 59, also hardy toll road.' ,`Acres` = '0.132' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 4 BRECKENRIDGE WEST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Breckenridge West Sec 4' ,`TaxAmount` = '573' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725856' WHERE `Matrix_Unique_ID` = '214299115' --> 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','214342181','1667725856','214342181','2022-11-05T20:38:51.673','26594428','Fany Gomez','Porchlight Realtors, LLC','','','29.828057','-95.493187','13','77092','5','250000.00','Active','Thornwall','6726','Street','Houston','1','0','3','1240','Single-Family','Welcome to this cute one story home with a lot of potential for renovation. The garage has been converted into a bedroom,with a bathroom. NO HOA, NO RESTRICTIONS! Seller is motivated to SALE!!','0.1389','24','','','','','Sellers Disclosure','1','','0','Spring Branch','Central Gas','0','LT 23 BLK 25 LANGWOOD SEC 1','Subdivision Lot','6050','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','BANE ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','DEAN MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Langwood Sec 01','3944','2.5842','Public Water','1951','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:11:51.147' ,`MLSNumber` = '29137868' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.881688' ,`Longitude` = '-95.293825' ,`PhotoCount` = '9' ,`PostalCode` = '77016' ,`RoomCount` = '5' ,`ListPrice` = '45000.00' ,`Status` = 'Active' ,`StreetName` = 'Ribstone' ,`StreetNumber` = '11214' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HIGHEST & BEST OFFER DEADLINE MONDAY, 11/7/22, @ 12 PM\r\nBEING SOLD AS LOT VALUE ONLY.' ,`Acres` = '0.1641' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 38 BLK 25 NORTHWOOD MANOR SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Manor 2' ,`TaxAmount` = '2731' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725856' WHERE `Matrix_Unique_ID` = '214370444' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T20:03:12.057' ,`MLSNumber` = '58432632' ,`ListAgentFullName` = 'Sandy Douglas' ,`ListOfficeName` = 'Houston, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822011' ,`Longitude` = '-95.811159' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Jan' ,`StreetNumber` = '3337' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open House this Saturday from 1:00- 5:00 and Sunday November 6th from 1:00-5:00. Pride in ownership! Check out this single-story 3/2/2 1,500 SF home zoned to Katy Jr High and High School! Large living room and dining room combo with wood laminate flooring and vaulted ceilings. Ample-sized indoor laundry room/mud room off garage with cabinetry. Primary Master bedroom has an ensuite bathroom with a separate tub and shower, 2 walk in closets. Good size bedrooms. Fenced yard with patio, a 12x8 free-standing shed. Some Updates in the past few years include :Exterior AC replaced, LVT flooring and Carpet, Water heater, Some of the windows replaced, Storm doors on both exterior entrances, fresh exterior paint, Added Gutters and gutter gaurds. Low HOA dues and a low tax rate make this a can\'t miss opportunity close to the heart of Old Katy. Home did NOT flood.' ,`Acres` = '0.1148' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 HERITAGE PARK WEST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '316' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HUTSELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park West' ,`TaxAmount` = '4062' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725856' WHERE `Matrix_Unique_ID` = '214375317' --> 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','214378550','1667725856','214378550','2022-11-05T21:03:03.120','17833367','Charles Pritchett','Berkshire Hathaway HomeServicePremier Properties','','','29.162412','-95.615721','9','77486','7','357500.00','Active','Merion','2','Lane','Columbia Lakes','2','1','3','2342','Single-Family','Welcome to 2 Merion Lane. This charming and well-maintained two-story home is situated on a 1/2-acre lot in the gated community of Columbia Lakes. 3 bedrooms, 2 1/2 bath Includes Plantation shutters throughout, built in entertainment and fireplace, shiplap and crown molding. Bamboo and Slate flooring in living and kitchen area. Granite countertops. Bonus room could be used for office, work out or game room. New A/C in 2021, Brick and Hardy exterior, Sprinkler system throughout the yard, water softener, Security System. Garage includes extra storage. Backyard is spacious, beautifully landscaped, fenced and ready to relax and entertain. This HOA subdivision has an attended front gate, swimming pool, great walking, running, biking and golf cart riding as well as Lagoons for fishing. This remarkable home is a must see! Owners are motivated!','0.5233','5','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure,Special Addendum','1','Gas Connections','1','West of the Brazos','Central Gas','1','COLUMBIA LAKES SEC 1 (A0133 M VARNER) BLK 3 LOT 47-48','Corner,Cul-De-Sac,In Golf Course Community,Subdivision Lot','22795','Appraisal District','','50','0','','3','Electric Oven','0','','','Gas Range','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Columbia Lakes Sec 1-2-3-4-5','5522','2.1863','Public Sewer,Public Water','1988','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-05T21:50:57.897' ,`MLSNumber` = '89218406' ,`ListAgentFullName` = 'Sergio De La Llata Jr.' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.996766' ,`Longitude` = '-95.666656' ,`PhotoCount` = '27' ,`PostalCode` = '77429' ,`RoomCount` = '3' ,`ListPrice` = '100000.00' ,`Status` = 'Active' ,`StreetName` = 'Arapaho Bend' ,`StreetNumber` = '15923' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***MULTIPLE OFFERS RECEIVED*** Great opportunity to own this property in the Cypress Fairbank ISD school district. 2010 built in need of a new family who will give it some TLC, come take a look, property is priced to sell.' ,`Acres` = '0.1634' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 1 STABLEWOOD FARMS NORTH SEC 4 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '7116' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FARNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Stablewood Farms North Sec 04 R' ,`TaxAmount` = '5995' ,`TaxRate` = '2.94' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667725856' WHERE `Matrix_Unique_ID` = '214415333' --> 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','214458687','1667725857','214458687','2022-11-05T20:21:16.927','75095229','Nicole Shields','CRI Real Estate Services','','','30.240707','-95.501654','35','77384','6','436000.00','Active','Ripplewood','2474','Court','Conroe','2','1','3','2315','Single-Family','Welcome home to this custom built, corner lot home in the highly desired Carriage Hills neighborhood. Situated on just under 1/2 acre, this property features a wrap around porch and great curb appeal. Step inside an open floor plan complete with formal dining room, 2 story ceilings in living room, 2 sets of French doors off kitchen for back patio and front porch access. Kitchen with ample cabinets, dishwasher a few years old, panty half bath off kitchen, laundry room with cabinets and window.Recently installed carpet on the stairs and upper level. Both HVAC replaced one in 2019 other in 2022. Septic recently serviced. Zoned to The Woodlands Schools, close to many restaurants, shopping and convenient access to I-45, This is a must see!!','0.4729','15','','','Gas Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','1','Freestanding,Gas Connections','1','Conroe Southwest','Central Gas','1','CARRIAGE HILLS 01, BLOCK 1, LOT 39','Corner,Cul-De-Sac','20600','Appraisal District','','200','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','BUSH ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS HIGH SCHOOL','MCCULLOUGH JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Carriage Hills 01','5771','1.8488','Public Water,Septic Tank','1999','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','214459059','1667725857','214459059','2022-11-05T20:05:31.173','39123865','Theresa Almogabar','Keller Williams Woodlands','','','30.139367','-95.378517','28','77386','8','450000.00','Active','Enchanted Timbers','3809','Lane','Spring','2','1','4','2612','Single-Family','4 BEDROOMS+GAME ROOM+OFFICE+POOL+Falls at Imperial Oaks = PERFECT!This gem waits for you! At the entry you\'re greeted by wide walkways leading into the kitchen & living areas.Your home office is at the front of the home with two large windows facing the front yard & french doors for added privacy. The chef in your home will love cooking in this kitchen with TONS of counter space,cabinets for storage,and under-cabinet lighting. The living room is anchored by a gas fireplace and 3 large windows to see the POOL outside. The primary bedroom is spacious and features a bay window to let in tons of natural light. Primary bathroom features double sinks, a large soaking tub and separate shower. Upstairs your game room is large enough for a pool table! The secondary bedrooms are spacious and one is currently being used as a media room. Step outside into your own backyard oasis with a screened-in porch, pool and spa to play or relax, a fire pit for those cool nights, and plenty of seating areas.','0.1443','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Spring Northeast','Central Gas','1','S504217 - FALLS AT IMPERIAL OAKS 17, BLOCK 2, LOT 6','Subdivision Lot','6284','Appraisal District','','650','0','','2','Single Oven','1','Fiberglass','','Freestanding Range,Gas Range','','Composition','11 - Conroe','BRADLEY ELEMENTARY SCHOOL (CONROE)','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Falls At Imperial Oaks','9363','3.1987','Water District','2015','Appraisal District'); --> New record created successfully