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-01T07:31:59.487' ,`MLSNumber` = '7890164' ,`ListAgentFullName` = 'Karen Reidel' ,`ListOfficeName` = 'Matticks Real Estate &' ,`SellingAgentFullName` = 'Holly Fanning' ,`SellingOfficeName` = 'Fanning Realty and Company LLC' ,`Latitude` = '30.801171' ,`Longitude` = '-95.174703' ,`PhotoCount` = '17' ,`PostalCode` = '77364' ,`RoomCount` = '6' ,`ListPrice` = '129000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Martineque' ,`StreetNumber` = '41' ,`StreetSuffix` = 'Lane' ,`City` = 'Point Blank' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '2212' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come let your imagination run with this blank canvas and finish the interior with your own style. The current floor plan is plumbed with the kitchen on the second floor to include a dining room, family room, a full bath that separates the primary bedroom and second small bedroom. Enter the front door on the ground floor and through the foyer that expands into a large open space that includes a laundry room and full bath. This could easily be converted into two bedrooms or a bedroom and a gameroom. This room also leads to an oversized two car garage that includes a spacious separate storage room . The possibilities are endless. Kitchen cabinets purchased and never installed are included. White refrigerator and range convey with home. The waterfront community offers a boat ramp, pool, park and a clubhouse. The home includes the adjacent lot 241. Home is being sold \"AS IS\" Don\'t forget the golf cart with all your lake toys!' ,`Acres` = '0.1263' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PARADISE BAY, SEC E OF HVL, LOT 242, 241 ACRES .1263 & .1263' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '436' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Paradise Bay, Sec E of Hvl' ,`TaxAmount` = '3090' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309053' WHERE `Matrix_Unique_ID` = '205003048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:52:23.963' ,`MLSNumber` = '81512311' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749923' ,`Longitude` = '-95.878421' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '578517.00' ,`Status` = 'Active' ,`StreetName` = 'Cherry Vine' ,`StreetNumber` = '29411' ,`StreetSuffix` = 'Road' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 81512311 - Built by Highland Homes - January completion! ~ The popular Highland 2-story plan has a great living/dining area opening up to an giant covered outdoor living area enjoying the oversized backyard with room for a pool. The kitchen has a large island and breakfast bar open to the living room. This incredibly upgraded home features a 5-foot extension on the garage for extra storage, 2 bedrooms downstairs and 3 more bedrooms upstairs! All you need in this beautiful new section of the master planned community of Jordan Ranch.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '3/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7160' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch 55s' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309053' WHERE `Matrix_Unique_ID` = '206766377' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:20:14.297' ,`MLSNumber` = '7160353' ,`ListAgentFullName` = 'Misty Gustin' ,`ListOfficeName` = 'RE/MAX Crossroads Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.355166' ,`Longitude` = '-95.081566' ,`PhotoCount` = '11' ,`PostalCode` = '77510' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'S Fm 646' ,`StreetNumber` = '6228' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'So many options with this rare find! This 2+ acre cleared property has a charming 2/1 cottage and a HUGE 60x40 shop with 3 roll up doors and a living/kitchen space with a half bath. Conveniently located on FM 646 and having a separate driveway to the shop makes this a prime location for a possible home business or could easily be used for your hobbies. The property really opens up behind the shop to reveal a beautiful, cleared area. This home has so many possibilities including income producing potential. Come see this one today!' ,`Acres` = '2.135' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 48 L CRAWFORD SUR PT OF OUTLOT 215 (215-21) ALTA LOMA O' ,`LotDesciption` = 'Cleared' ,`LotSize` = '93001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Alta Loma Outlots' ,`TaxAmount` = '3706' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309053' WHERE `Matrix_Unique_ID` = '207804087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:45:38.870' ,`MLSNumber` = '26556166' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444498' ,`Longitude` = '-95.400583' ,`PhotoCount` = '27' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '699990.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado' ,`StreetNumber` = '4635' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 26556166 - Built by Highland Homes - Ready Now! ~ Highland\'s signature soaring ceilings catch your eye as soon as you walk into this home! Off the entry is a spacious study, perfect for working from home. Secondary bedroom with en-suite bath is tucked away downstairs, ideal for a guest suite. You\'ll love to entertain in this kitchen with the huge kitchen island that can accommodate additional seating. Features upgrades galore such as built-in hutch, quartz countertops, marble backsplash, pendant lighting, and more! Gather around the fireplace in the family room, which features eye-catching tile extended to the ceiling. Sliding glass doors lead you to the covered patio where you can enjoy the tranquility of Meridiana. Owners suite is complete with luxurious freestanding tub and large walk-in closet! Host game/movie nights in your own entertainment room upstairs. EXPANDED secondary bedrooms upstairs both have ensuite baths! Make an appointment to tour today!!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 43 (A0286) (MANVEL) BLK 1 LOT 45' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '0' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309054' WHERE `Matrix_Unique_ID` = '207983500' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:25:36.583' ,`MLSNumber` = '50638752' ,`ListAgentFullName` = 'Deanna Parsons' ,`ListOfficeName` = 'Gen Stone Realty' ,`SellingAgentFullName` = 'Valerie Parks' ,`SellingOfficeName` = 'Keller Williams Professionals' ,`Latitude` = '30.004361' ,`Longitude` = '-95.174085' ,`PhotoCount` = '25' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '319900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Wild Violet' ,`StreetNumber` = '6810' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3219' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HUGE fenced backyard! This house is over 3000 SF and has a detached 3 car garage. Large living area with a fireplace, two formals, plus a breakfast area. Primary bedroom is down, and the large gameroom is upstairs. Call your favorite realtor today for your private showing!!' ,`Acres` = '0.2957' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 35 PINEHURST OF ATASCOCITA 8 AMND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12879' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '618' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinehurst/Atascocita Sec 8' ,`TaxAmount` = '7003' ,`TaxRate` = '2.453' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309054' WHERE `Matrix_Unique_ID` = '208162211' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:53:58.110' ,`MLSNumber` = '51637505' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135446' ,`Longitude` = '-95.317993' ,`PhotoCount` = '29' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Jordan Pond' ,`StreetNumber` = '21551' ,`StreetSuffix` = 'Ridge' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 51637505 - Built by Highland Homes - Ready now! ~ Enter this 2-story home to high ceilings and beautiful staircase at the entry. This open concept floorplan is great for entertaining with soaring ceilings above the family areas. The primary suite, which features a bay window, is located on the first floor with all secondary bedrooms located on the second. The second floor also includes two full bathrooms and a game room.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 12 Block: 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.38' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309054' WHERE `Matrix_Unique_ID` = '208316691' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:54:30.433' ,`MLSNumber` = '80395796' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816102' ,`Longitude` = '-95.844328' ,`PhotoCount` = '37' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'San Bernard' ,`StreetNumber` = '7026' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 80395796 - Built by Highland Homes - January completion! ~ This stunning Highland Home is available in Cane Island in Katy Texas. 3011 sq ft includes a primary bedroom extension, extended outdoor living, sliding glass doors, gorgeous hutch in the kitchen, and fireplace in the family room. With Katy ISD schools, and a beautiful welcome center you have found a place to call home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '18/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7879' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island 65s' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309054' WHERE `Matrix_Unique_ID` = '209218831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:55:12.817' ,`MLSNumber` = '74903076' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.212432' ,`Longitude` = '-95.345685' ,`PhotoCount` = '14' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Glen' ,`StreetNumber` = '14915' ,`StreetSuffix` = 'Trace' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 74903076 - Built by Highland Homes - Ready now! ~ Awesome one story Model Design! High ceilings, lots of natural light, study, window seat at breakfast area, wood cabinets by Kent Moore, great walk-in pantry, and more. Enjoy your beautiful master bedroom with bay window, separate tub and shower in master bath. This is a great home for entertaining or relaxing. The enhanced outdoor living is perfect for grilling your favorite foods or enjoying a relaxing evening watching the grass grow! Sprinkler system and stainless steel appliances too. Must See!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S216907 - Artavia 07, BLOCK 4, Lot 16' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8574' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309054' WHERE `Matrix_Unique_ID` = '209628961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:33:10.763' ,`MLSNumber` = '56168068' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153650' ,`Longitude` = '-95.616938' ,`PhotoCount` = '6' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '290990.00' ,`Status` = 'Active' ,`StreetName` = 'Grey Fox' ,`StreetNumber` = '27282' ,`StreetSuffix` = 'Run' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1624' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Pocket Office, Open Concept Kitchen/Dining Combo, Dual Vanities in Primary Bath, Luxury Vinyl Plank Floors in Pocket Office, Dining Room, Kitchen, Family Room and All Wet Areas, Granite Kitchen Countertops, Upgrade Kitchen Backsplash, Undermount Stainless Steel Sink with Pull Out Faucet, Upgraded Stainless Steel Appliances with Microwave, 42\" Upper Kitchen Cabinets, Upgraded Lighting & Trim Packages, Covered Rear Patio, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE OCTOBER.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 20 BLK 2 SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309055' WHERE `Matrix_Unique_ID` = '209832610' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:09:24.217' ,`MLSNumber` = '91574786' ,`ListAgentFullName` = 'Lynn Juravich' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805571' ,`Longitude` = '-95.514103' ,`PhotoCount` = '10' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Western' ,`StreetNumber` = '9110' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity for rehab and or redevelopment possible room for 4+ townhomes. Large ranch style home on oversize lot. You have plenty of room for a large pool. 4 Bedrooms and 2 baths with patio. Fresh paint, recent roof, wood floor resurfaced. There is also a possibility for redevelopment, as there is a lot of activity in the area. Huge back yard for your four legged buddy.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 1 HOLLY OAKS' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '14096' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Holly Oaks' ,`TaxAmount` = '5325' ,`TaxRate` = '2.73102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309055' WHERE `Matrix_Unique_ID` = '210051275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:49:19.183' ,`MLSNumber` = '12596731' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444173' ,`Longitude` = '-95.400289' ,`PhotoCount` = '50' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '599990.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado' ,`StreetNumber` = '4643' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 12596731 - Built by Highland Homes - January completion! ~ This beautiful home has a tall elevation with a double door entry. Natural wood flooring throughout the home leads to sliding glass doors that take you outside to the extended covered patio! Black cabinets on the lower perimeter and island with white cabinets above. Quartz countertops with black cabinet hardware complete the look! Floor to ceiling tiled fireplace!' ,`Acres` = '0.1926' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 43 (A0286) (MANVEL) BLK 1 LOT 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8391' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '0' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309055' WHERE `Matrix_Unique_ID` = '210226825' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:14:28.667' ,`MLSNumber` = '79863144' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483081' ,`Longitude` = '-95.192355' ,`PhotoCount` = '35' ,`PostalCode` = '77546' ,`RoomCount` = '11' ,`ListPrice` = '799587.00' ,`Status` = 'Active' ,`StreetName` = 'Mason Terrace' ,`StreetNumber` = '2237' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 79863144 Built by Taylor Morrison, Ready Now! More than a house, Calypso is a welcoming home that is as sophisticated as it is practical. The first floor features a spacious owner’s suite with large walk in closet, double sinks, garden tub and large shower. A guest suite with sitting room is located at the front of the home. Formal dining, casual dining and a large gathering room opening to the gourmet kitchen keeps everyone connected! Upstairs, you’ll find two bedrooms, which share a full bath, a media room, game room and storage space. Located in a gated community with 36 acres of lakes! Structural options added to 2237 Mason Terrace include: multi-generation suite, sliding door at family room, extended owner\'s suite, covered outdoor living 1, 2nd island at kitchen, fireplace, 42\" door at entry.' ,`Acres` = '0.22' ,`Area` = '33' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 1, Avalon at Friendswood Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9591' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Avalon at Friendswood 70\'s' ,`TaxAmount` = '' ,`TaxRate` = '2.335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309055' WHERE `Matrix_Unique_ID` = '210410289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:26:35.723' ,`MLSNumber` = '60517334' ,`ListAgentFullName` = 'Diane Kink' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.065346' ,`Longitude` = '-95.138847' ,`PhotoCount` = '50' ,`PostalCode` = '77336' ,`RoomCount` = '16' ,`ListPrice` = '2995000.00' ,`Status` = 'Active' ,`StreetName` = 'Mendecino Glen' ,`StreetNumber` = '28503' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '8584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront living provides a quiet place to connect with family, friends, & nature, and this stunning estate enjoys it all. Set back on 2.54 tranquil acres, this custom stunner feels worlds away from the hustle & bustle yet is a short drive to every amenity from dining & shopping to medical and freeway access. A thoughtful floor plan combines exceptional quality & craftsmanship where every comfort is beautifully presented. Highlights include a climate-controlled 6-car garage; Whole house generator; whole house sound system; Control 4; soaring ceilings & hand-scraped wood floors; 1st fl theatre; wine tasting room; gourmet kitchen & high-end appliances; primary retreat & incredible custom closets. 2nd fl wow-factor balcony views & home gym; 4 spacious en-suite bedrooms. Outdoor pavilion w/fireplace, summer kitchen, al fresco dining area & sports pool. A private Trex boat dock w/ electrical hookup allows for quick access & easy playtime on the lake. Fully fenced & gated; Much, much more!' ,`Acres` = '2.54' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 36 & 37 BLK 2 COMMONS WATERWAY SEC 4' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '110642' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Commons Waterway Sec 4' ,`TaxAmount` = '51726' ,`TaxRate` = '3.2592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309055' WHERE `Matrix_Unique_ID` = '210631564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:49:56.947' ,`MLSNumber` = '93410421' ,`ListAgentFullName` = 'Deanna Parsons' ,`ListOfficeName` = 'Hill & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816071' ,`Longitude` = '-94.830796' ,`PhotoCount` = '15' ,`PostalCode` = '77523' ,`RoomCount` = '6' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Cove' ,`StreetNumber` = '6123' ,`StreetSuffix` = 'Road' ,`City` = 'Cove' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW APPLIANCES!! NEW PAINT!! NEW CARPET!! This 3/2.5 is so beautiful! Large livingroom. Breakfast area. Great kitchen with new appliances. Half bath downstairs. All bedrooms are upstairs along with the large utility room.' ,`Acres` = '0.172' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 19 BK 2 JOSEPHS COVE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Josephs Cove Sec 3' ,`TaxAmount` = '4074' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309056' WHERE `Matrix_Unique_ID` = '210792828' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:53:29.920' ,`MLSNumber` = '18264226' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470059' ,`Longitude` = '-95.463666' ,`PhotoCount` = '40' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '321990.00' ,`Status` = 'Active' ,`StreetName` = 'Caspian Ranch' ,`StreetNumber` = '7707' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Justin Plan with Elevation N, features a modern design and offers 4 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!\r\n\r\nListing photos are of a similar floor plan. Finishes may vary and are subject to change.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309056' WHERE `Matrix_Unique_ID` = '210871470' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:56:43.903' ,`MLSNumber` = '26668828' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209024' ,`Longitude` = '-95.329057' ,`PhotoCount` = '21' ,`PostalCode` = '77302' ,`RoomCount` = '9' ,`ListPrice` = '570880.00' ,`Status` = 'Active' ,`StreetName` = 'Merigold Heights' ,`StreetNumber` = '17355' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 26668828 - Built by Highland Homes - January completion! ~ Gorgeous Griffith floorplan sitting on a premium lot with no back neighbors! This home has soaring ceilings and an abundance of windows for plenty of natural light. Wood-look flooring throughout the main living areas, GE stainless steel appliances, white cabinets, and quartz countertops throughout! This home is also a smart home equipped with Eero wifi enhancers, Honeywell wifi thermostat, Rheem tankless water heater, wifi garage door opener, wifi Smartlock on front door, a Skybell doorbell camera, a full sprinkler system and much more!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S216912 - ARTAVIA 12, BLOCK 1, LOT 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5818' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309056' WHERE `Matrix_Unique_ID` = '210881179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:47:54.057' ,`MLSNumber` = '78031846' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209233' ,`Longitude` = '-95.329638' ,`PhotoCount` = '21' ,`PostalCode` = '77302' ,`RoomCount` = '7' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Trails' ,`StreetNumber` = '15927' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2661' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 78031846 - Built by Highland Homes - December completion! ~ Gorgeous and brand new Lotus floorplan with soaring two story ceiling in the living and dining rooms and an abundance of windows for plenty of natural light. guest suite with private bathroom downstairs. Wood-look flooring throughout the main living areas, GE stainless steel appliances, white cabinets, and quartz countertops throughout! This home is also a smart home equipped with Eero wifi enhancers, Honeywell wifi thermostat, Rheem tankless water heater, wifi garage door opener, wifi Smartlock on front door, a Skybell doorbell camera, a full sprinkler system and much more!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S216912 - ARTAVIA 12, BLOCK 1, LOT 72' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5954' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309056' WHERE `Matrix_Unique_ID` = '210913274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:55:47.900' ,`MLSNumber` = '79054509' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209630' ,`Longitude` = '-95.328957' ,`PhotoCount` = '15' ,`PostalCode` = '77302' ,`RoomCount` = '8' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Merigold Heights' ,`StreetNumber` = '17351' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 79054509 - Built by Highland Homes - December completion! ~ BRAND NEW FLOOR PLAN with beautiful sliding glass doors in the family room. 2nd bedroom down En Suite is perfect for guests. Private study located in the front. The heart of the homes features a spacious white kitchen open to the dining and family room. Dining room includes a built in hutch with glass upper shelves. Spacious primary retreat with bay window a relaxing free standing tub . Tankless hot water and Smart Home Technology Package Included!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S216912 - ARTAVIA 12, BLOCK 1, LOT 38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5765' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309056' WHERE `Matrix_Unique_ID` = '210915507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:30:14.153' ,`MLSNumber` = '5828906' ,`ListAgentFullName` = 'Cyrenian Scott' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.024762' ,`Longitude` = '-95.356339' ,`PhotoCount` = '48' ,`PostalCode` = '77338' ,`RoomCount` = '9' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadmark' ,`StreetNumber` = '4620' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Escape to this charming 4 bedroom 3 bathroom home tucked away in Forest Shadows. Owners have beautifully remodeled the bathroom showers and tile flooring, added shoe shelving in his and hers primary closets, added additional LED lighting in the kitchen, and more. Large primary bedroom with spacious primary bath featuring separate tub and shower with massage hydro jet tub. The inviting and spacious kitchen opens up to the family room which is perfect for entertaining guest. Enjoy the morning sunshine from the second story balcony or work from home in the cozy bonus room that\'s just steps away from the game room. This home checks all the boxes.' ,`Acres` = '0.2642' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'LT 111 BLK 7 FOREST SHADOWS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11508' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Shadows Sec 02' ,`TaxAmount` = '8875' ,`TaxRate` = '2.0908' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667309057' WHERE `Matrix_Unique_ID` = '210994083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:43:01.883' ,`MLSNumber` = '65348382' ,`ListAgentFullName` = 'Christopher Ward' ,`ListOfficeName` = 'Orchard Brokerage' ,`SellingAgentFullName` = 'Wilberforce Okene' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.687479' ,`Longitude` = '-95.722198' ,`PhotoCount` = '39' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '364000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brighton Brook' ,`StreetNumber` = '19546' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2223' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Click the Virtual Tour link to view the 3D walkthrough. Stunning 3 bedroom/2 bath home with tons of space! Located in the Grand Mission community, close to schools, retail, entertainment, West Park Tollway and Grand Park Way. Details such as high ceilings, crown molding, art niches, and built-ins will impress from the moment you enter! Multiple spaces to suit everyone\'s needs, including a family room, a living room, an office, and a formal dining room. The gorgeous island kitchen boasts a breakfast bar, tile backsplash, plus recessed lighting that highlights the granite countertops and stainless steel appliances. Retreat to the spacious primary bedroom, featuring a large walk-in closet, a soaking tub, and a dual vanity. Multiple outdoor living spaces, including a covered front porch and a covered patio in the fenced backyard! Take advantage of community amenities like the resort-style pool with water slide!' ,`Acres` = '0.1639' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 17, BLOCK 1, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7138' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '827' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission Sec 17' ,`TaxAmount` = '6315' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309057' WHERE `Matrix_Unique_ID` = '211179676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:38:54.863' ,`MLSNumber` = '29790362' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787934' ,`Longitude` = '-95.325065' ,`PhotoCount` = '13' ,`PostalCode` = '77026' ,`RoomCount` = '3' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Wylie' ,`StreetNumber` = '4438' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This three bedroom / one bathroom single-family home is well positioned on a corner lot peppered with mature trees. Freshly refurbished and well maintained to enjoy today’s living styles. This home is currently tenant occupied and rent rolls are available upon request. Located near plenty of parks and restaurants and just minutes from Downtown Houston as well as the highly anticipated East River Project.' ,`Acres` = '0.1027' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR D BLK 8 GRANT PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4472' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DOGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grant Park' ,`TaxAmount` = '3087' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309057' WHERE `Matrix_Unique_ID` = '211245226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:38:14.193' ,`MLSNumber` = '28339721' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784380' ,`Longitude` = '-95.314517' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Sam Wilson' ,`StreetNumber` = '2421' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy single-family home in Denver Harbor with a studio apartment sits on a 5000-square foot lot is an ideal rental property or opportunity to house hack by renting out the studio apartment. Both units are currently tenant-occupied. Rent rolls are available upon request.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 15 CHEW F F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chew F F' ,`TaxAmount` = '3487' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667309057' WHERE `Matrix_Unique_ID` = '211245243' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:59:09.057' ,`MLSNumber` = '59887480' ,`ListAgentFullName` = 'Jennifer Stolarski' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.038890' ,`Longitude` = '-95.478854' ,`PhotoCount` = '29' ,`PostalCode` = '77388' ,`RoomCount` = '6' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Coltwood' ,`StreetNumber` = '4023' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1829' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***PRICE REDUCED!*** THIS HOME WON\'T LAST LONG!\r\nDon\'t miss your chance to see this nice one story home located in the highly sought Klein School District in the Cypressdale Subdivison. Relax in the large living room with a brick wood burning fireplace or enjoy the outdoors under the covered patio or out in the large backyard. \r\nNew countertops and microwave in Kitchen, primary bath has both a new vanity cabinet and countertop, new hot water heater installed September 2022.\r\nGreat opportunity for an investor or as your primary home. \r\n***SUBMIT YOUR OFFER TODAY!***' ,`Acres` = '0.1941' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 17 CYPRESSDALE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8454' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '405' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypressdale SEC 4' ,`TaxAmount` = '4226' ,`TaxRate` = '2.4565' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309057' WHERE `Matrix_Unique_ID` = '211384225' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:18:46.793' ,`MLSNumber` = '87181432' ,`ListAgentFullName` = 'Seungjae Lee' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599284' ,`Longitude` = '-95.808419' ,`PhotoCount` = '24' ,`PostalCode` = '77471' ,`RoomCount` = '7' ,`ListPrice` = '339500.00' ,`Status` = 'Active' ,`StreetName` = 'Wayne' ,`StreetNumber` = '6207' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 years old Home! Current Owner bought it brand new and Improved (Back yard, Patio, Extended slab, Extended side yard fence, Extra room, fixtures, Lawn).' ,`Acres` = '0.166' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KINGDOM HEIGHTS SEC 4, BLOCK 3, LOT 26' ,`LotDesciption` = 'Other' ,`LotSize` = '7232' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Kingdom Heights Sec 4' ,`TaxAmount` = '5922' ,`TaxRate` = '2.7948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309058' WHERE `Matrix_Unique_ID` = '211433596' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:05:53.967' ,`MLSNumber` = '25083340' ,`ListAgentFullName` = 'Dulce Davis' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.247236' ,`Longitude` = '-95.234629' ,`PhotoCount` = '31' ,`PostalCode` = '77577' ,`RoomCount` = '5' ,`ListPrice` = '274500.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 776' ,`StreetNumber` = '215' ,`StreetSuffix` = '' ,`City` = 'Liverpool' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1430' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'READY TO GO! Elevation Cert, Flood quote, Survey, Termite insp ALL DONE! Flood quote cheap considering it\'s a waterview home. Sqr ftg is 1430 per professional floor plan. Main living area up w/ serene water views of Chocolate Bayou. 2 bdrms up, 1 bdrms down. Partial Amenity List, See full list in \"About Me\" Booklet: Paint, 2718 sf of concrete, Granite in kitch/bath up, Luxury Vinyl Planking, Porcelain shower surrnd, LED Fans/lights, Cvr deck up 734sqr ft, plus lg cvrd patio on side yard, 8 car cvrd parking w/ 51 ft uncvrd parking, Approx 33x13ft cvrd concrete pad behind home, Overszd 4 car garage spaces, Workbench in back of one bay, Water softener, Generac generator w/dedicated propane tank. Half bath down is only toilet with ability to reinstate shower. Gulf is 5-10 mins by boat. Multiple boat launches within 2 minutes. This home is water VIEW, no direct access on the property itself. Lutes Marina basically at end of street to launch boat. Ask for Full About Me Booklet!' ,`Acres` = '0.3444' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HARBORVIEW HOMESITES (A0011 HENRY AUSTIN), LOT 8-9 SEC 1' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '15002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Harborview Homesites' ,`TaxAmount` = '1963' ,`TaxRate` = '2.2507' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309058' WHERE `Matrix_Unique_ID` = '211521050' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:35:07.930' ,`MLSNumber` = '55285695' ,`ListAgentFullName` = 'Emanuel Marsis' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Emanuel Marsis' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.747230' ,`Longitude` = '-95.398120' ,`PhotoCount` = '9' ,`PostalCode` = '77006' ,`RoomCount` = '4' ,`ListPrice` = '1090900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Yupon' ,`StreetNumber` = '2303' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2974' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completion Sep 2022. Luxurious Urban 4-Story Custom Built with outstanding custom features allover. Located in the heart of Cherryhurst. Unobstructed Park View on the West Side, and Unobstructed Downtown view on the East Side. 4-Story Elevator. High Ceilings with high-end millwork. Thermador Appliances. Chef’s kitchen comes with custom built cabinets, and a huge island. The spacious rooftop comes with a breathtaking views of downtown, Allen Pkwy, and Med Center. Spacious Master Bedroom with custom built closet. Spacious master bathroom. Features include custom cabinets, hidden appliances, grade 1 white oak solid hardwood floors, 2 high efficiency AC units with multi zone control, solid core doors, in-wall insulation in all interior walls , heated master bath mirrors, in-drawer outlets, jacuzzi tub and much more. Prewired Alarm sysrem. In-ceiling speakers on the 4th floor, and pre-wired speakers in the living and master bedrooms.' ,`Acres` = '0.0432' ,`Area` = '16' ,`BuilderName` = 'Amal Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 AMAL HOMES ON Maryland' ,`LotDesciption` = 'Corner' ,`LotSize` = '1883' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cherryhurst' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309058' WHERE `Matrix_Unique_ID` = '211558868' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:35:40.690' ,`MLSNumber` = '56104814' ,`ListAgentFullName` = 'Emanuel Marsis' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747226' ,`Longitude` = '-95.398082' ,`PhotoCount` = '16' ,`PostalCode` = '77006' ,`RoomCount` = '3' ,`ListPrice` = '769900.00' ,`Status` = 'Active' ,`StreetName` = 'Yupon' ,`StreetNumber` = '2307' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completion Sep 2022. Luxurious Urban 3-Story Custom Built with outstanding custom features allover. Located in the heart of Cherryhurst. Unobstructed Park View on the West Side, and Unobstructed Downtown view on the East Side. 3-Story Elevator Shaft. High Ceilings with high-end millwork. Thermador Appliances. Chef’s kitchen comes with custom built cabinets, and a huge island. The spacious rooftop comes with a breathtaking views of downtown, Allen Pkwy, and Med Center. Spacious Master Bedroom with custom built closet. Spacious master bathroom. Features include custom cabinets, hidden appliances, grade 1 white oak solid hardwood floors, 2 high efficiency AC units with multi zone control, solid core doors, in-wall insulation in all interior walls , heated master bath mirrors, in-drawer outlets and much more.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'Amal Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 2 AMAL HOMES ON Maryland' ,`LotDesciption` = 'Corner' ,`LotSize` = '1559' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODROW WILSON MONTESSORI' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cherryhurst' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309058' WHERE `Matrix_Unique_ID` = '211561010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:55:24.690' ,`MLSNumber` = '38226526' ,`ListAgentFullName` = 'Elizabeth Tinnell' ,`ListOfficeName` = 'Tower Point Realty' ,`SellingAgentFullName` = 'Jayda Gray' ,`SellingOfficeName` = 'Keller Williams Realty Austin' ,`Latitude` = '30.379470' ,`Longitude` = '-95.628961' ,`PhotoCount` = '23' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '799999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Deepwater' ,`StreetNumber` = '9256' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Waterfront Paradise on Lake Conroe with amazing views! This entertainment haven has a spot for everyone and a view from every seat. The outdoor kitchen and eating bar provide plenty of space to sit and enjoy a meal or just relax on the covered patio or sit under the two palapa\'s next to the waterfalls or the natural rock grotto featuring seating beneath it. You have an amazing open water view from the very large sundeck or the boat dock that features a 6000lb boat lift with new cover and twin jet ski lifts. The pool and spa have just been resurfaced with a tranquil blue hue that complements the new blue tiles. It features multiple swim out ledges and a retractable awning that shades much of the afternoon sun. The open concept interior has French doors and large windows to maximize your lake views. Large kitchen with ample counter space and cabinets has a breakfast bar and additional pantry space. Storage space is not lacking here! Freshly painted decks!' ,`Acres` = '0.1526' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HARBOUR POINT REPLAT B, BLOCK 5, LOT 13-B,14' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '6649' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbour Point Rep B' ,`TaxAmount` = '10735' ,`TaxRate` = '2.3542' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667309058' WHERE `Matrix_Unique_ID` = '211705208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:56:13.720' ,`MLSNumber` = '62281435' ,`ListAgentFullName` = 'Art Martinez' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.784472' ,`Longitude` = '-95.432199' ,`PhotoCount` = '29' ,`PostalCode` = '77008' ,`RoomCount` = '7' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'Eureka' ,`StreetNumber` = '6622' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite home in Houston’s inner loop with easy freeway access to 610 and I10. Exceptionally well kept, updated and spacious are just a few words to describe this 2 story home with covered patio. Upon entering the quaint side gate you will find hardwood floors throughout home. The 1st floor consists of a wide entry with open floor plan to large kitchen, dining area and brightly lit living room. Kitchen features a 4 person seated island with granite countertop, stainless undermount 33\"wide sink and wine fridge. Tall trimmed upper cabinets surround island for ample storage along with the under stairway pantry. Living room is back lit with double stacking transom and single/double hung vinyl windows. Back of the home visitors will find the recently updated stamped concrete covered patio. Oversized Grande bedroom has marble topped double vanity and makeup station, garden tub and standing shower with updated tile pan and long closet with built in shoe shelves.' ,`Acres` = '0.0574' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 1 EUREKA VISTA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Eureka Vista' ,`TaxAmount` = '9876' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309059' WHERE `Matrix_Unique_ID` = '212189380' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:39:22.627' ,`MLSNumber` = '27093447' ,`ListAgentFullName` = 'Shiwei Ma' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.055140' ,`Longitude` = '-95.396783' ,`PhotoCount` = '22' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '252000.00' ,`Status` = 'Active' ,`StreetName` = 'Arica' ,`StreetNumber` = '2831' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never Flooded!!! Beautiful 2015 built contemporary corner lot home offering many custom features. Open floor plan boast of high ceilings with stunning archways, built in art niche, and recess lighting. Kitchen features 42 inch cabinets, decorative backsplash, and is open to the breakfast area. Spacious family room and a raised counter bar for extra seating. Tons of natural lighting and views of the covered patio with no back neighbors. This ideal family-friendly floor plan is a must-see, schedule your appointment today!!!' ,`Acres` = '0.0812' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 TIFFANY MEADOWS' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3539' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Tiffany Mdws' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309059' WHERE `Matrix_Unique_ID` = '212267006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:58:04.307' ,`MLSNumber` = '6501526' ,`ListAgentFullName` = 'Stacey Ruiz' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804260' ,`Longitude` = '-95.156553' ,`PhotoCount` = '45' ,`PostalCode` = '77530' ,`RoomCount` = '7' ,`ListPrice` = '249999.00' ,`Status` = 'Active' ,`StreetName` = 'Taverton' ,`StreetNumber` = '1510' ,`StreetSuffix` = 'Drive' ,`City` = 'Channelview' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2126' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this lovely 4 bedroom, 2.5 bath, 2 Car garage home in Channelview, Tx. This home has fresh new paint throughout the home. Natural bright light with an open concept floor plan for family gatherings. The counters of the eat-in-kitchen extend to the breakfast bar that opens towards the living area and cozy fireplace. When entering the second floor with fresh new carpet you find yourself with convenience to the laundry room, primary bathroom, 2 additional rooms and a game room. Is ready to make it your forever home.' ,`Acres` = '0.101' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 51 BLK 5 STERLING GREEN SEC 10 R/P' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '270' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Green Sec 10 R/P' ,`TaxAmount` = '5140' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309059' WHERE `Matrix_Unique_ID` = '212565859' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:19:15.267' ,`MLSNumber` = '59922146' ,`ListAgentFullName` = 'Rhonda Flanagan' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051354' ,`Longitude` = '-94.089132' ,`PhotoCount` = '26' ,`PostalCode` = '77705' ,`RoomCount` = '3' ,`ListPrice` = '60000.00' ,`Status` = 'Active' ,`StreetName` = 'Kenneth' ,`StreetNumber` = '3605' ,`StreetSuffix` = 'Avenue' ,`City` = 'Beaumont' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cash-only offers. Selling as is. Great investment property located in the South End of Beaumont Texas. This 2 bedroom, 1 bath, 1 car garage home appears to have a solid structure and foundation. Has been well maintained. The home has two living areas, the walk-in attic could be converted into additional living space. The rear section of the garage could be converted into a workshop. Schedule a showing today!' ,`Acres` = '0.1148' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'N1/3 LTS 1 & 2 B16 JEF CHAISON' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'PIETZSCH-MACARTHUR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Jef Chaison Add' ,`TaxAmount` = '1190' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309059' WHERE `Matrix_Unique_ID` = '212572296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:52:25.630' ,`MLSNumber` = '56591804' ,`ListAgentFullName` = 'Uriel Rodriguez' ,`ListOfficeName` = 'Realty World Elite Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003803' ,`Longitude` = '-95.172741' ,`PhotoCount` = '49' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '474500.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Glen' ,`StreetNumber` = '6906' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2933' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the desired Pinehurst of Atascocita subdivision. This well maintained home, welcomes you upon entrance with its soaring ceiling in foyer. The many features and updates will make you fall in love at first sight.\r\nHome features beautiful upgraded hardwood flooring with a large living room area, surround sound and plantation shutters throughout home. The primary retreat located in the first floor features dual vanities, separate shower, large garden tub and large walk in closet. There are 3 bedrooms upstairs, a full bathroom and a huge game room for entertainment. Backyard oasis features a custom built outdoor patio with stone flooring, heated pool and spa with inside lights that change color at night.\r\nThree car garage with built in 220volt outlet for compressor or generator usage.\r\nRefrigerator, washer and dryer not included.\r\nSchedule your appointment today and make this your forever Home!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 32 PINEHURST OF ATASCOCITA 8 AMND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Pinehurst/Atascocita Sec 8' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309059' WHERE `Matrix_Unique_ID` = '212647514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:11:16.867' ,`MLSNumber` = '64293093' ,`ListAgentFullName` = 'Ruben Hernandez' ,`ListOfficeName` = 'Apex Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805428' ,`Longitude` = '-95.789849' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '348100.00' ,`Status` = 'Active' ,`StreetName` = 'Berkshire Elm' ,`StreetNumber` = '2154' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2702' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The one you waited for all the summer is finally on the market! This Beautiful two story home is located on a large corner lot. High ceilings with open concept living. Home features,4 bedrooms,2.5 baths, two story entry & dining room. Spacious family room w/fireplace & built ins. Updated kitchen w/granite counters,stone backsplash & stainless steel appliances. Private study. Master suite on 1st floor w/garden tub,separate shower,framed mirrors & updated fixtures. Secret room hidden behind bookshelf in guest bedroom. Recently updated with fresh paint and carpet. This ons is A must see!' ,`Acres` = '0.1648' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 WILLIAMSBURG PARISH SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7178' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WINBORN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Williamsburg Parish Sec 08' ,`TaxAmount` = '6188' ,`TaxRate` = '2.6083' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309060' WHERE `Matrix_Unique_ID` = '212720195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:17:49.687' ,`MLSNumber` = '44803207' ,`ListAgentFullName` = 'Jaime Corona' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.793129' ,`Longitude` = '-95.166434' ,`PhotoCount` = '33' ,`PostalCode` = '77015' ,`RoomCount` = '9' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Duncannon' ,`StreetNumber` = '14415' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this oasis in the heart of Cloverleaf community! This Completely remodeled 4 bedroom 2 bathroom 2300 sqft home is perfect with a spacious bonus room that can be used as a study or home office! Kitchen features quartz countertops and kitchen peninsula! Large backyard oasis with private pool and lots of space for entertaining and outdoor activities. Home is within walking distance to North Shore Elementary School and Galena Park Daycare. Zoned to North Shore High School (4-minute drive). A short 3-minute drive to two shopping centers: grocery stores, restaurants, banks, pharmacies, and more! Immediate access to Beltway 8, US-90, and I-10. All large ticket items are taken care of! Brand new 4-ton HVAC, brand new roof, brand new garage doors, brand new flooring, and brand new appliances (water heater, range, dishwasher, and hood). Make your appointment today!' ,`Acres` = '0.1727' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 22 WOODFOREST SEC 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7524' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORTH SHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '4821' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309060' WHERE `Matrix_Unique_ID` = '212837655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:22:49.993' ,`MLSNumber` = '69990926' ,`ListAgentFullName` = 'Raul Limas' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.512878' ,`Longitude` = '-94.983886' ,`PhotoCount` = '46' ,`PostalCode` = '77518' ,`RoomCount` = '8' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayshore' ,`StreetNumber` = '4122' ,`StreetSuffix` = 'Drive' ,`City` = 'Bacliff' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is a wonderful opportunity to own completely remodeled 3 bedroom, 2 bath home with water views on a corner lot! You can walk to the shore one block away! All new kitchen w/soft closing cabinets and drawers. New quartz countertops! All new stainless steel appliances! All new waterproof vinyl flooring throughout! Beautifully remodeled bathrooms! Spacious utility room! There is a spacious workshop behind the two car garage that basically doubles the size of your garage. You could do a lot with this space. A brand new uniquely designed wooden privacy fence surrounds the property and the well maintained yard.' ,`Acres` = '0.1656' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 154 LOT 5 BLK 2 PERKINS BEACH SUB' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '7213' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'KENNETH E. LITTLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Perkins Beach' ,`TaxAmount` = '4976' ,`TaxRate` = '2.2342' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309060' WHERE `Matrix_Unique_ID` = '212892184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:50:50.207' ,`MLSNumber` = '78196599' ,`ListAgentFullName` = 'Roseann Johnson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Daniel Rehem' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.501111' ,`Longitude` = '-95.533820' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '575000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dewalt Way' ,`StreetNumber` = '3806' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulously cared for home with 2 primary bedrooms, one down & and one up. 2 bedrooms downstairs, both with full baths. Barn doors separate the downstairs guest bedroom for complete privacy & upstairs primary bedroom suite as well. Fresh interior paint. 3 year old roof. Hot water heaters & AC units 2021. Carpet up only. Oversized kitchen & eating area with tile floors, SS appliances, granite counters, double ovens, custom pantry. Formal dining room & designated study with wood floors & plantation shutters. Primary bedroom down has closet with built-in storage. Primary bath with double sinks, separate tub & shower. Primary bedroom up has added huge closet with built ins, vinyl plank floors. Recently Updated primary bath features huge walk- in shower. Secondary bedroom up with full bath & flex room can be used as 5th bedroom. Large stone patio & pergola cover. 3 car garage. Tree shaded lot.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Newmark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sienna Steep Bank Village blk 2 lot 7' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '13924' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '11124' ,`TaxRate` = '2.57' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309060' WHERE `Matrix_Unique_ID` = '212955522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:48:42.323' ,`MLSNumber` = '7446120' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.294584' ,`Longitude` = '-95.564546' ,`PhotoCount` = '14' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Sky Top' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1905' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 7446120 - Built by Highland Homes - January completion! ~ The Bristol features rear brick, island upgrade, built in appliances, 8 foot hollow core interior doors, pendant lighting, primary bathroom 5\' drop in tub. primary bedroom bay window, Quartz countertops in kitchen and primary bathroom. Wood look tile throughout except bedrooms.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '13/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest' ,`TaxAmount` = '' ,`TaxRate` = '2.9' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309061' WHERE `Matrix_Unique_ID` = '212997650' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:31:21.963' ,`MLSNumber` = '91337143' ,`ListAgentFullName` = 'Callee Maglothin' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806117' ,`Longitude` = '-95.549793' ,`PhotoCount` = '36' ,`PostalCode` = '77043' ,`RoomCount` = '9' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Mallard' ,`StreetNumber` = '1826' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is the epitome of classic charm meets modern updates. Enjoy a peaceful retreat from the city surrounded by trees and sidewalks while also enjoying the convenience of a short commute, walking to popular Nob Hill Park, & just minutes from several Houston favorites. If you want an updated white kitchen with a farmhouse sink, a cozy brick fireplace to enjoy as it gets cooler, an oversized backyard, the most delightfully remodeled hall bathroom, plus a bonus room for an office, then hurry to tour this home! Upgrades include Plantation shutters, PEX plumbing throughout, new Roof (2019), HVAC (2017), New Ductwork, Dual paned windows (on 90% of the home), & recessed lighting. If you want to channel your inner designer, you can put your own spin on the primary bathroom to update it however you like! Bonus - this home has an oversized mud room that was added to give plenty of storage. Enjoy open concept living, a flex room (formal dining, game room, office, etc), & 4 spacious bedrooms.' ,`Acres` = '0.2521' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 NOB HILL SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Shadow Oaks' ,`TaxAmount` = '9522' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309061' WHERE `Matrix_Unique_ID` = '213169826' --> 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','213205426','1667309061','213205426','2022-11-01T07:00:25.090','8248793','Gloria Alvarado','SES Real Estate Group, LLC','','','29.699115','-95.155582','22','77503','6','190000.00','Active','Edgefield','3811','Drive','Pasadena','2','0','3','1280','Single-Family','Bring your design ideas to this 3/2/2 home in Parkwood Estates. Conveniently located minutes away from Beltway 8 and Highway 225 for easy access to anywhere in the greater Houston area! This home has good bones and is ready for a remodel. The family room opens to the breakfast room and kitchen. The roof was replaced in 2008. Central Air and Heat, but the HVAC system needs to be repaired/replaced. Best of all, absolutely NO FLOODING during Hurricane Harvey. This home does need some work, but not extensive it has incredible potential. Call today for a private showing!','0.176','6','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Pasadena','Central Gas','0','LT 12 BLK 2 PARKWOOD ESTATES','Subdivision Lot','7665','Appraisal District','','','0','','2','','0','','','Gas Range','','Composition','41 - Pasadena','MCMASTERS ELEMENTARY SCHOOL','SAM RAYBURN HIGH SCHOOL','SANJACINTO INTERMEDIATE SCHOOL','Accompany,Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Parkwood Estates','3914','2.6514','Public Sewer,Public Water','1980','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:57:20.470' ,`MLSNumber` = '59951343' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471946' ,`Longitude` = '-95.527584' ,`PhotoCount` = '10' ,`PostalCode` = '77459' ,`RoomCount` = '4' ,`ListPrice` = '699735.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant Grove' ,`StreetNumber` = '1910' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 59951343 - Built by Highland Homes - January completion! ~ Stunning brand new floor plan w/ 21\' ceiling heights in kitchen and dining areas. Double door entry w/ open concept throughout. Sliding glass door at family w/ corner fireplace and an abundance of natural light. Custom built in Cabinet/Hutch in open dining area w/ gorgeous chandelier. Design upgrades galore. No back neighbors with room for a pool. A must see!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '25/1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '8315' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309061' WHERE `Matrix_Unique_ID` = '213272571' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:50:41.547' ,`MLSNumber` = '57201947' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.641640' ,`Longitude` = '-95.758467' ,`PhotoCount` = '17' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '341990.00' ,`Status` = 'Active' ,`StreetName` = 'Hughes Meadow' ,`StreetNumber` = '3438' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1523' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Baths, Study, Kitchen, Breakfast and Family Room, Dual Vanities in Primary Bath with Garden Tub and Separate Shower, Study with French Doors, Granite Kitchen Countertops, 42” Upper Kitchen Cabinets, Recessed Can Lights in Kitchen, 3”x6” Herringbone Kitchen Backsplash, Upgraded Plumbing Fixtures, Upgraded Carpet and Pad, Luxury Vinyl Plank Flooring in Entry, Kitchen, Breakfast, Utility, Family Room, Hallways and all Baths 2” Window Covers, Full Gutters, Garage Door Opener, Covered Back Patio plus more…AVAILABLE NOVEMBER.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 26 BLK 1 SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6409' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'McCrary Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309061' WHERE `Matrix_Unique_ID` = '213315155' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:24:44.033' ,`MLSNumber` = '8839890' ,`ListAgentFullName` = 'Jennifer Leteff' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.294714' ,`Longitude` = '-95.412343' ,`PhotoCount` = '26' ,`PostalCode` = '77301' ,`RoomCount` = '10' ,`ListPrice` = '286000.00' ,`Status` = 'Active' ,`StreetName` = 'Tulip Poplar' ,`StreetNumber` = '3017' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1977' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2-story home located in the neighborhood of Barton Creek Ranch. This home features 4 bedrooms, all of which are located upstairs. There are 2 bathrooms upstairs and a half bath downstairs for your guests. Beautiful Wood Look Tile flooring in the kitchen and entryway, upgraded Granite Countertops and GE appliances. Fridge, Washer and Dryer to stay with the home. Primary bath contains dual vanity, his and her closets, separate tub and shower. Covered back patio and fenced in back yard for your pets and gatherings. This home is located on a quiet cul-de-sac street. Conveniently located near shopping, parks and schools, and provides easy access to I-45, Loop 336 and SH 105. Schedule a showing today and make this house your new HOME!' ,`Acres` = '0.1457' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S249600 - BARTON CREEK RANCH 01, BLOCK 2, LOT 26' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barton Creek Ranch' ,`TaxAmount` = '5667' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309061' WHERE `Matrix_Unique_ID` = '213320483' --> 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','213371538','1667309062','213371538','2022-11-01T06:06:54.677','50716798','Cynthia Ramos','JLA Realty','','','29.722821','-94.994005','36','77520','4','240000.00','Active','Durrain Ferry','1916','Road','Baytown','2','1','2','1794','Single-Family','A rare opportunity presents itself with this home. It is full of charm and character. Well-maintained with a cozy feel, this home sits on an acre of land. Feel closer to nature in the large yard with huge trees and garden space! The covered front porch across the front of the house perfect for relaxing. Outdoor features include an outdoor kitchen, a covered patio, a spacious seating area, two storage sheds, and a covered car port. There is also a patio tucked behind the home, perfect for morning coffee. Inside is equipped with a separated breakfast and formal dining area. In total, it has 2 bedrooms, 2.5 baths, and a laundry room. Primary bedroom and bathroom are downstairs. As an added bonus, all of the appliances (microwave excluded) will stay with the house! At this property you are minutes away from a community park with a splash pad, basketball court, and walking trail! \r\nThis Show Stopper is priced to sell! Schedule a viewing today!','1.0081','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Baytown/Harris County','Central Electric','0','TR 6A ABST 66 W SCOTT','Cleared','43913','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','23 - Goose Creek Consolidated','SAN JACINTO ELEMENTARY SCHOOL (GOOSE CREEK)','LEE HIGH SCHOOL (GOOSE CREEK)','BAYTOWN JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Scott Wm Upper League','3234','2.97','Public Water','1929','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:47:39.643' ,`MLSNumber` = '42332126' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470059' ,`Longitude` = '-95.463666' ,`PhotoCount` = '15' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '269990.00' ,`Status` = 'Active' ,`StreetName` = 'Robert Lane' ,`StreetNumber` = '7718' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Bellvue Plan with Elevation N, features a modern design and offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!\r\nListing photos are of a similar floor plan. Finishes may vary and are subject to change.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. Horton, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309062' WHERE `Matrix_Unique_ID` = '213372718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:57:54.353' ,`MLSNumber` = '81321287' ,`ListAgentFullName` = 'Shelli Underwood' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = 'Monica Caldwell' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.054514' ,`Longitude` = '-95.166116' ,`PhotoCount` = '34' ,`PostalCode` = '77345' ,`RoomCount` = '11' ,`ListPrice` = '425000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sycamore Villas' ,`StreetNumber` = '5307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3069' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller!! Welcome to this magnificent home located in the highly sought after Sand Creek Village in Kingwood. This fabulous custom (Marilyn O’Conner) home has been meticulously maintained and it shows from the moment you arrive. Featuring a wonderful layout with a tiled family room opening to the dining room with wood floors and tiled kitchen and breakfast area with large upgraded windows. The kitchen has huge island and granite counters with under counter lighting The primary bedroom is located on the first floor with large en-suite with double sinks, whirlpool tub and separate shower with two vanity areas and two walk in closets. You will love working from home in the attached office with French doors and vaulted ceilings with great views of the back yard and access to the covered patio. Gameroom upstairs and three bedoroms with walk in closets with one full bath and one Hollywood bath. Plantation shutters in den and dining room. Plenty of room for a pool!!!' ,`Acres` = '0.24' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 3 SAND CREEK VILLAGE SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10455' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'DEERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sand Creek Village Sec 02 R/P' ,`TaxAmount` = '8223' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309062' WHERE `Matrix_Unique_ID` = '213562577' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:21:54.677' ,`MLSNumber` = '91795902' ,`ListAgentFullName` = 'Sarah Lernor' ,`ListOfficeName` = 'Realvest Services, LLC' ,`SellingAgentFullName` = 'Erika Hernandez' ,`SellingOfficeName` = 'HOUSTON TOP REALTY' ,`Latitude` = '29.536878' ,`Longitude` = '-95.298739' ,`PhotoCount` = '30' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '294900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Spring Garden' ,`StreetNumber` = '3907' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well-maintained two-story home right in the heart of Pearland zoned to beloved Magnolia Elementary! This family friendly neighborhood, currently decked out for Halloween, is walking distance to Centennial Park and a short bike ride from the Pearland Rec Center, Natatorium, Turner High School and more. The large secondary room has its own half bathroom and plenty of closet/storage space and even a secret reading nook for kids to enjoy! Kitchen updates include granite countertops and glass backsplash, and let\'s not forget about the office tucked away off of the kitchen. Large backyard with mature trees provides plenty of room to play and entertain! Don\'t miss out on this must-see!' ,`Acres` = '0.1623' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SPRINGFIELD (PEARLAND) (A0509 H T & B) BLK 5 LOT 3 (REPLAT)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '135' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Springfield Pearland' ,`TaxAmount` = '5773' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309062' WHERE `Matrix_Unique_ID` = '213584686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:19:53.173' ,`MLSNumber` = '40195347' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732290' ,`Longitude` = '-95.317896' ,`PhotoCount` = '15' ,`PostalCode` = '77023' ,`RoomCount` = '2' ,`ListPrice` = '284000.00' ,`Status` = 'Active' ,`StreetName` = 'Hughes' ,`StreetNumber` = '1308' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nicely updated and tenant occupied single family property in developing East End Revitalized. Single-family home offers two bed one bath. This property has been thoughtfully updated for easy rental maintenance. This is one of several properties available making up a combined 19,000+ sq ft of land in the popular East End Revitalized. (See MLS #’s 3389831 and 32285320 for full portfolio). Rent rolls are available upon request. **This property must be bought with 1302 Hughes and 5444 Clay**' ,`Acres` = '0.1936' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 14 & 15 BLK 4 DISSEN HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8433' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CARRILLO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Spanish' ,`Subdivision` = 'Dissen Heights' ,`TaxAmount` = '3871' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309062' WHERE `Matrix_Unique_ID` = '213594765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:17:53.383' ,`MLSNumber` = '78226996' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781525' ,`Longitude` = '-95.320382' ,`PhotoCount` = '12' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '112500.00' ,`Status` = 'Active' ,`StreetName` = 'Gagne' ,`StreetNumber` = '2311' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.031' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S 27.00 FT OF LT 5 & S 27.00 FT OF E 1/2 OF LT 4 BLK 30 GAGN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1350' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '704' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309063' WHERE `Matrix_Unique_ID` = '213595374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:17:16.553' ,`MLSNumber` = '76944032' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781522' ,`Longitude` = '-95.320938' ,`PhotoCount` = '13' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Solo' ,`StreetNumber` = '2310' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This cozy Gagne Homestead home with a land square footage of 1,739 is superbly nestled in the heart of Houston. Within walking distance to Atherton Elementary school and Boyce Dorian Park. This two bedroom / one bathroom single family home features new flooring throughout, freshly painted walls and refurbished bathrooms.' ,`Acres` = '0.0399' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S 34.78 FT OF LT 1 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1739' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '2398' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309063' WHERE `Matrix_Unique_ID` = '213595686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:27:02.247' ,`MLSNumber` = '59150396' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781639' ,`Longitude` = '-95.320760' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4908' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'E 1/2 OF LT 2 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '913' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309063' WHERE `Matrix_Unique_ID` = '213595969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:27:53.820' ,`MLSNumber` = '78090016' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781630' ,`Longitude` = '-95.320668' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4910' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 3 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '902' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309063' WHERE `Matrix_Unique_ID` = '213596457' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:28:52.010' ,`MLSNumber` = '59036141' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781627' ,`Longitude` = '-95.320598' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4912' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'E 1/2 OF LT 3 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead' ,`TaxAmount` = '902' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309063' WHERE `Matrix_Unique_ID` = '213596769' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:29:38.760' ,`MLSNumber` = '55545590' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781647' ,`Longitude` = '-95.320520' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4914' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 4 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '1040' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309064' WHERE `Matrix_Unique_ID` = '213597048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:22:38.080' ,`MLSNumber` = '14585174' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781646' ,`Longitude` = '-95.320996' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4902' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0374' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF N 65.22 FT OF LT 1 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '2909' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309064' WHERE `Matrix_Unique_ID` = '213597576' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:33:33.540' ,`MLSNumber` = '97615941' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781663' ,`Longitude` = '-95.320263' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4920' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0419' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'E 1/2 OF N 73.00 FT OF LT 5 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '850' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309064' WHERE `Matrix_Unique_ID` = '213597835' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:32:34.900' ,`MLSNumber` = '54315969' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781643' ,`Longitude` = '-95.320379' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4918' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0419' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF N 73.00 FT OF LT 5 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '886' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309064' WHERE `Matrix_Unique_ID` = '213598177' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:24:22.053' ,`MLSNumber` = '16059724' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781649' ,`Longitude` = '-95.320904' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4904' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0367' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'E 1/2 OF N 65.22 FT OF LT 1 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '703' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309064' WHERE `Matrix_Unique_ID` = '213598449' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:26:11.657' ,`MLSNumber` = '22902868' ,`ListAgentFullName` = 'Michael Silva' ,`ListOfficeName` = 'Happen Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781647' ,`Longitude` = '-95.320831' ,`PhotoCount` = '15' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Lee' ,`StreetNumber` = '4906' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming two-bedroom, one-bath home currently being used as an income-producing rental property. This is one of several properties available making up a combined 20,000+ sq ft of land in popular Denver Harbor. Property is ideal to buy now, cash flow, and redevelop later.' ,`Acres` = '0.0574' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 2 BLK 30 GAGNE HOMESTEAD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gagne Homestead Add' ,`TaxAmount` = '1040' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer,Water District' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309065' WHERE `Matrix_Unique_ID` = '213598689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:10:55.460' ,`MLSNumber` = '49507559' ,`ListAgentFullName` = 'Margaret King' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'William Valdez' ,`SellingOfficeName` = 'RE/MAX 5 Star Realty' ,`Latitude` = '29.760113' ,`Longitude` = '-95.272414' ,`PhotoCount` = '10' ,`PostalCode` = '77029' ,`RoomCount` = '8' ,`ListPrice` = '145000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Guinevere' ,`StreetNumber` = '8602' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2006' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large beautiful corner lot, oversize garage, accommodating extra storage shed, extra parking in front of garage and extra parking in front of home. Well established, quiet neighborhood. Judson Robinson Sr. Community Center 1422 Ledwicke Street in the middle of neighborhood as well as Pleasantville Neighborhood Library 1520 Gellhorn Dr. 832-395-7320, Also outside recreational area. \r\nhttp://houstonlibrary.org>pleasantville\r\njudsonrobinsonsr@houstontx.gov' ,`Acres` = '0.2122' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 102 BLK 6 PLEASANT VIEW SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '9243' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PLEASANTVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pleasant View Sec 02' ,`TaxAmount` = '2244' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309065' WHERE `Matrix_Unique_ID` = '213644890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:51:19.677' ,`MLSNumber` = '31085098' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.211668' ,`Longitude` = '-95.344061' ,`PhotoCount` = '28' ,`PostalCode` = '77302' ,`RoomCount` = '8' ,`ListPrice` = '508849.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Robin' ,`StreetNumber` = '17196' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 31085098 - Built by Highland Homes - Ready now! ~ Our popular Newport Plan on a corner lot. This one story home has a study, 4 bedrooms, and entertainment room off the kitchen and sliding glass doors! Great island kitchen with lots of cabinets with quartz countertops. Extended outdoor living, primary bedroom bay window, and powder bath option. Must see!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S216907 - Artavia 07, BLOCK 3, Lot 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8758' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309065' WHERE `Matrix_Unique_ID` = '213660925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:18:26.843' ,`MLSNumber` = '36430191' ,`ListAgentFullName` = 'Anisa Hoxha' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801453' ,`Longitude` = '-95.554534' ,`PhotoCount` = '50' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Haddington' ,`StreetNumber` = '10410' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2069' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully fully remodeled home located in the sought-after neighborhood of Shadow Oaks features charm, character, and many updates! The updates include fresh new exterior paint, custom kitchen cabinetry, updated bathrooms, raised ceilings, tile flooring and so much more. Throughout the home, you will find beautiful wood-look tile flooring as well as double pane windows offering sunlight and a gorgeous view of the backyard garden. The garden truly is one of a kind and a must-see!! The primary suite is as big as you will find in any home! Only minutes away from I-10, Memorial Mall, Town & Country City Center and the Energy Corridor makes this home a trendy and convenient location. Schedule your appointment today! \r\nOWNERS WILL CONVERT THE BACKYARD BACK TO SOD UPON REQUEST' ,`Acres` = '0.2009' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 14 SHADOW OAKS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Oaks Sec 05' ,`TaxAmount` = '9736' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667309065' WHERE `Matrix_Unique_ID` = '213671863' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:45:13.130' ,`MLSNumber` = '21313363' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.443821' ,`Longitude` = '-95.398077' ,`PhotoCount` = '25' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Wright' ,`StreetNumber` = '9634' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 21313363 - Built by Highland Homes - Ready Now! ~ Located in our gated section! Tall ceilings & natural light welcome you into the home. Create memories in the dream kitchen, with a large quartz island that friends & family can gather around. Enjoy cooking with the built-in stainless steel appliances (includes pot filler). Set up a home office in the study. Entertainment room is the perfect place to host a movie or game night! The SLIDING glass doors in the family room can be opened to host indoor/outdoor parties in your own backyard oasis with an oversized backyard (can fit a pool!). Open family and dining area makes this home feel grand. Primary suite includes luxurious FREESTANDING tub in the master bath and large walk-in closet! Full sprinkler system & smart home features included! On-site schools in the community. Walking distance to amenities- cafe, 24hr fitness center, resort style pool & more! Make an appointment today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 45 (A0282 & A0286) (MANVEL) BLK 1 LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9614' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309066' WHERE `Matrix_Unique_ID` = '213749168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:27:32.413' ,`MLSNumber` = '39378351' ,`ListAgentFullName` = 'Elisa Maceda' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.648572' ,`Longitude` = '-95.339073' ,`PhotoCount` = '23' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '209900.00' ,`Status` = 'Active' ,`StreetName` = 'Groveton' ,`StreetNumber` = '5606' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY, SINGLE STORY HOME COMPLETELY RENOVATED!\r\nImmaculate 3 bedrooms 1 bath home with a huge fully fenced backyard. Beautiful original wood floors in living area and rooms helps keep the character of the home. Beyond the entryway the home opens to a luminous, open-concept living, dining and kitchen area. A redesigned kitchen with elegant white quartz countertops, all new appliances and plenty of storage. New exterior siding with updated insulation. A remodeled bathroom including quality hardware, modern title, and two niches for all toiletries. All windows (Energy Star), doors, ceiling fans, and led lighting are brand new! Interior and exterior painting was recently completed. The large front porch is great for morning coffee and would be perfect for a porch swing. Updated electrical, central air and heat, and foundation. Convenient covered back patio perfect for entertaining.\r\nCall your agent to schedule a showing of this beautiful home before it\'s gone!' ,`Acres` = '0.157' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 7 CRESTMONT SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6840' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MADING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Crestmont Add Sec 02' ,`TaxAmount` = '2064' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309066' WHERE `Matrix_Unique_ID` = '213774834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:58:21.683' ,`MLSNumber` = '36608034' ,`ListAgentFullName` = 'Colby Hebert' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688803' ,`Longitude` = '-95.928883' ,`PhotoCount` = '39' ,`PostalCode` = '77441' ,`RoomCount` = '9' ,`ListPrice` = '670000.00' ,`Status` = 'Active' ,`StreetName` = 'Verdant Creek' ,`StreetNumber` = '30115' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 30115 Verdant Creek in the highly sought after Fulbrook on Fulshear Creek. With over 3,800 sq ft. of living, this beautiful home doesn’t disappoint. This is a 5 bedroom, 4.5 bath 2 story home that has not one, but two bedrooms down, including the primary bedroom. Downstairs, you’ll also find an office and a game room, along with an open concept floor plan great for entertaining. Upstairs is where you’ll find three secondary bedrooms, along with a spacious media room where everyone can enjoy their favorite movie together on a Friday night. Take the kids to the park, get an early workout in at the community fitness center, or relax in the sun by the resort style pool that overlooks Huggins Lake. This community has something for everyone, and being only minutes away from many retail and restaurant options, you just couldn\'t ask for more. Schedule a showing today!' ,`Acres` = '0.2011' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FULBROOK ON FULSHEAR CREEK SEC 4, BLOCK 2, LOT 20' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8762' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fulbrook On Fulshear Creek Sec 4' ,`TaxAmount` = '12781' ,`TaxRate` = '2.9978' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309066' WHERE `Matrix_Unique_ID` = '213778815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:47:33.350' ,`MLSNumber` = '58776002' ,`ListAgentFullName` = 'Kate Johnson' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.019148' ,`Longitude` = '-95.569238' ,`PhotoCount` = '33' ,`PostalCode` = '77070' ,`RoomCount` = '6' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Baronshire' ,`StreetNumber` = '17514' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully landscaped one-story home located on a cu- de-sac in Memorial Chase! This home features 3 bedrooms, 2 baths with a split floor plan just waiting for your personal updates. The large family room has high ceilings and an attractive wood burning fireplace. There is a separate dining room with a breakfast bar to the kitchen. The back yard is fenced with a covered patio and includes a storage building plus a custom frame and cover for a porch swing to enjoy your outdoor space. A brand-new architectural shingle roof and double pane windows throughout the home. Excellent location, close to 249, Vintage Park, Grand Parkway, shopping and dining. Zoned to the sought-after Klein ISD! Don’t miss this one, call to schedule your private tour today!' ,`Acres` = '0.2178' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 10 017*M1875900-003-010-026 MEMORIAL CHASE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9487' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KRAHN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Chase Sec 03' ,`TaxAmount` = '4417' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309066' WHERE `Matrix_Unique_ID` = '213779127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:03:40.900' ,`MLSNumber` = '21249532' ,`ListAgentFullName` = 'Nancy Gonzalez' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886542' ,`Longitude` = '-95.436535' ,`PhotoCount` = '13' ,`PostalCode` = '77088' ,`RoomCount` = '5' ,`ListPrice` = '349999.00' ,`Status` = 'Active' ,`StreetName` = 'Deerhurst' ,`StreetNumber` = '2138' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 4 Bed/2.5 open floor plan home. The Kitchen features a pot filler, a large island, and stainless steel appliances. The master bath includes a Hollywood-style bath with standing shower, double sink vanities, and a walk-in closet. There is recessed LED lighting throughout the entire house and double-pane windows! You can enjoy a backyard bbq on your covered patio. Don\'t miss out on this custom home & call to schedule a viewing today!' ,`Acres` = '0.148' ,`Area` = '11' ,`BuilderName` = 'Southern Legacy Home' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 887 BLK 27 HEATHER GLEN SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'HILL ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Heather Glen' ,`TaxAmount` = '770' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309066' WHERE `Matrix_Unique_ID` = '213886509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:03:58.913' ,`MLSNumber` = '70369420' ,`ListAgentFullName` = 'Lawrence Whiteing' ,`ListOfficeName` = 'Westside Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.785595' ,`Longitude` = '-95.176290' ,`PhotoCount` = '22' ,`PostalCode` = '77015' ,`RoomCount` = '5' ,`ListPrice` = '139500.00' ,`Status` = 'Active' ,`StreetName` = 'Frankie' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Total renovation home with upgraded kitchen with granite countertops with new cabinets, upgraded bathroom, laminated flooring, with patio cover. huge fenced yard with a nice size storage building, new exterior HVAC, and new water heater' ,`Acres` = '0.241' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 2O & 22 BLK 183 CLOVER LEAF SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'NORTH SHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Clover Leaf Sec 03' ,`TaxAmount` = '2374' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309067' WHERE `Matrix_Unique_ID` = '213908310' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:46:08.990' ,`MLSNumber` = '10870979' ,`ListAgentFullName` = 'Janice Dupuy-Green' ,`ListOfficeName` = 'Green\'s Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218752' ,`Longitude` = '-95.519677' ,`PhotoCount` = '50' ,`PostalCode` = '77382' ,`RoomCount` = '12' ,`ListPrice` = '499950.00' ,`Status` = 'Active' ,`StreetName` = 'Alden Glen' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2697' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular 2-Story Stucco home (4 / 3-1/2 / 2) situated on a wooded cul-de-sac lot and beautiful back yard, with a park like feel. Open Floor Plan. Highlighted by dramatic 2 story formal areas. Also, less than a block from a playground area for children. Roof was replaced in the past couple of years. In the past 2 months the hot water heater was replaced, additional insulation in attic, and updated Wi-Fi Rachio Smart sprinkler system. Never flooded. Bedroom & Bath down for guest, study, or mother-in-law suite, all other Bedrooms Up. Spacious primary bedroom retreat (approx. 17\' X 12\") with an added sitting area (approx. 11\' X 9\') and a 3-sided fireplace, and a spacious on-suite with Jacuzzi tub. Game room up. Plantation Shutters in up stairs windows. 2 Fireplaces - gas logs in downstairs fireplace. Extra area for workspace in 2 car garage. Refrigerator and Washer/Dryer to stay. A MUST SEE!!' ,`Acres` = '0.2151' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL OF ALDEN BR 20, BLOCK 1, LOT 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '9369' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 20' ,`TaxAmount` = '7938' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309067' WHERE `Matrix_Unique_ID` = '213913839' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:53:08.020' ,`MLSNumber` = '7049119' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813914' ,`Longitude` = '-95.845877' ,`PhotoCount` = '7' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'Lantana Trail' ,`StreetNumber` = '3042' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 7049119 - Built by Highland Homes - December completion! ~ Huge lot on a cul-de-sac, extended primary suite, spacious game and closed entertainment room for entertaining and beautiful wooden stairs. Enhanced kitchen and outdoor living.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '32/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8891' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667309067' WHERE `Matrix_Unique_ID` = '213915791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:03:06.050' ,`MLSNumber` = '33036346' ,`ListAgentFullName` = 'Joshua Adkins' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = 'David Gutierrez' ,`SellingOfficeName` = 'Prime Realty Group' ,`Latitude` = '29.502309' ,`Longitude` = '-95.151495' ,`PhotoCount` = '43' ,`PostalCode` = '77546' ,`RoomCount` = '13' ,`ListPrice` = '530000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Deer Valley' ,`StreetNumber` = '1102' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Christmas in your new home!\r\nThis home has 33 Solar Panels and an EV Charging Station in the 3-car tandem garage. It was built in 2015 and features 4 bedrooms and 3.5 bathrooms. All new carpet and paint throughout the house as of October 2022! Downstairs features an open concept with an oversized breakfast room, spacious kitchen/living room, and a beautiful fireplace. The are two chandeliers you\'ll fall in love with every time you come home. Upstairs has 3 bedrooms, media room, theatre room set up for surround sound, and a Jack and Jill bathroom. All rooms have RJ45 connections for the option to hard wire your internet. Besides the beautiful curb appeal outside, this home sits on a huge lot, no back neighbors, cul-de-sac, has an outdoor kitchen, carver stone patio/walkways, therapeutic swimming spa w/wood deck, a water fountain area to relax at, storage shed, greenhouse, and plenty of extra concrete space to mingle with friends/family. Lots of fruit trees - you\'ll never starve. Ever.' ,`Acres` = '0.3328' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas,Solar Assisted' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 1 AUTUMN LAKES SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14495' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LANDOLT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Autumn Lakes' ,`TaxAmount` = '9102' ,`TaxRate` = '2.2316' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309067' WHERE `Matrix_Unique_ID` = '213918096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:41:36.770' ,`MLSNumber` = '40424282' ,`ListAgentFullName` = 'Tiffani Reynolds' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814845' ,`Longitude` = '-95.765240' ,`PhotoCount` = '27' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Williamschase' ,`StreetNumber` = '22627' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home boasts a huge over-sized backyard perfect for outdoor play and entertainment and is located minutes from Grand Parkway 99 and I-10, right near the front of the neighborhood. Take a short 3-minute walk and enjoy the community playground and pool or continue walking towards nearby close and convenient shopping areas. Inside you’ll find 3 bedrooms, 2 and a half bathrooms, NEW CARPET, and a flex room that can serve as a game room, study, or secondary living room. The large living area offers tons of space to spread out and flows right into the kitchen. Expansive granite countertops are great for cooking large meals and entertaining your guests. Head out to the oversized backyard and enjoy the shade year-round. This one is ready for move-in and zoned to the desirable Katy ISD. Schedule your showing today!' ,`Acres` = '0.2169' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 64 BLK 3 WILLIAMSCHASE SEC 1 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '468' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WINBORN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Williamschase' ,`TaxAmount` = '4951' ,`TaxRate` = '2.4333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309068' WHERE `Matrix_Unique_ID` = '213939404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:30:26.120' ,`MLSNumber` = '76057164' ,`ListAgentFullName` = 'Daniel Tatman' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973418' ,`Longitude` = '-95.482159' ,`PhotoCount` = '32' ,`PostalCode` = '77014' ,`RoomCount` = '8' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Peachfield' ,`StreetNumber` = '13402' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT OPPORTUNITY IN AN ESTABLISHED NEIGHBORHOOD. THIS 3 BEDROOM 2 BATHROOM HOME SITS ON A LARGE CORNER LOT WITH MATURE TREES. LIVING ROOM AND DINING ROOM BOTH FEATURE VAULTED CEILINGS AND FIREPLACE. FLEX SPACE/ FORMAL LIVING IS OFF THE ENTRY. GRANITE COUNTERTOPS IN THE KITCHEN AND A LARGE BREAKFAST AREA. NICE PATIO AREA FOR YOUR ENTERTAINING NEEDS! BLACK STAINLESS STEEL FRIDGE STAYS. NEWER A/C UNIT, NO CARPET THROUGHOUT, LED LIGHTS, CLOSE TO SCHOOLS, BELTWAY 8, HIGHWAY 45 AND AIRPORT' ,`Acres` = '0.1711' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 53 BLK 6 SABLERIDGE SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7452' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BENEKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sableridge Sec 01' ,`TaxAmount` = '4430' ,`TaxRate` = '2.8817' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309068' WHERE `Matrix_Unique_ID` = '213941987' --> 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','213987426','1667309068','213987426','2022-11-01T07:45:53.640','25105720','Carol Marple','BHGRE Gary Greene','','','29.984686','-95.186895','46','77346','12','415000.00','Active','Enchanted Rock','18231','Trail','Humble','3','1','5','3262','Single-Family','This Stunning Brick & Stone Coventry Home located in the amenity-rich master planned community of Eagle Springs and zoned to FANTASTIC SCHOOLS! Home features gorgeous entry with dual staircase, study with built-ins, formal dining room, hard surface flooring, island kitchen with granite counters and gas cooktop, family room with soaring ceilings and gas log fireplace, primary retreat with en suite bath with granite counters, dual vanity, whirlpool tub, separate shower, and walk in closet! Upstairs has an expansive game room and four secondary bedrooms with two full baths! Spacious back yard with plenty of room for a pool! Community amenities include competition and resort style pools, splash pad, 24 hr fitness center, baseball and soccer fields, tennis and sand volleyball courts, many parks and events planned by the full time event coordinator! This is the perfect home to raise your family and entertain friends! Come see it today!','0.2265','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Atascocita South','Central Gas','1','LT 3 BLK 2 EAGLE SPRINGS SEC 5','Corner,Subdivision Lot','9866','Appraisal District','','900','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','29 - Humble','EAGLE SPRINGS ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','TIMBERWOOD MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Eagle Springs','8875','2.9726','Water District','2004','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','214025298','1667309068','214025298','2022-11-01T07:10:51.690','43326659','Toyia Chenevert','Re/MAX Universal','','','29.941619','-95.201368','42','77346','5','359900.00','Active','Bedford Bend','12431','Drive','Humble','2','0','3','2048','Single-Family','This beautiful, well maintained 3 bedroom 2 bath smart home with study has an astonishing open concept. You are greeted by high ceilings & a large foyer that leads you directly to the the family room with a wall of windows inviting in tons of natural light. The gourmet kitchen boasts sleek quartz countertops, tile backsplash, modern appliance suite, large island, and tons of cabinet space for storage. You can relax in your grand Primary retreat w/an ensuite featuring double vanities, cultured marble countertops, massive shower & dress to impress in the spacious closet. Relax under the covered patio & watch the sunset or entertain family & friends. This award winning Balmoral community has the first man-made, Crystal Clear lagoon in Texas surrounded by white sand beaches and lush landscaping. Not to mention the beach club, restaurant, an array of parks, walking trails & easy access to major airports & highways. Create new memories in this move-in ready beauty!','0.1463','1','','','Washer Connections','','Mud,Sellers Disclosure','1','','','Summerwood/Lakeshore','Central Gas','1','LT 14 BLK 5 BALMORAL SEC 23','Subdivision Lot','6375','Appraisal District','','980','0','','2','Gas Oven,Single Oven','0','','','Freestanding Range','','Composition','29 - Humble','RIDGE CREEK ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','AUTUMN RIDGE MIDDLE SCHOOL','Accompany,Leave Business Card,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Balmoral Sec 23','1163','2.9873','Water District','2021','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:37:46.097' ,`MLSNumber` = '38779975' ,`ListAgentFullName` = 'Maggie Pearson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571811' ,`Longitude` = '-95.023002' ,`PhotoCount` = '42' ,`PostalCode` = '77586' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Lori' ,`StreetNumber` = '1913' ,`StreetSuffix` = 'Court' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulously kept home in the charming city of Seabrook. Upon entry you are greeted by a formal living area which leads through French doors into the main living room. New carpet downstairs throughout all public areas and the staircase. Elegant remodeled Kitchen and breakfast nook open to the living room. Upstairs you will find 4 bedrooms and an oversized game room. Recent updates include water heater, AC, and appliances. Washer/dryer/refrigerator to remain with the home. Outside you will find a large storage shed/workshop with a new roof. Pool sized backyard and located on a cul de sac street. Seabrook trails, the public library, elementary and middle schools all within walking distance to the home! This home is ready for a new family, the only thing missing is you! *** NEVER FLOODED***' ,`Acres` = '0.1641' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 32 BLK 1 HARBOUR COVE ESTATES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '241' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbour Cove Estates' ,`TaxAmount` = '5397' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309068' WHERE `Matrix_Unique_ID` = '214025665' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:44:56.017' ,`MLSNumber` = '8590718' ,`ListAgentFullName` = 'Christine Richards' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = 'Patina Ganther' ,`SellingOfficeName` = 'Texas United Realty' ,`Latitude` = '29.875159' ,`Longitude` = '-95.636571' ,`PhotoCount` = '19' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '255000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Possumwood' ,`StreetNumber` = '15202' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE find in MAPLE TRACE! Don\'t miss this 1 story, 3 bedroom GEM located on a quiet CUL-DE-SAC with a HUGE backyard and NO IMMEDIATE REAR NEIGHBORS! Open floor plan featuring Family Room with wood flooring; spacious Kitchen with an abundance of cabinetry & countertop space; large Primary Bedroom with WALK-IN CUSTOM CLOSET; Primary bath with linen closet and double sinks! HUGE backyard with patio stretching across back of home (with built-in seating!) and NO immediate rear neighbors! UPDATES INCLUDE: flooring in baths/carpet in bedrooms/paint (2022), back patio (2018), fence (2017), roof/custom closet/water heater (2016), & more! Convenient access to I10, BW8, HWY 6, & 290! Highly rated Cy-Fair schools and LOW property tax rate!' ,`Acres` = '0.1841' ,`Area` = '8' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 4 MAPLE TRACE SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8019' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maple Trace Sec 01' ,`TaxAmount` = '4825' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309068' WHERE `Matrix_Unique_ID` = '214044609' --> 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','214066838','1667309068','214066838','2022-11-01T06:19:53.700','88444824','Dick Richards','Coldwell Banker RealtyREALTORS','','','30.389028','-95.610241','37','77356','7','329000.00','Active','Fitzgerald','3103','','Montgomery','2','0','3','1752','Single-Family','Beautiful one story house with three bedrooms and two bathrooms. Arched doorways throughout. Updated fixtures. Engineered wood floor and tile. Granite counter tops. Stainless steel appliances. Breakfast room with window seat. Tile backsplash. 5 inch baseboards throughout the house. High ceilings in entry way and living room.Dental molding in primary bedroom and primary bathroom. New walk-in Jacuzzi tub. Dining room with chair rail. 2 ceiling fans/lights on back porch. Freshly painted outside. Decorative lights by the garage. Walden on Lake Conroe golf course nearby. Montgomery ISD.','','39','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Lake Conroe Area','Central Electric','1','BLOCK 33 LOT 33','In Golf Course Community,Subdivision Lot','7473','Appraisal District','','1050','0','','2','Electric Oven,Single Oven','0','','','Electric Cooktop,Freestanding Range','','Composition','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','WALDEN','5699','2.1','Public Sewer,Water District','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:53:12.213' ,`MLSNumber` = '77342065' ,`ListAgentFullName` = 'Jaime McLaughlin' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884241' ,`Longitude` = '-95.627912' ,`PhotoCount` = '31' ,`PostalCode` = '77095' ,`RoomCount` = '7' ,`ListPrice` = '298500.00' ,`Status` = 'Active' ,`StreetName` = 'Hearthstone Green' ,`StreetNumber` = '7334' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable custom 1-story home nestled in the quaint golf course community of Hearthstone! Home sits on a cul-de-sac providing views of the course! Spacious, clean and lots of updates! Dishwasher/Fridge (2022), Brick Restoration grout work & exterior paint (2022), electric panel (2020), Window World windows & roof (2016), 4 ton- 16 seer with UV light and medial filter (2022) and CHECK OUT the covered patio area added in 2020!! Perfect spot for your morning coffee or relaxing on those cool Fall nights! Hearthstone offers mature trees, park, pool, tennis courts, golf and lots of entertainment throughout the year! Inquire about membership information & dues.' ,`Acres` = '0.1508' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 1 HEARTHSTONE GREEN SEC 1' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '6570' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'OWENS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hearthstone Green Sec 01' ,`TaxAmount` = '5140' ,`TaxRate` = '2.501' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309069' WHERE `Matrix_Unique_ID` = '214073733' --> 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','214093686','1667309069','214093686','2022-11-01T07:58:38.813','81405670','Christy Dragotta','Keller Williams Realty','','','30.658090','-96.353790','22','77802','6','262500.00','Active','Garden','1313','Lane','Bryan','2','0','4','1825','Single-Family','This is THE ONE!! Prime location - just minutes away from Blinn! There is so much value here! 4 beds/2 baths ~ 2 bedrooms up and 2 bedrooms down makes for a great layout that lends itself to plenty of privacy. Located on a large, quiet lot in North Manor with covered front patio. No carpet in the house - so keeping the floors clean is a breeze! Tankless water heater and recently replaced A/C and roof ~ all updated in the last few years! Notice the updated luxury plank flooring, recently remodeled bathrooms and nice high ceilings. The rooms are generously sized with great closet space! The kitchen has granite countertops, a gas range and a nice deep sink. You\'ll fall in love the fantastic back yard - fully fenced and the storage shed will convey. Oversized driveway accommodates up to 6 vehicles easily so it\'s the perfect home for entertaining! To top it off, lease in place through 7/2023 at $2400 per month (bills included)! This is an incredible income producing property!','0.1521','61','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','1','','','','Central Gas','0','NORTH MANOR PH 5, BLOCK 7, LOT 17 (32\' OF) & 21\' OF 18','Subdivision Lot','6625','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','148 - Bryan','FANNIN ELEMENTARY SCHOOL (BRYAN)','BRYAN HIGH SCHOOL','STEPHEN F. AUSTIN MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','North Manor Ph 5','5525','2.3493','Public Sewer,Public Water','1967','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:27:34.383' ,`MLSNumber` = '75735791' ,`ListAgentFullName` = 'Jeneen Poole' ,`ListOfficeName` = 'Vylla Home' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026710' ,`Longitude` = '-95.228764' ,`PhotoCount` = '19' ,`PostalCode` = '77339' ,`RoomCount` = '4' ,`ListPrice` = '124900.00' ,`Status` = 'Active' ,`StreetName` = 'Hill Top' ,`StreetNumber` = '1710' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2541' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Is an investors special, 4 bedroom 2 bath with formal dinning room fixer upper home in the beautiful Forest Cove subdivision. Over sized lot with no back neighbors. Wood deck across the back of the home over looking the garden. Highly coveted location. Close to Hwy 59.' ,`Acres` = '0.3099' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Real Estate Owned' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 35 FOREST COVE SEC 7 U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Cove Sec 07 U/R' ,`TaxAmount` = '4258' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309069' WHERE `Matrix_Unique_ID` = '214096338' --> 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','214147396','1667309069','214147396','2022-11-01T06:08:05.203','75090611','Angelia McDaniel','Keller Williams Realty -SW','','','29.998537','-95.591074','32','77377','12','399998.00','Active','Oxenford','15414','Drive','Tomball','3','1','5','3021','Single-Family','Sprawling home with spacious rooms to accommodate a large family. Available just in time for the holidays. Grand 2-story entrance with angled ceilings upstairs welcome natural light. Crown molding throughout the 1st floor adds elegance. Home includes both formals for special dinners & intimate conversations. The large island kitchen with breakfast bar & eat-in breakfast area beckon others to join the cook. Plenty of cabinets & counter space coupled with large closets provide abundant storage throughout. Relax in the primary owner\'s suite tucked away from the rest of the home. Soak away your stress in the whirlpool tub with separate shower, dual vanities & a walk-in closet. A large game room, plus a loft gives everyone entertaining space. Outside the wrought iron gate provides privacy in this quiet community with convenient frwy access. Ample parking & workshop space with the added covered carport out back. Roof replaced in 2014, AC within 5 years.','0.182','10','','','Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Tomball South/Lakewood','Central Gas','1','LT 7 BLK 1 LAKEWOOD FOREST NORTH SEC 2','Subdivision Lot','7928','Appraisal District','','600','0','','1','Electric Oven','0','','','Gas Cooktop','','Composition','53 - Tomball','LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)','TOMBALL MEMORIAL H S','WILLOW WOOD JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Lakewood Forest North Sec 02','6685','2.4945','Public Sewer,Public Water,Water District','2001','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:42:27.957' ,`MLSNumber` = '12558842' ,`ListAgentFullName` = 'Rene Sorola' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775393' ,`Longitude` = '-95.548912' ,`PhotoCount` = '45' ,`PostalCode` = '77024' ,`RoomCount` = '9' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodthorpe' ,`StreetNumber` = '12435' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated 4 bedroom home ideally situated on a quiet cu-de-sac in the peaceful Memorial Hollow community. Impressive floor plan includes formal dining, butlers pantry, wine room, and game room with vaulted exposed beam ceiling. Attractive wood flooring and recessed lighting throughout. Spacious living room features a wall of windows allowing in plenty of natural light, full wet bar and stacked stone fireplace. Gourmet kitchen offers granite counters, island with pendant lighting, stainless appliances, and breakfast bar. Relaxing primary suite is complete with tray ceiling, dual sinks, garden tub and separate shower. The whole house is wired for audio, video and security system. The back yard is turfed and perfect for entertaining with 9 hole putting green, extended covered patio, outdoor kitchen, fenced pool (Redone in 2008) and pergola. Additional features include Generac Natural Gas Generator, and central vac. Zoned to exemplary Spring Branch ISD and Memorial High School.' ,`Acres` = '0.3085' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 4 MEMORIAL HOLLOW SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Hollow Sec 01' ,`TaxAmount` = '22763' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309069' WHERE `Matrix_Unique_ID` = '214171030' --> 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','214172167','1667309069','214172167','2022-11-01T07:05:09.413','35005374','Kassie Kersh','Hardy Browder Real Estate','','','29.382203','-95.832056','38','77461','11','399999.00','Active','Dove','14436','Lane','Needville','2','1','4','1803','Single-Family','Enjoy country living with convenience and access to city amenities. City water and sewer along with quick access to local shopping, restaurants and entertainment. This home features the luxury of a private primary bedroom located downstairs, with the remaining three bedrooms located upstairs. This space provides the comfort of having neighbors but at the privacy of a large country lot just under 2 acres at +/-1.9986. Not to forget the already mature live oaks and pecan trees adding that extra touch. In early 2022, this home has had brand new quality woodgrain laminate installed throughout the downstairs, backsplash in the kitchen, Quality Shaw Carpet in the Primary Bedroom and on the stairs, Top of the line window replacements throughout, a garden window installation in the kitchen, Double hung windows throughout the upstairs for easy cleaning., and new shelving in the master bath. \r\nIt really is just so quiet and peaceful, so come see for yourself!','1.9986','30','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','','Central Electric','0','0224 H AND TC RY, ACRES 1.9986','Subdivision Lot','87059','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Range,Freestanding Range','','Composition','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','1.5','Traditional','H & Tc Ry','5678','2.2544','Public Sewer,Public Water','1979','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','214178605','1667309069','214178605','2022-11-01T07:30:55.950','85167473','Lucy Vega','eXp Realty, LLC','','','29.802530','-95.476386','20','77055','3','395900.00','Active','Long Point','7419','Road','Houston','1','0','3','1082','Single-Family','PRIME Location! Next to gas station, across from a car dealership, right on Long Point. Let your imagination run! Think create Airbnb? Duplex, Triplex, Fourplex? Want to run a business with great signage visibility and lots of traffic? This IS the spot! In the heart of Spring Branch an incredible location that is easily accessible and ideally located between I-10 and 290, 610 and the Beltway, the Galleria and Energy Corridor and only 11 miles to Downtown Houston! Spring Branch 7 PROJECT underway with phase 1 COMPLETED! You are getting in at a fantastic time, call NOW and don\'t miss out!','0.1545','24','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Spring Branch','Central Electric','0','LT 3 BLK 7 PINE TERRACE','Subdivision Lot','6728','Appraisal District','','','0','','0','','0','','','','','Composition','49 - Spring Branch','HOUSMAN ELEMENTARY SCHOOL','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Pine Terrace','4974','2.4415','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T06:47:02.730' ,`MLSNumber` = '83846842' ,`ListAgentFullName` = 'Denise Kane' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = 'Hai Huynh' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.874992' ,`Longitude` = '-95.704467' ,`PhotoCount` = '30' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '244000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Chantalle' ,`StreetNumber` = '6650' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 6650 Chantelle Drive! This charming 3 bedroom 2 bath home has been recently updated with new luxury vinyl flooring, carpet and paint throughout. As you enter this home you will find two guest bedrooms and a full bath. Off the entry is a private hall leading to the primary suite and primary bathroom. Primary suite is large and bath has separate tub and shower, dual sinks and a huge walk-in closet. Den is spacious with a corner gas fireplace and wall of windows overlooking the backyard. Off the den you will find the kitchen/breakfast combo. Kitchen has been updated with new luxury vinyl tile flooring, stainless steel dishwasher and new black/stainless range and microwave. New oil rubbed bronze light fixture in the breakfast room and new backdoor leading to the backyard. Backyard is huge offering plenty of room for kids and pets. New roof 2021! No flooding! Zoned to excellent Cy-Fair ISD and close to shopping. Come see this beautiful home today!!' ,`Acres` = '0.1326' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 4 STRATHMORE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Strathmore Sec 01' ,`TaxAmount` = '4639' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309069' WHERE `Matrix_Unique_ID` = '214202876' --> 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','214207851','1667309070','214207851','2022-11-01T07:35:42.033','81155295','Kay Krampitz','Texas Trust Real Estate','','','29.847305','-96.164284','16','77474','9','345000.00','Active','Fm 331','734','Road','Sealy','2','2','3','3216','Single-Family','Historical Farmhouse with tons of character! This amazing home was built in the early 1900\'s and relocated to Sealy. There is so much history here and road frontage on both sides of the property. This home sits on 1.2 acres with lots of mature trees. There is a fabulous welcoming front porch with a beautiful wood front door. When you enter the home, you will immediately notice the high ceilings, and an abundance of farmhouse charm. This home just goes on and on with over 3000 Sq. Ft. The backyard has a fantastic, heated saltwater pool and it has a cover. There is a spacious kitchen with an island and tons of storage cabinets. Many updates including a top-of-the-line TRANE A/C unit, and recent Paint inside and out. There is a 2 car garage with lots of storage. This could be your own gem in the Country.','1.198','57','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','1','','Central Electric,Heat Pump','0','CRICK SUB. (OUT OF ABST 31)LOT 2','Cleared','52185','Appraisal District','','','0','','2','','1','Fiberglass,Heated,In Ground,Salt Water','','','','Composition','109 - Sealy','SEALY ELEMENTARY SCHOOL','SEALY HIGH SCHOOL','SEALY JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Ranch','Crick Sub','4690','1.8832','Septic Tank,Well','1920','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:35:22.533' ,`MLSNumber` = '5905490' ,`ListAgentFullName` = 'Joe Hernandez' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779381' ,`Longitude` = '-95.353954' ,`PhotoCount` = '30' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Chapman' ,`StreetNumber` = '1917' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 3 bedroom, 2 bath home (plus office) is ready for move in! This stunning home was recently remodeled in 2020. It has a spacious and fully remodeled kitchen, equipped with stainless steel appliances, farmhouse sink and quartz countertops. The property is completely fenced with an electric gate and a cozy front porch. The open floor plan makes it excellent for hosting guests or entertaining family. Did we mention location? It is within a few minutes drive of both I-45 and I-10 and is conveniently located just a few minutes from downtown, the Heights and Midtown. Within immediate area, you will find coffee shops, restaurants, Metro Rail, Minute Park and U of H Downtown.' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 10 & 11 BLK 6 CASCARA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHERMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cascara' ,`TaxAmount` = '4338' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309070' WHERE `Matrix_Unique_ID` = '214222645' --> 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','214222690','1667309070','214222690','2022-11-01T06:23:39.803','43659019','Estevan Velasquez','Coldwell Banker RealtyREALTORS','','','29.972914','-95.549449','33','77070','9','310000.00','Active','Stone Oak','7810','Court','Houston','2','1','4','2116','Single-Family','You will fall in love with this beautiful home perfectly placed at the end of a quiet Cul de sac. The upgraded brick and stone elevation really set this home apart. The home has a great, inviting layout, open concept living space and centralized, entertaining kitchen, no carpet at all downstairs. Some impressive features include high ceilings, granite countertops, oversized back patio cover with stamped concrete floors and brick columns, as well as a separate AC solely for the primary bedroom. Upstairs you will find a large Gameroom, flanked by 3 good size bedrooms and recently updated full bath. The home has been beautifully cared for with no history of flooding. Book your showing today!','0.1515','13','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','','1','Champions Area','Central Electric','1','LT 70 BLK 1 HIGHLAND TIMBERS SEC 1','Cul-De-Sac','6600','Appraisal District','','1080','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','HANCOCK ELEMENTARY SCHOOL (CY-FAIR)','CYPRESS CREEK HIGH SCHOOL','BLEYL MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Highland Timbers','5371','2.4087','Public Sewer,Public Water','2002','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-01T07:43:06.927' ,`MLSNumber` = '96053632' ,`ListAgentFullName` = 'DeeAnn Gates' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811619' ,`Longitude` = '-95.406208' ,`PhotoCount` = '29' ,`PostalCode` = '77008' ,`RoomCount` = '6' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Nicholson' ,`StreetNumber` = '2703' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fabulous 3-bedroom 2 bath bungalow in the heart of Houston Heights. This home has the charm of the 1920’s but built 1998 with all the modern conveniences! The seller has loaded this home with updates which include new windows with Hunter Douglas power shades and plantation shutters, attic heat reflective insulation plus an attic air purification system. A whole house Generac generator, deck & fence replacement, kitchen appliances and so much more! The home features hardwoods throughout plus a large primary bedroom with a wonderful custom closet system. Nice sized secondary bedrooms with their own bath. Sit and watch the world go by on your front porch or enjoy the solitude of your quaint back patio. You will love the location!!! Situated right along the hike/bike trail and close to the most popular dining and shopping destinations in Houston. Once you see it, you’ll love it!' ,`Acres` = '0.1056' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 45A 46A 47A & 48A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '12239' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667309070' WHERE `Matrix_Unique_ID` = '214241082' --> Updated record success