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-06T21:45:49.660' ,`MLSNumber` = '41662212' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150899' ,`Longitude` = '-95.584323' ,`PhotoCount` = '26' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '921861.00' ,`Status` = 'Active' ,`StreetName` = 'Tynan Ridge' ,`StreetNumber` = '8538' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 41662212 - Built by Toll Brothers, Inc. - December completion! ~ Located on a corner home site with no rear neighbors, the Adalyn Italian Villa boasts a clean stucco finish that makes an impressive statement. This beautiful two-story home features soaring ceilings, private study, and formal dining room with views to the curved staircase. Open the multi-slide doors in the great room and expand your entertaining and living space to the covered porch. Additional highlights are a first-floor guest suite with full bath. The primary suite offers a tray ceiling and resort-style bath and spacious closet. Host game and movie nights in the flex/game space or media room. Outdoor toys will be covered in the huge 4-car tandem garage. This is the epitome of luxury living in a resort-style community!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 9 Blk 3' ,`LotDesciption` = 'Corner,Other' ,`LotSize` = '11718' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667835536' WHERE `Matrix_Unique_ID` = '200571208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:46:16.960' ,`MLSNumber` = '8237025' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.120429' ,`Longitude` = '-95.565819' ,`PhotoCount` = '11' ,`PostalCode` = '77375' ,`RoomCount` = '8' ,`ListPrice` = '529298.00' ,`Status` = 'Active' ,`StreetName` = 'Keswick Valley' ,`StreetNumber` = '24623' ,`StreetSuffix` = 'Way' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 8237025 - Built by Toll Brothers, Inc. - Ready Now! ~ New Floor Plan! The Angelo High Plains provides space and function for active lifestyles. A versatile bedroom with closet could be used for home office or guest suite with full bath just across the hall. The well-appointed kitchen offers a center island with breakfast bar, ample storage with the walk-in pantry, tons of counter and cabinet space. The great room boasts dramatic sloped ceilings that carry through multi-slide doors onto the covered patio. A spacious primary bedroom includes an en-suite with double-door entry, separate tub and shower, dual sinks and walk-in closet. Two additional secondary bedrooms with hall bath make room for friends and family.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 17 Blk 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5376' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MAHAFFEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'HOFIUS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes at Creekside' ,`TaxAmount` = '' ,`TaxRate` = '2.89' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667835536' WHERE `Matrix_Unique_ID` = '208232565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:45:26.170' ,`MLSNumber` = '18681731' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469879' ,`Longitude` = '-95.524132' ,`PhotoCount` = '12' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '629238.00' ,`Status` = 'Active' ,`StreetName` = 'Water Breeze' ,`StreetNumber` = '9507' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 18681731 - Built by Toll Brothers, Inc. - December completion! ~ NEW FLOOR PLAN- The Matagorda Mission showcases urban styling with it\'s inviting foyer which flows into the spacious office with soaring ceiling. The great room features a linear fireplace and multi-slide glass doors that open to a desirable covered patio. The well-equipped gourmet kitchen overlooks a bright casual dining area with additional bank of cabinets and is highlighted by a large center island with breakfast bar. The beautiful primary bedroom suite is enhanced by an elegant tray ceiling, enormous walk-in closet, freestanding tub and luxe shower. Secluded on the second floor, the secondary bedrooms feature walk-in closets and shared hall bath, overlooking a generous loft which opens to the media room. Make your appointment today and tour an amazing community and great new floor plan that is sure to exceed your needs.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 blk 1' ,`LotDesciption` = 'Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '8092' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sienna - Villa Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667835536' WHERE `Matrix_Unique_ID` = '208988145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:38:19.583' ,`MLSNumber` = '86961176' ,`ListAgentFullName` = 'Rene Sorola' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805851' ,`Longitude` = '-94.907523' ,`PhotoCount` = '39' ,`PostalCode` = '77521' ,`RoomCount` = '5' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Hollow' ,`StreetNumber` = '7815' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2531' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained 5 bedroom home situated on a large lot with no back neighbors in the peaceful Lynnwood community. Impressive floor plan includes formal dining room with elegant chandelier and upstairs game room. Arched walkways, plush carpet and attractive tile flooring throughout. Designed for entertaining with open concept living, kitchen and dining areas. The living room is spacious and offers large windows allowing in plenty of natural light. Gourmet kitchen features granite counter tops, stainless steel appliances, tile back splash and under mount sink. First floor primary retreat is complete with walk in closet, dual sinks, garden tub and separate shower. The big back yard is perfect for outdoor entertaining with huge extended covered patio and sparkling swimming pool. Zoned to Goose Creek ISD. Local attractions are only minutes away including shopping, restaurants, and many outside recreational options. Schedule your showing to view this exceptional property today!' ,`Acres` = '0.132' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BK 2 LT 145 LYNNWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'LYNNWOOD' ,`TaxAmount` = '6199' ,`TaxRate` = '2.9232' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835536' WHERE `Matrix_Unique_ID` = '210181017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:46:10.503' ,`MLSNumber` = '70287985' ,`ListAgentFullName` = 'Kristi Henry' ,`ListOfficeName` = 'Galveston Vacation Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.535745' ,`Longitude` = '-95.170485' ,`PhotoCount` = '12' ,`PostalCode` = '77546' ,`RoomCount` = '7' ,`ListPrice` = '321500.00' ,`Status` = 'Active' ,`StreetName` = 'Raven Falls' ,`StreetNumber` = '2618' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just what you\'ve been waiting for! Fall in love with the open floor plan of this 3 bedroom, 2 bath home, nestled away in the quiet subdivision of Heritage Park Pointe. Centrally located close to I 45 access makes commuting very convenient! You are always just minutes away from restaurants, shopping, malls, medical centers and much more! Everything at your fingertips! Zoned to some of the most highly sought after and top rated schools in the Clear Creek district. Home has just been recently refreshed with interior paint throughout along with several updates and custom upgrades! This home won\'t last long! It\'s waiting for you to come add your personal touch and make it your own. Call today for details! Don\'t miss another opportunity!' ,`Acres` = '0.151' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 HERITAGE PARK SEC 25' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '6578' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Heritage Park Sec 25' ,`TaxAmount` = '5064' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835537' WHERE `Matrix_Unique_ID` = '210328070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:44:56.217' ,`MLSNumber` = '93101417' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.958770' ,`Longitude` = '-95.199670' ,`PhotoCount` = '20' ,`PostalCode` = '77346' ,`RoomCount` = '11' ,`ListPrice` = '726696.00' ,`Status` = 'Active' ,`StreetName` = 'Agogo Woods' ,`StreetNumber` = '16634' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3740' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 93101417 - Built by Toll Brothers, Inc. - December completion! ~ Your dream home is waiting. The striking two-story foyer offers sweeping views of the great room just beyond. The stunning kitchen is highlighted by a designer backsplash, modern cabinets, and upgraded countertops. A first-floor office provides the space to work from home. Gorgeous interior finishes highlight every room of this home. Experience the luxury you\'ve always wanted and schedule your appointment today!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 (PURE ACCT*1504710010049) GROVES SEC 30' ,`LotDesciption` = 'Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '8899' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '393' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves-Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.73' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667835537' WHERE `Matrix_Unique_ID` = '211225164' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:18:13.957' ,`MLSNumber` = '12328970' ,`ListAgentFullName` = 'Rosa Martinez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710086' ,`Longitude` = '-95.272984' ,`PhotoCount` = '14' ,`PostalCode` = '77012' ,`RoomCount` = '5' ,`ListPrice` = '95000.00' ,`Status` = 'Active' ,`StreetName` = 'Reese' ,`StreetNumber` = '1809' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 19 & 20 BLK 13 DALY PLACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAVILA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Daly Place' ,`TaxAmount` = '1581' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835537' WHERE `Matrix_Unique_ID` = '211392042' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:02:40.403' ,`MLSNumber` = '61193388' ,`ListAgentFullName` = 'Kevin King' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = 'Emily Green' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.867332' ,`Longitude` = '-94.853085' ,`PhotoCount` = '9' ,`PostalCode` = '77523' ,`RoomCount` = '5' ,`ListPrice` = '429900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fisher' ,`StreetNumber` = '12402' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Move-in ready home on a large corner lot in Fisher\'s Landing Subdivision. This home has many updates including paint, roof, primary bathroom, flooring and fence. Open floorplan with fireplace, surround sound, built-ins, split floorplan, huge garage and storage building. This home is a must see.' ,`Acres` = '0.39' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 205 & FISHERS LANDING II S/2 LT 204' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16988' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fishers Landing Sec 02' ,`TaxAmount` = '5602' ,`TaxRate` = '2.1487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835537' WHERE `Matrix_Unique_ID` = '211647010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:31:27.257' ,`MLSNumber` = '91228989' ,`ListAgentFullName` = 'Darryl Hunter' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.376715' ,`Longitude` = '-95.544487' ,`PhotoCount` = '32' ,`PostalCode` = '77304' ,`RoomCount` = '14' ,`ListPrice` = '737000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble Glen' ,`StreetNumber` = '9979' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3224' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy Lake Living in the beautiful gated community of Pebble Glen on the Lake! Neighborhood pool with cabana overlooking Lake Conroe,boat ramp,boatyard. Custom 3 BR/3.5 B has oversized garage for your vehicles and lake toys. Flex Suite for office or 4th BR. Gathering kitchen has large quartz island with SS sink and touchless faucet,36\" gas cooktop with griddle,SS GE Profile appliances,Kent Moore cabinetry with soft-close drawers,and walk-in pantry. Glass-door cooler at window makes an attractive beverage bar! Tiled electric fireplace with cedar mantel.Master Suite features a tiled spa room with rain, wall AND handheld shower, and soaking tub with seat and gorgeous wall faucet. Energy efficiency with Environments for Living designation-tankless water heater. Luxury vinyl and tile throughout.Lg mud/utility room has connections for pet spa, washer/dryer. Covered back patio overlooks fenced backyard and boatyard. Gorgeous panoramic lake sunsets from expansive 2ndFL living area and balcony!' ,`Acres` = '0.1321' ,`Area` = '39' ,`BuilderName` = 'Private' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PEBBLE GLEN ON THE LAKE, BLOCK 1, LOT 82' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '5755' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Craftsman,Other Style,Ranch' ,`Subdivision` = 'Pebble Glen On The Lake' ,`TaxAmount` = '452' ,`TaxRate` = '2.1823' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667835538' WHERE `Matrix_Unique_ID` = '211668781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:17:41.387' ,`MLSNumber` = '15056988' ,`ListAgentFullName` = 'Ashly Singletary' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.081577' ,`Longitude` = '-95.361550' ,`PhotoCount` = '29' ,`PostalCode` = '77386' ,`RoomCount` = '3' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Aspen Horizon' ,`StreetNumber` = '28126' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2479' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful Lennar home located in the Master-Planned living in Harmony Village! Zoned to highly acclaimed Conroe ISD schools. This home is conveniently located with easy access to the Grand Parkway and I-45, also many fine dining restaurants and shopping in The Woodlands! This home is on a larger lot and loaded with upgrades. It comes with the technology and smart home capabilities. New sliding glass doors that open into the backyard, overhead racks installed in the garage - the upgrade list goes on and on. Open concept kitchen with a perfect size island with granite countertops and stainless steel appliances. This home has 3 large bedrooms and great size closets, with easy access to attic space. Upstairs features a gameroom space with additional closets for plenty of storage. Harmony subdivision has 2 pools, 2 splash pads, 3 parks, gym, tennis and basketballs courts, as well as many walking trails. See list of all of the upgrades and in attachments.' ,`Acres` = '0.1774' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S571210 - HARMONY VILLAGE 10, BLOCK 3, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7727' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harmony Village 10' ,`TaxAmount` = '7862' ,`TaxRate` = '2.9587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835538' WHERE `Matrix_Unique_ID` = '211788546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:39:54.257' ,`MLSNumber` = '57439362' ,`ListAgentFullName` = 'Jason Vo' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928664' ,`Longitude` = '-95.555628' ,`PhotoCount` = '32' ,`PostalCode` = '77064' ,`RoomCount` = '6' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Springsong' ,`StreetNumber` = '11046' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1562' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a beautiful and cozy 3 bed, 2 baths, and 2 car garage home located in the well-established Harvest Bend community. Great location with less than 5 minutes to major business parks. Easy access to highway FM-1960, Beltway 8, Highway 249, and 290. In addition, this home features recent updates throughout with new paints, new flooring, a kitchen upgrade with a new countertop and sink, bathrooms are completely remodeled with standing showing in the master, and new faucets, as well as the countertop. Split-plan layout with a separate area for formal living, formal dining, and family area. The home is surrounded by mature trees, with no backyard neighbors, green space, and a gazebo in the back that is ready for weekend friends and family gatherings. What are you waiting for? CALL NOW FOR A PRIVATE SHOWING.' ,`Acres` = '' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 5 HARVEST BEND THE VILLAGE 3 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '407' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILLBERN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Bend Village 03 R/P' ,`TaxAmount` = '4054' ,`TaxRate` = '2.4' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835538' WHERE `Matrix_Unique_ID` = '212167751' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:53:04.327' ,`MLSNumber` = '32762736' ,`ListAgentFullName` = 'Maria Saldivar' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472004' ,`Longitude` = '-95.160842' ,`PhotoCount` = '32' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkham' ,`StreetNumber` = '548' ,`StreetSuffix` = '' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Sellers!! This gorgeous one-story architecturally designed home built by Perry Homes in the desirable Westover Park Community offers four-sided masonry w/ full Artisan Antique Brick and Alamo Stone. Home features an open floor plan with 12 ft ceilings and 8 ft doorways. Beautifully sophisticated in style, the entry and spacious dining room are perfect for entertaining family and guests The HEART of this home, the kitchen offers 42\" dark wood cabinetry, granite countertops, stone backsplash, breakfast bar, large walk-in pantry and a breakfast area. Adjoining is the immense living room, which features a gas/wood burning fireplace, ideal for memorable gatherings. The Primary bedroom is located in the rear of the home. This home is complete with three additional bedrooms, the extra room, an office/study room and two-car garage.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTOVER PARK SEC 11B (2011) ABST 606, BLOCK 1, LOT 19, ACR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '605' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westover Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835538' WHERE `Matrix_Unique_ID` = '212280760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:53:05.997' ,`MLSNumber` = '47842735' ,`ListAgentFullName` = 'Taylor Jackson' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = 'Rosa Acosta' ,`SellingOfficeName` = 'BOSCO REALTORS, & ASSOCIATES' ,`Latitude` = '29.788535' ,`Longitude` = '-95.537916' ,`PhotoCount` = '26' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '529000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pine Lake' ,`StreetNumber` = '9909' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tastefully remodeled Ranch-style home in Spring Branch Woods! This home features 4 bedrooms + bonus room, 3 full baths, open concept living spaces, grand windows, and original hardwood floors throughout the majority of the home. The primary suite has it all - vaulted ceilings w/ natural wood beams, floor-to-ceiling windows, access to back patio, and walk-in closet. Primary bath boasts double sinks, jetted tub, walk-in shower & water closet. Light, neutral finishes throughout. Bathrooms & kitchen are recently updated. Kitchen features high-end stainless steel appliances. Bonus room is large enough to be an extra bedroom, study, gym, flex space, etc. Backyard features newly-poured concrete back patio & access to green belt space through back fence gate. Recent landscaping and sprinkler system in front and back yards. All information is per Seller.' ,`Acres` = '0.2119' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 8 SPRING BRANCH WOODS SEC 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9230' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Spring Branch Woods' ,`TaxAmount` = '13282' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835538' WHERE `Matrix_Unique_ID` = '212361494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:21:09.017' ,`MLSNumber` = '54994735' ,`ListAgentFullName` = 'Ashly Singletary' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815202' ,`Longitude` = '-95.383411' ,`PhotoCount` = '8' ,`PostalCode` = '77022' ,`RoomCount` = '3' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = '32nd' ,`StreetNumber` = '1212' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1338' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Please verify all room dimensions. This home is located in a prime location. Minutes from downtown, 45 and 290. Get your showing scheduled before it is gone. Home has great potential and ready for you to make it your own. Gorgeous fencing around the front, with a nice porch to enjoy your morning coffee. Laundry is located in the garage. Home being sold AS IS.' ,`Acres` = '0.0918' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 3 AIRLINE HEIGHTS' ,`LotDesciption` = 'Other' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Airline Heights' ,`TaxAmount` = '3027' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835539' WHERE `Matrix_Unique_ID` = '212422137' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:46:23.780' ,`MLSNumber` = '76323082' ,`ListAgentFullName` = 'Yvonne Killings' ,`ListOfficeName` = 'Balanced Life Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998653' ,`Longitude` = '-95.846777' ,`PhotoCount` = '18' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Gadwall Bayou' ,`StreetNumber` = '26902' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2219' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Are you looking for the quiet of a small community, a cul-de-sac property in front and a dead end no back neighbors in the rear. A backyard that could hold two swimming pools. Not to mention a gas appliance chef\'s kitchen, with all appliances included even the refrigerator. Granite counter tops and the latest soft close cabinets and even a walk in pantry; this is only the beginning of this magnificent property. The laundry room comes complete with the washer and dryer. New updated Wood look tile flooring, custom paint, down stairs primary bedroom, separate garden tub and stand alone shower and a walk in closet for the shopper in you. Bathroom cabinets replaced and granite countertops 3 additional large upstairs bedrooms Just in time for football cook outs. Come and see what this beautiful hidden gem has to offer it\'s next owner.....OPEN HOUSE SATURDAY & SUNDAY 1PM - 3PM' ,`Acres` = '0.229' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 1 MALLARD CROSSING SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9977' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = '' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Mallard Xing Sec 1' ,`TaxAmount` = '6981' ,`TaxRate` = '3.256' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835539' WHERE `Matrix_Unique_ID` = '212485448' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:30:55.043' ,`MLSNumber` = '16598675' ,`ListAgentFullName` = 'Nicholas Moncada' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062765' ,`Longitude` = '-95.391580' ,`PhotoCount` = '21' ,`PostalCode` = '77373' ,`RoomCount` = '9' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Goldspring' ,`StreetNumber` = '2219' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Roof installed 10/24/22. Classic Gemcraft single story floorplan is bright and open with high ceilings and has neutral paint and carpet. Updated kitchen with recent appliances, granite counter tops and 42 inch cabinets with Lazy Susan. Butler\'s pantry with pull out shelves and several drawers. Fresh interior paint in primary suite. Primary bath has been updated with recent tile floors, tile tub surround and white cabinets. Updated bronze light fixtures. Large covered back patio. Storage shed. Garage has workshop area. Lush mature landscaping. A must see!' ,`Acres` = '0.1567' ,`Area` = '12' ,`BuilderName` = 'Gemcraft' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 21 North Spring Sec 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'North Spring' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835539' WHERE `Matrix_Unique_ID` = '212523064' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:00:49.240' ,`MLSNumber` = '29869161' ,`ListAgentFullName` = 'Blake Vincent' ,`ListOfficeName` = 'DUX Realty, LLC' ,`SellingAgentFullName` = 'Debbie Levine' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.754237' ,`Longitude` = '-95.386913' ,`PhotoCount` = '42' ,`PostalCode` = '77019' ,`RoomCount` = '14' ,`ListPrice` = '749900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'PIERCE' ,`StreetNumber` = '408' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '* RECENTLY COMPLETED * Mazzarino Construction & Development\'s new division is here in Houston\'s well established inner loop neighborhoods. MAZZTAO Homes features a new, stylish, well priced, quality home, but with an entirely different price point. You no longer have to compromise your location to buy somewhere or something else, that you just don’t really want. This home features an extremely versatile & functional floor plan. The floor plan has 4 bedrooms, 3.5 bathrooms , primary suite w/2 walk-in closets, 1st floor living, flex room, approx. 468 S.f. backyard & private driveway. Retail, restaurants, gym, groceries, you name it, it\'s walking distance away. Major freeways, downtown, medical center, parks, theater, art & museum districts are all within minutes.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'MAZZTAO HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 WEST PIERCE STREET GREEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2600' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'WEST PIERCE STREET GREEN' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667835539' WHERE `Matrix_Unique_ID` = '212728145' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:28:53.210' ,`MLSNumber` = '18463383' ,`ListAgentFullName` = 'Elizabeth Wentworth' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209510' ,`Longitude` = '-95.342177' ,`PhotoCount` = '42' ,`PostalCode` = '77302' ,`RoomCount` = '10' ,`ListPrice` = '484000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset Skies' ,`StreetNumber` = '17546' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Better Than New! - Separate Wing has Office / Mother In Law Suite with Private Entrance, Full Bath, Kitchenette & attached Single Car Garage totaling 3 Full Car Garages. Sellers added many features to this already fantastic home. Custom porcelain blue accent tile backsplash in kitchen w matching bar stools, gutters added all around, accent walls in primary bedroom & office. Super Sized Shower in Primary Bath. RAP feature for air flow w bedroom doors closed. Gorgeous backyard retreat w newly extended patio to enjoy majestic sunsets. No back neighbors, iron fence for view of natural area & walking path. Rain barrel in back to capture & conserve water. Woodworkers dream in 3rd car garage w tons of tool storage & work space. Giant attic \"Room\" could become extra conditioned space off game or media room. Come explore all the wonderful features of this home. See renderings of POOL Option for backyard. Enjoy fitness center, restaurant, lake & many more amenities of Artavia. Come fall in love!' ,`Acres` = '0.1623' ,`Area` = '19' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S216902 - ARTAVIA 02, BLOCK 3, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '985' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas 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` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia 02' ,`TaxAmount` = '1799' ,`TaxRate` = '3.1988' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835539' WHERE `Matrix_Unique_ID` = '212810300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:07:32.783' ,`MLSNumber` = '11611007' ,`ListAgentFullName` = 'Milica Vasiljevic' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Fairuza Bailey' ,`SellingOfficeName` = 'Results Real Estate' ,`Latitude` = '29.798930' ,`Longitude` = '-95.188682' ,`PhotoCount` = '50' ,`PostalCode` = '77015' ,`RoomCount` = '6' ,`ListPrice` = '270000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Redgate' ,`StreetNumber` = '13311' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1785' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning, updated home with a welcoming covered front porch.\r\n\r\nUpon entering the home, you are warmly greeted by new flooring, fresh paint, new doors, bright and open floor plan connecting the living room to the kitchen.\r\n\r\nMeticulous attention to detail is presented in the kitchen with new tiles, quartz countertops, a modern backsplash, steel appliances, and a lot of cabinet space.\r\n\r\nBesides a second fireplace in the primary suite, there is also a balcony that overlooks the backyard. \r\n\r\nEnjoy the spa-like full bathroom with a wet room that includes a free-standing tub and rain shower and dual vanity sinks.\r\n\r\nAlso updated are the roofing, energy-efficient windows, and a backyard that has an oversized covered patio and premium shed for extra storage all on a huge backyard' ,`Acres` = '0.1616' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 57 BLK 82 WOODFOREST SEC 21' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'GREEN VALLEY ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest Sec 21' ,`TaxAmount` = '3988' ,`TaxRate` = '2.5294' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835540' WHERE `Matrix_Unique_ID` = '212949783' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:00:37.727' ,`MLSNumber` = '44905470' ,`ListAgentFullName` = 'Janet White' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766430' ,`Longitude` = '-94.968581' ,`PhotoCount` = '35' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Briarclift' ,`StreetNumber` = '601' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the market. Buyer\'s funding fell through. \nRecently remodeled 3-2-2 home in well established neighborhood. Kitchen remodeled in 2021 with open concept and large walk-in pantry. Oversized laundry room has in-the-wall ironing board and plenty of room for sewing machine or other crafts. Cathedral ceiling in den with double french-doors gives access to covered back patio. Primary bath has beautiful large shower complete with modern tile, bench seat and rain-shower head. Pex water lines, A/C ducts and hot water heater all replaced in 2021. Back sidewalk and extended patio recently added and finished with stamped concrete. Extra driveway/parking area on south side of garage provides plenty of room for all your vehicles and toys. Outside freshly painted. Fence recently replaced beside garage with new double wide gate. Home is complete with granite in kitchen and bathrooms. Two attic storage areas one in the house and one in the garage. Storage building remains.' ,`Acres` = '0.1977' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 5 ALLENBROOK SEC 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Allenbrook Sec 03' ,`TaxAmount` = '4982' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835540' WHERE `Matrix_Unique_ID` = '213042646' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:54:05.090' ,`MLSNumber` = '90925877' ,`ListAgentFullName` = 'Adewole Omogunsoye' ,`ListOfficeName` = 'Wolex Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005394' ,`Longitude` = '-95.140867' ,`PhotoCount` = '31' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '274905.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Shores Drive' ,`StreetNumber` = '8903' ,`StreetSuffix` = '' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2299' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS 3-bedroom 2.5 bath, 2299sq ft home in the beautiful community of Atascocita Shores with lots of possibilities. The home is close to Lake Houston, minutes away from Humble/Kingwood, Shopping and Dining. This Home Has Never Flooded. Schedule your showing today.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALT 9 BLK 1 TASCOCITA SHORES SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '649' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita Shores' ,`TaxAmount` = '3204' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835540' WHERE `Matrix_Unique_ID` = '213242663' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:32:19.453' ,`MLSNumber` = '88576811' ,`ListAgentFullName` = 'Jennifer Penchas' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080374' ,`Longitude` = '-95.248623' ,`PhotoCount` = '22' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '379330.00' ,`Status` = 'Active' ,`StreetName` = 'Terreton Springs' ,`StreetNumber` = '21333' ,`StreetSuffix` = 'Drive' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This beautiful corner lot property has tons of upgrades. This property offers 4 bedrooms, 2.5 baths, and a flex room; it can be used as an office or game room. To start, newly painted; cabinets, doors, trims, and walls in every room. All bedroom floors, family room, and stairs have been replaced with new laminate flooring. All light switches were replaced and brought up to code. The first floor is an open living concept. The spacious kitchen opens up to the family room with a cozy fireplace; great for hosting. Pet owners, this property offers a huge backyard. Must see!' ,`Acres` = '0.1394' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S809100 - POINT AT OAKHURST, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6073' ,`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` = '39 - New Caney' ,`SchoolElementary` = 'BENS BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Point At Oakhurst' ,`TaxAmount` = '6761' ,`TaxRate` = '3.0681' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835540' WHERE `Matrix_Unique_ID` = '213687898' --> 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','213728766','1667835541','213728766','2022-11-06T21:48:56.107','82222722','Daniel Enriquez','Texas United Realty','','','29.687851','-95.352821','0','77021','7','260000.00','Active','New York St','6834','','Houston','2','0','4','1224','Single-Family','','','4','','','','','Sellers Disclosure','','','','University Area','Central Gas','0','LT 10 BLK 18 GRAND PARK','Subdivision Lot','','','','','0','','0','','0','','','','','Composition','27 - Houston','FOSTER ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required','Appraisal District','1','Ranch,Traditional','Grand Park','','','Public Sewer,Public Water','1946','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:19:19.553' ,`MLSNumber` = '54366775' ,`ListAgentFullName` = 'Rose Ponce' ,`ListOfficeName` = 'Rose Ponce' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.274076' ,`Longitude` = '-94.828309' ,`PhotoCount` = '21' ,`PostalCode` = '77551' ,`RoomCount` = '8' ,`ListPrice` = '399999.00' ,`Status` = 'Active' ,`StreetName` = 'Ave T Rear' ,`StreetNumber` = '5910' ,`StreetSuffix` = 'Alley' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '60-SECOND DRIVE TO THE BEACH !!!! THIS IS IT - LOOK NO FURTHER - COMPLETELY REMODELED ISLAND BUNGALOW...This home is a must-see! The home features 3 bedrooms, 2 baths, Open Living/Dining/Kitchen-perfect for entertaining! The kitchen offers an abundance of custom cabinets with an abundance of storage space, a center island, Stainless steel appliances, custom hardwood floors and hardwood doors, Calacatta Quartz countertops as well as in the bathrooms. The Master offers a walk-in closet, with exquisite custom herringbone marble floors and Italian Marble Walls. bathroom with an oversized custom shower. Large, fenced backyard, deck. New HVAC, new Pex Plumbing , New Sewer lines, Spray foam Insulation, New Hardiplank Siding, Home was completely Redesigned. Just minutes from the Seawall, downtown Strand, local shopping, restaurants, and entertainment. Don\'t wait, schedule your appointment today! Amazing Location In 1 minute Proximity to the Beach, Specs , Kroger , Randals , BOA and Walmart.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'TGP' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Abst 121 Hall & Jones N 1/2 of Lots 31 & 32 (31-0) Blk 10 W' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'W B Kinkeads Addn' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835541' WHERE `Matrix_Unique_ID` = '213846901' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:38:03.533' ,`MLSNumber` = '64241162' ,`ListAgentFullName` = 'Valerie Spivey' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736383' ,`Longitude` = '-95.782699' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '14' ,`ListPrice` = '497000.00' ,`Status` = 'Active' ,`StreetName` = 'Northshire' ,`StreetNumber` = '24126' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for a PREMIER location in your new home, this is it! Located in the beautiful highly sought after Cinco Ranch Community and Katy ISD School District. New paint throughout entire home (including garage). New landscape front & back. New roof installed 2017. New fence both sides front & back 2019. Rainbird sprinkler system front & backyard. Ceiling fans in all bedrooms including covered backyard patio. Alarm system with camera (AT&T). Ring camera doorbell. Entire home front & back pressure washed October 2022. Flagstone patio extension and walkway in backyard. Gas logged fireplace. Garage pre-wired for cable & wifi. New carpet throughout entire home. Newly remodeled kitchen with farm sink and Frigidaire appliances. Real hardwood floors in living area. New slate flooring in kitchen & dining and half bath and front foyer. Easy access to 99 Grand Parkway. Local shopping, grocery stores and Cinco Ranch Golf Course. Sellers are the original owners of this beauty!' ,`Acres` = '0.1722' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton/Emerald' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CINCO RANCH WEST SEC 6, BLOCK 1, LOT 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1115' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GRIFFIN ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'CINCO RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch West Sec 6' ,`TaxAmount` = '7355' ,`TaxRate` = '2.6485' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835541' WHERE `Matrix_Unique_ID` = '213880742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:37:15.843' ,`MLSNumber` = '81823192' ,`ListAgentFullName` = 'David Levin' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = 'Sarah Schneider' ,`SellingOfficeName` = 'Compass RE Texas, LLCKaty' ,`Latitude` = '29.692200' ,`Longitude` = '-95.827502' ,`PhotoCount` = '34' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '369888.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sandermeyer' ,`StreetNumber` = '11406' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!!! This is a stunningly elegant LAKEFRONT Beazer Home in the gated community of Westheimer Lakes. The home features a grand foyer with 11\' ceilings, 3 large bedrooms, 2 full baths, with a split & open living floor plan. The large kitchen comes with an abundance of 42\" custom wood cabinetry, SS appliances and sleek granite countertops. The expansive 23\'x16\' family room is sure to impress with a full wall of windows overlooking the entire lake adding tons of natural lighting. You will enjoy plenty of privacy, a walk in closet & serene lakefront views from your 15\'x14\' master suite, or just simply wind the day down on your backyard patio. Westheimer Lakes is a master planned community with easy access to a all major hwys, shopping, HEB, and entertainment. Low 2.5% tax rate! This energy efficient home has been kept in immaculate condition by the original owners and will rival any new home build!' ,`Acres` = '0.1987' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON SPRINGS AT WESTHEIMER LAKES SEC 1, BLOCK 2, LOT 24' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8657' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1155' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Spgs At Westheimer Lakes' ,`TaxAmount` = '6270' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835541' WHERE `Matrix_Unique_ID` = '213902565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:25:33.770' ,`MLSNumber` = '64487905' ,`ListAgentFullName` = 'Julia Wang' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745215' ,`Longitude` = '-95.529551' ,`PhotoCount` = '26' ,`PostalCode` = '77063' ,`RoomCount` = '10' ,`ListPrice` = '929999.00' ,`Status` = 'Active' ,`StreetName` = 'Shady Lane' ,`StreetNumber` = '15' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '5007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With a nod to Frank Lloyd Wright, this unique Memorial home in a secure gated community, is an architectural marvel. The floorplan is free-flowing, spanning three stories and three balconies that overlook the woodland and bayou. While the oblique angles and wall-to-wall windows lend an iconic retro look, there is a flawlessly contemporary feel thanks to the generous array of quality upgrades: quartz countertops, soft-close cabinets, high-end Wolf appliances and hickory hardwood floors, to name a few. Surprise extras include a genuine crystal chandelier, 24-karat gold plated fan light, trompe l\'oeil art mural, stone and cedar sunroom, sauna and fitness suite. The gated community gives extra peace of mind in what is already a very desired area of great neighbors and easy commutes and a number of neighborhood “favorite” bars/restaurants. Vast in proportions, yet secluded and private: this exquisite, one-of-a-kind home is a cathedral to luxury living nestled among the trees.' ,`Acres` = '0.2108' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'UNIT 2C BLDG .125000 INT COMMON LAND & ELE CLUSTER OAKS T/H' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '9181' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'EMERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Spanish,Traditional' ,`Subdivision` = 'Cluster Oaks Th' ,`TaxAmount` = '10024' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835541' WHERE `Matrix_Unique_ID` = '213940979' --> 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','213941023','1667835541','213941023','2022-11-06T21:25:56.000','42058793','Caroline Spagnola','Nan & Company PropertiesChristie\'s International R','','','29.514046','-94.984484','47','77518','9','2750000.00','Active','Bayshore','4023','Drive','Bacliff','4','1','4','5090','Single-Family','Welcome to Pelican Run on the Bay! This magnificent West Indies inspired, 4 bedroom, 4.5 bath stately residence exemplifies the highest caliber of finishes, remarkable craftsmanship, and unobstructed views of the Galveston Bay.Masterfully designed, this palatial property is an entertainer\'s dream. The exterior of the home conveys a message of refined beauty that is graced with outdoor ample living space, lush tropical foliage, a 100 ft fishing pier and concrete bulkhead along entire waterfront. The interior features a stunning chef’s kitchen and extra large island, fully operational elevator with telephone, fireplace, exquisite French doors, hurricane grade windows, garden patio, laundry room, spa like master bath, generously-sized bedrooms, and walk in closets with built ins.The incredible guest house and three car garage with a work room are added bonuses! Soundly built with 3 steel beams to securely protect this fortress. Home also contains a 36KW Generac whole home Generator','0.5516','33','','','','','Sellers Disclosure','1','','','Bacliff/San Leon','Central Electric,Central Gas','0','ABST 89 S HINTON SUR LOT 7 & S 43.50 OF 6 (7-0) BLK 2 PERKIN','Water View,Waterfront','24026','Appraisal District','','','0','','3','','0','','','','','Composition','17 - Dickinson','KENNETH E. LITTLE ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','DUNBAR MIDDLE SCHOOL (DICKINSON)','Accompany,Appointment Required','Appraisal District','2','Other Style','Perkins Beach 2nd','18834','2.2342','Public Sewer,Public Water','2015','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:47:50.747' ,`MLSNumber` = '62267971' ,`ListAgentFullName` = 'Susanna Mayberry' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.305780' ,`Longitude` = '-94.784140' ,`PhotoCount` = '44' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Church' ,`StreetNumber` = '1503' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1512' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare Island Jewel in the heart of the East End Historic District. Location, location situated overlooking historic Darragh Park. This home has been featured twice on the Galveston Historical Foundation\'s Tour of Homes (2018 and 2005), East End Historic District Christmas Tour (2017) and EEHD Garden Tour (2018), Better Home and Garden and Houston Home and Garden. Designer Touches throughout with open floor plan, original pine floors, bead board walls, beamed ceilings, an upper porch overlooking the park, an antique shaded brick patio and a screened porch perfect for lazy afternoons. Perfectly sized and easy to maintain this home sits on a spacious and beautiful corner lot with room for a pool and carriage house. Kitchen features Jenn Aire appliances, antique travertine countertops with a copper sink in the island. Two spacious bedrooms accommodating King beds each with an ensuite bathroom. Rare opportunity. LOW FLOOD AND WINDSTORM PREMIUMS: $538y Flood & $879y Windstorm.' ,`Acres` = '0.1185' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 7 BLK 375 GALVESTON' ,`LotDesciption` = 'Corner' ,`LotSize` = '5160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '5034' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1928' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835542' WHERE `Matrix_Unique_ID` = '213944471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:26:05.093' ,`MLSNumber` = '22828622' ,`ListAgentFullName` = 'Elizabeth Villarreal' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835724' ,`Longitude` = '-95.465405' ,`PhotoCount` = '30' ,`PostalCode` = '77092' ,`RoomCount` = '4' ,`ListPrice` = '459500.00' ,`Status` = 'Active' ,`StreetName` = 'Verdome' ,`StreetNumber` = '5005' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely gorgeous Oak Forest mid-mod brick cottage with many recent updates including new kitchen with farm sink, freshly painted exterior, insulated windows (2021), renovated guest bath with timeless marble (2021), HVAC system (2022). Full of natural light and graced with mature oak trees in the front yard, this special 4 bedroom home with 2 full baths has an invaluable secret: a detached 2 car garage off the beautiful backyard patio which is utilized as a workshop, home gym and outdoor living area. Garage plus patio & yard provide an incredible space for entertaining & parties. Sellers report low utility bills and still thoroughly enjoy their 50 gal water heater! Security system, all kitchen appliances, washer & dryer stay. Never flooded; flood insurance not required per Sellers. Just a hop, skip & jump from gathering spots such as Local Table, D’Alba, Aladdin, Common Bond, The Stomping Grounds, Les Baget, Walking Stick Brewery & T.C Jester Park\'s acres of space to run free.' ,`Acres` = '0.166' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 9 OAK FOREST SEC 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7232' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Forest' ,`TaxAmount` = '6203' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835542' WHERE `Matrix_Unique_ID` = '213974016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:29:35.767' ,`MLSNumber` = '19181637' ,`ListAgentFullName` = 'Justin Hilton' ,`ListOfficeName` = 'Southwest Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.049581' ,`Longitude` = '-95.635295' ,`PhotoCount` = '42' ,`PostalCode` = '77422' ,`RoomCount` = '0' ,`ListPrice` = '795000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 747a' ,`StreetNumber` = '4765' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unbelievable San Bernard River home in Riverwood Estates! Like no other, this unique and stunning home was built for entertaining. Extremely rare riverfront property! Open concept is an understatement. The layout provides an expansive feel w/ its high ceilings & large great room. The perfect place to create unforgettable memories w/ family gatherings and parties. Step out back and soak up the Texas sun on over 1200 sq/ft of furnished patio and decking, then take a dip in the pool overlooking the river & watch the wake surfers/skiers. This home offers amazing river views w/ large full view doors facing the pool & river. Completely renovated in ‘17 w/custom cabinetry & granite counters throughout, Italian tile flooring with handmade Texas stars inlayed, custom tiled walk in showers, interior paint, shutters, & KitchenAid appliances. Three car garage. ONE ACRE LOT W/ 30’x40’ SHOP INCLUDED! See update list attached in docs. CONVEYS COMPLETELY FURNISHED!' ,`Acres` = '0.567' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric,Heat Pump,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A0056 JAMES CUMMINGS TRACT 36C (CALLED R-11) (RIVERWOOD EST' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '24699' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'James Cummings' ,`TaxAmount` = '6847' ,`TaxRate` = '1.6567' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835542' WHERE `Matrix_Unique_ID` = '214019557' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:16:22.123' ,`MLSNumber` = '39823919' ,`ListAgentFullName` = 'Vera Mitrofanova' ,`ListOfficeName` = 'VAM Real Estate Solutions' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822221' ,`Longitude` = '-95.440710' ,`PhotoCount` = '39' ,`PostalCode` = '77018' ,`RoomCount` = '11' ,`ListPrice` = '1374999.00' ,`Status` = 'Active' ,`StreetName` = 'Ebony' ,`StreetNumber` = '1626' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4447' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This immaculate house was built by GHBA award winning builder Ryland Homes is located in the heart of Oak Forest, right off of I-610. You will love the infusion of Craftsman style and elegant modern design. This house has everything you can think of, private office, formal dining, wine grotto, exquisite Chef\'s kitchen with a huge granite island that opens up to the living room with a soaring ceiling. Some of the features include custom made shutters, extended WIFI, wire for alarm/security system, surround system, tankless water heater, epoxy garage flooring, oak hardwood floors throughout whole first floor, HEPA filters, warming drawers in the kitchen, pot filler, large pantry, laundry room with sink, media room, game room with wet bar. Updated landscaping with kumquat and grapefruit trees. Beautiful pool to enjoy during hot Texas summer! The backyard has an outdoor kitchen, garden includes rosemary, dill, thyme, cucumbers, onions, peppers, parsley, etc. Call for your private showing!' ,`Acres` = '0.168' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 48 OAK FOREST SEC 6' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Enclosed' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Craftsman' ,`Subdivision` = 'Oak Forest Add Sec 06' ,`TaxAmount` = '20634' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835542' WHERE `Matrix_Unique_ID` = '214028902' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:37:31.973' ,`MLSNumber` = '76675335' ,`ListAgentFullName` = 'Laura Bonck' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766731' ,`Longitude` = '-95.765312' ,`PhotoCount` = '23' ,`PostalCode` = '77450' ,`RoomCount` = '4' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Western Springs' ,`StreetNumber` = '1106' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1702' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recent updates include: brand new AC system(2022), whole house plumbing replaced with PEX(2021), garage door(2021), new plumbing fixtures(tub/shower/sink)(2021), whole house repainted (2022) Spacious and well updated one story home. Zoned to Katy ISD. Move-in-ready.' ,`Acres` = '0.188' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 30 CIMARRON SEC 8 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8191' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Sec 08 R/P' ,`TaxAmount` = '4255' ,`TaxRate` = '2.3833' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835542' WHERE `Matrix_Unique_ID` = '214078399' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:01:52.433' ,`MLSNumber` = '64067603' ,`ListAgentFullName` = 'Denny Tseng' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Demetra Carlson' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.789158' ,`Longitude` = '-95.587991' ,`PhotoCount` = '26' ,`PostalCode` = '77043' ,`RoomCount` = '4' ,`ListPrice` = '625000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Heathwick' ,`StreetNumber` = '1335' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this newly renovated 4 bedroom/2.5 bath home, located conveniently in the Energy Corridor with easy freeway access to I-10 and the Beltway. Located just minutes away from City Center and Memorial City Mall. This home features a large open kitchen with a professional-style range. Island peninsula with quartz waterfall countertops and modern LED lighting. All new cabinetry with soft close hinges and drawers. Large downstairs master suite and bath features open curbless shower, dual sink vanity, and separate his and her\'s closets. Open living area with high ceilings. Spacious secondary bedrooms and game room up. Exterior soffit lighting provide beautiful evening illumination of the home.' ,`Acres` = '0.1352' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 6 WESTWICK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'THORNWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwick Sec 01' ,`TaxAmount` = '9920' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835543' WHERE `Matrix_Unique_ID` = '214110055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:30:32.643' ,`MLSNumber` = '47266305' ,`ListAgentFullName` = 'Denise Houser' ,`ListOfficeName` = 'Houser Realty Group' ,`SellingAgentFullName` = 'Quinn Bui' ,`SellingOfficeName` = 'HomeSmart' ,`Latitude` = '29.549040' ,`Longitude` = '-95.687955' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '394900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Knoll Crest' ,`StreetNumber` = '1147' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '~PRESENTING 1147 KNOLL CREST~ EXCITED to showcase and share this BEAUTIFUL listing with you today!\r\nWarm and Inviting, open and flowing floor plan with many wonderful updates~ Rich dark HARDWOOD FLOORING throughout the majority of the house~ TILE in the kitchen family room~ REMODELED KITCHEN with Gorgeous QUARTZ counter tops, Huge Island overlooking the family room, Stainless appliances, SUBWAY TILE backsplash, New lighting and Fresh paint~ Solid surface countertops, QUARTZ, GRANITE, MARBLE~ Study with Double French doors, has a closet so could be a 4th Bedroom, which opens to the hallway for easy bathroom access~ Dining/Living flow together perfect for large gatherings, just in time for the HOLIDAYS~ Fabulous Master Bath with Granite Counter Tops and Custom Cabinets, Double sinks, Walk in shower~ Secondary Bathroom updates, Boasting Marble Counter Tops and Wood-look Tile Floors, Double Sinks~ Sit out and enjoy the upcoming season on the Oversized Wood Deck w/ Brick accent~' ,`Acres` = '0.2001' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD KNOLL SEC 5, BLOCK 1, LOT 1' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8718' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'DICKINSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Knoll Sec 5' ,`TaxAmount` = '6301' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835543' WHERE `Matrix_Unique_ID` = '214144171' --> 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','214165980','1667835543','214165980','2022-11-06T21:37:55.920','20640411','Amy Armstrong','BHGRE Gary Greene','','','30.213227','-95.476735','39','77384','3','575000.00','Active','Northcastle','222','Circle','The Woodlands','2','1','3','2505','Single-Family','Quality-built Village Builders home that has been beautifully updated in Windsor Hills, an active 55+ adult community in The Woodlands. You will love the open, spacious Doral plan with 3 bedrooms, 2.5 bathrooms, office, formal dining, and a rare 3-car garage that backs to land connected to the Jones Forest. This home has amazing views of the forest through solid impact resistant windows that span the entire back of the home. The privacy, location and neighbors cannot be beat. Close to restaurants, shopping, and the Medical Center. The HOA includes front yard maintenance (mowing, leaf removal, fertilizations, mulch) exterior painting, wood fence replacement, front door refinishing, gutter cleaning and trash collection. WH has walking trails, pool/spa, gym, library, and fun activities for everyone. See the floor plan, upgrade list and subdivision information in the document section.','0.1682','15','','','','','Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','The Woodlands','Central Gas','1','WDLNDS WINDSOR HILLS 05, BLOCK 1, LOT 17','Greenbelt,Wooded','7327','Appraisal District','','200','0','','3','','0','','','','','Composition','11 - Conroe','POWELL ELEMENTARY SCHOOL (CONROE)','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Wdlnds Windsor Hills','8557','2.1269','Water District','2002','Appraisal'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:12:09.210' ,`MLSNumber` = '6162077' ,`ListAgentFullName` = 'Kim Phengsykeo' ,`ListOfficeName` = 'TD Texas Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.170562' ,`Longitude` = '-95.410981' ,`PhotoCount` = '45' ,`PostalCode` = '77385' ,`RoomCount` = '5' ,`ListPrice` = '630000.00' ,`Status` = 'Active' ,`StreetName` = 'Great Oak Blvd' ,`StreetNumber` = '11728' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never Flooded! Gorgeous one-story custom 3-bedroom 2.5 bath home sits on a 5.3 acres lot. The country style kitchen opens up to the dining area. The kitchen features a breakfast area, double-oven, granite countertops, island, walk-in pantry, lots of cabinets and plenty of prep space. Spacious living room with double-sided fireplace, stunning ceiling design w/rain drop crystal chandelier. The large primary bedroom has a hug tube with a jacuzzi, two separate sinks, walk-in shower and walk-in closet. Additional office space built inside the primary room. The formal living area is open to the main living area. Beautiful marble floor in the foyer area. *New roof in June 2022, tankless waterheater, and insulated garage. The huge oasis backyard offers a great relaxation that includes a putting green and playground for entertainment. This property has lots of potential.\r\nEasy access to I-45, and near The Woodlands Mall with lots of retail shops and eatery spots. A MUST SEE!' ,`Acres` = '5.3549' ,`Area` = '15' ,`BuilderName` = 'Custom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WHITE OAK ESTATES 03, BLOCK 2, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '233259' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'White Oak Estates 03' ,`TaxAmount` = '8618' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835543' WHERE `Matrix_Unique_ID` = '214217700' --> 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','214225513','1667835543','214225513','2022-11-06T22:30:39.133','45006141','Amber Young-Gomes','Executive Real Estate','Phyllis Baudat','BHGRE Gary Greene','30.292179','-95.425212','10','77301','4','275000.00','Option Pending','Southern Oaks','1616','Drive','Conroe','2','1','4','2270','Single-Family','This beautiful, custom-built home is in the Southern Oaks Subdivision of East Conroe. The craftsmanship of this home exudes details throughout all areas, including incredible custom kitchen cabinetry, built-in shelving systems in the family areas, and a recently renovated primary bathroom. Immaculate inside and out, waiting for the next homeowner to make it theirs.','0.55','19','','','','','Sellers Disclosure','','','1','Conroe Southeast','Central Electric','0','SOUTHERN OAKS 01, BLOCK 1, LOT 3-B, 4-A, ACRES 0.550','Subdivision Lot,Wooded','23958','Appraisal District','','','0','','0','','0','','','','','Composition','11 - Conroe','RUNYAN ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Southern Oaks 01','4207','2.1863','Public Sewer,Public Water','1974','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:19:53.250' ,`MLSNumber` = '2627615' ,`ListAgentFullName` = 'Kiera Quinney' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.083440' ,`Longitude` = '-95.527933' ,`PhotoCount` = '20' ,`PostalCode` = '77379' ,`RoomCount` = '7' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Saragosa Pond' ,`StreetNumber` = '21831' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! The most gorgeous 1 story; 3-bedroom 2-bath home with a den. Architectural arches, natural paint palette,\r\nopen concept island kitchen, and granite countertops! Spacious primary with French doors to en-suite bath (tub/separate\r\nshower, dual vanities, and walk-in closet). Backyard features delightful extended patio with ceiling fan. The sale of the home\r\nwill include: refrigerator, washer/dryer, 75in. TV (with wall mount), and 55in. TV (with wall mount). Don\'t let this deal pass you by!' ,`Acres` = '0.1263' ,`Area` = '14' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 SPRING TERRACE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MUELLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Controlled Access,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Terrace' ,`TaxAmount` = '5786' ,`TaxRate` = '2.5965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835543' WHERE `Matrix_Unique_ID` = '214230684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:07:01.290' ,`MLSNumber` = '41264068' ,`ListAgentFullName` = 'Cynthia Gueta' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804940' ,`Longitude` = '-94.894657' ,`PhotoCount` = '40' ,`PostalCode` = '77523' ,`RoomCount` = '6' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Levant' ,`StreetNumber` = '2011' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1714' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!!! This is a move-in ready, 4 sided brick, single story 2020 Beazar home. This open concept floor plan features 3 bedroom, 2 full baths, and separate tub/shower in primary suite. You will also find stainless steel appliances, hurricane shutter panels inlcuded and an Outdoor covered patio perfect for a soothing evening. 5 Minutes away from local shopping, restaurants and 99.' ,`Acres` = '0.1377' ,`Area` = '53' ,`BuilderName` = 'Beazar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLK 1 LOT 16 SOUTHWINDS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '523' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwinds Sec 1' ,`TaxAmount` = '6098' ,`TaxRate` = '2.8882' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835544' WHERE `Matrix_Unique_ID` = '214234662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:11:38.150' ,`MLSNumber` = '75474518' ,`ListAgentFullName` = 'Eric Haugen' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707388' ,`Longitude` = '-95.773547' ,`PhotoCount` = '37' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade Springs' ,`StreetNumber` = '22747' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'JUST LISTED!! You must see this luxurious Perry Home nestled in the elegant master plan community of Grand Lakes! Just minutes from Grand Parkway-99, Westpark 1093, and I-10, this 2,540 SqFt home has a Formal Dining Room, spacious garage, high 2-story ceilings in the Living Room, and an enormous backyard Covered Patio! You\'ll love the open floorplan and the layout of the Master Bedroom DOWNstairs, with the Game Room plus additional 3 bedrooms all UPstairs! Low tax rate of 2.46, Katy mailing address, zoned to Alexander Elementary, Beckendorff Junior High, and Seven Lakes High School! The community has pools, playgrounds, tennis courts, and lots of sidewalks and lakes to enjoy relaxing walks. Not on a Flood Plain and has NEVER flooded!' ,`Acres` = '0.1659' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKES SEC 10, BLOCK 3, LOT 48' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lakes Sec 10' ,`TaxAmount` = '6810' ,`TaxRate` = '2.4613' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835544' WHERE `Matrix_Unique_ID` = '214238002' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:47:47.673' ,`MLSNumber` = '92169934' ,`ListAgentFullName` = 'Ronald Linton' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Tarek Boulbol' ,`SellingOfficeName` = 'Texas Premier Realty' ,`Latitude` = '28.706133' ,`Longitude` = '-96.222710' ,`PhotoCount` = '10' ,`PostalCode` = '77465' ,`RoomCount` = '6' ,`ListPrice` = '40000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Moore' ,`StreetNumber` = '908' ,`StreetSuffix` = 'Avenue' ,`City` = 'Palacios' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home Is Located On A Street That Many Homes That Have Been Upgraded & Well Cared For* This Home Needs A Lot of Work & Is Being Sold As Is. The Home Is On A Large Yard. Great Room Sizes.' ,`Acres` = '0.172' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'PALACIOS ORIGINAL TOWN LOT 5 BLK 92' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '156 - Palacios' ,`SchoolElementary` = 'CENTRAL ELEMENTARY SCHOOL (PALACIOS)' ,`SchoolHigh` = 'PALACIOS HIGH SCHOOL' ,`SchoolMiddle` = 'PALACIOS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Palacios Original Townsite' ,`TaxAmount` = '1580' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835544' WHERE `Matrix_Unique_ID` = '214300740' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:32:58.950' ,`MLSNumber` = '89990092' ,`ListAgentFullName` = 'Trinh Le' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689789' ,`Longitude` = '-95.635763' ,`PhotoCount` = '17' ,`PostalCode` = '77083' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Beech Glen' ,`StreetNumber` = '14138' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MULTIPLE OFFERS SITUATIION. HIGHEST AND BEST OFFER BY 6PM MONDAY 11/07/2022. Lovely 4 bed/2.5 bath 2 story home in highly sought-after Beechnut Meadows neighborhood. ROOF 2019. Beautiful wood and laminate flooring (no carpet!). All bedrooms up. Kitchen opens up to living room. NO BACK NEIGHBOR. LOW TAX RATE. EXCELLENT LOCATION: conveniently located within minutes to Highway 6/Westpark Tollway, 12 minutes to Hong Kong 4 market/Chinatown, minutes to all the shopping/popular restaurants/markets on HW6 and Bellaire Blvd., 30m to downtown/medical center. Come check it out before it\'s gone!' ,`Acres` = '0.09' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 1 BEECHNUT MEADOWS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '453' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HICKS ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Beechnut Meadows' ,`TaxAmount` = '4204' ,`TaxRate` = '2.5785' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835544' WHERE `Matrix_Unique_ID` = '214303920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:10:24.117' ,`MLSNumber` = '35153935' ,`ListAgentFullName` = 'Autumn Osborne' ,`ListOfficeName` = 'Houston Borne Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649877' ,`Longitude` = '-95.504411' ,`PhotoCount` = '15' ,`PostalCode` = '77035' ,`RoomCount` = '3' ,`ListPrice` = '168000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandpiper' ,`StreetNumber` = '11835' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sold AS-IS - Where-Is, This Charming single-story brick home in Arbor Meadow - 3 beds, 2 full baths & 2-car attached garage. Perfect investment property or fixer-upper. Great floor plan offers spacious family room w/soaring vaulted ceiling & charming brick fireplace. Kitchen boasts breakfast bar & breakfast space for ample seating. Spacious Primary Suite w/en-suite bath & his/her closet. Back patio for outdoor entertaining with storage shed. Foundation issues exist. Seller will make no repairs. Call to schedule your appointment. HIGHEST and BEST due on Monday, November 7, 2022 by 5pm.' ,`Acres` = '0.1148' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 2 ARBOR MEADOW' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Arbor Meadow' ,`TaxAmount` = '2631' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835545' WHERE `Matrix_Unique_ID` = '214304920' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:54:08.830' ,`MLSNumber` = '19944462' ,`ListAgentFullName` = 'Lori Van Joslin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147006' ,`Longitude` = '-95.540036' ,`PhotoCount` = '42' ,`PostalCode` = '77389' ,`RoomCount` = '10' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = 'Canoe Bend' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful family home situated on lot adjacent to greenbelt in the highly sought-after community of Creekside Park, The Woodlands. 4 BEDS/3.5 BATHS Great curb appeal w/professional landscaping, welcoming entry W/stone/stucco exterior. Friendly floorplan features huge kitchen that open to breakfast & family room. Formal dining room, home office, grand size kitchen island with breakfast bar, tons of storage cabinets & prep space with extended butler\'s pantry/countertops, large walk-in kitchen pantry & GE stainless steel appliances. Owners\' suite with huge walk-in closet & gorgeous bath. Builder upgraded bathrooms have framed mirrors, stained cabinets & granite countertops. Upstairs 2 full baths, 3 bedrooms plus game room. Outdoor living highlights are front & back covered patios & big backyard. Energy Star certified home, High efficiency HVAC, radiant attic barrier & double pane insulted windows. Lawn maintenance included. Minutes to all major Woodlands amenities & Tomball schools!!' ,`Acres` = '0.1536' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 2 THE WOODLANDS VLG OF CREEKSIDE PARK 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6689' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKSIDE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park 24' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835545' WHERE `Matrix_Unique_ID` = '214340864' --> 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','214364136','1667835545','214364136','2022-11-06T21:11:53.843','3053956','Steven Collier','BHGRE Gary Greene','','','30.403243','-95.666407','50','77356','10','1150000.00','Active','Renaissance','11618','Drive','Montgomery','4','0','5','4049','Single-Family','AMAZING WATERFRONT property on just over 1/2 ACRE located on The Island in Grand Harbor!!! BACKYARD PARADISE with ample patio space, OUTDOOR KITCHEN, and heated pool/spa. This home is a 5 bed, 4-bath home with a 3-car garage. Open concept home featuring transitional style kitchen, MASSIVE QUARTZ ISLAND, upgraded finishes, and perfect for entertaining! The family room has a sliding glass door that leads out to the pool area, perfect for indoor/outdoor entertaining. The primary bedroom has a view of the lake - an oversized shower, a large soaking tub, dual vanities with plenty of storage. The primary closet leads to the laundry room. HIGH-END finishes include plantation shutters, Generac GENERATOR, and extensive concrete around the pool, house, and to the boat dock. DON\'T MISS THIS OPPORTUNITY FOR A LIKE-NEW HOME. Highly acclaimed Montgomery ISD.','0.5452','39','','','','','No Disclosures','1','Gas Connections,Wood Burning Fireplace','1','Lake Conroe Area','Central Gas','1','S616400 - THE ISLAND AT GRAND HARBOR, BLOCK 1, LOT 10, ACRES','Waterfront','23751','Appraisal District','','1200','0','','3','Electric Oven','1','Heated,In Ground','','Gas Cooktop','','Tile','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1.5','Contemporary/Modern,Traditional','The Island At Grand Harbor','14395','1.8242','Public Water,Septic Tank','2020','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:02:51.150' ,`MLSNumber` = '32146649' ,`ListAgentFullName` = 'Holley Madden' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.753757' ,`Longitude` = '-95.564099' ,`PhotoCount` = '31' ,`PostalCode` = '77042' ,`RoomCount` = '10' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Holly Springs' ,`StreetNumber` = '10614' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2215' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully upgraded with designer finishes, this incredible 4/2 is filled with top-of-the-line finishes, Quartz countertops, wood flooring throughout, professional-grade appliances, designer fixtures, and lighting. All new electrical, plumbing, AC, pex pipes. The open-concept floorplan is filled with natural light. Enjoy a fully updated kitchen with abundant storage including pantry, and plenty of prep space-ready for any cooking enthusiast. Breakfast room just off the kitchen boasts access to the spacious backyard. The extensive upgrades continue to the primary suite featuring a shower, double sinks, tasteful light fixtures, and large walk-in closet. Guest bedrooms share upgraded guest bath with tub/shower. Backyard features no shortage of green space. Did not flood! (All per seller).' ,`Acres` = '0.2149' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 25 WALNUT BEND SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Bend' ,`TaxAmount` = '7471' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835545' WHERE `Matrix_Unique_ID` = '214367181' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:45:38.447' ,`MLSNumber` = '33788167' ,`ListAgentFullName` = 'Paul Compton' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.925972' ,`Longitude` = '-95.173417' ,`PhotoCount` = '34' ,`PostalCode` = '77044' ,`RoomCount` = '9' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Brighton Park' ,`StreetNumber` = '13815' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2138' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located just minutes from the Beltway and downtown Houston, yet located in a quiet subdivision, this updated home is exactly what you have been looking for! This home has everything you would expect from the welcoming front porch with sitting area to high ceilings, open-concept floor plan, luxury vinyl plank flooring, gas log fireplace, and modern light fixtures. The recently updated kitchen includes new quartz counters, new backsplash, large kitchen island, and stainless appliances. In the spacious primary suite, you will find double sinks with vanity area, frameless glass shower, soaker tub, and large walk-in closet. And in addition to the 3 spacious bedrooms there is also a dedicated office with French doors for privacy. The exterior features a large, covered patio and accommodating backyard – the perfect place to relax and grill. Only a short walk to the nearby elementary school and no flooding ever, this incredible opportunity is now ready for you!' ,`Acres` = '0.1769' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 SUMMERWOOD SEC 11' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7704' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood' ,`TaxAmount` = '6180' ,`TaxRate` = '2.733' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835545' WHERE `Matrix_Unique_ID` = '214392840' --> 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','214398132','1667835545','214398132','2022-11-06T22:35:40.437','44655894','Stacey Calderon','Red Door Realty & Associates','','','30.036499','-95.228559','26','77339','3','430000.00','Active','Walnut','1717','Lane','Houston','2','0','3','2059','Single-Family','WOW, ABSOLUTE MUST SEE!!! ONE STORY HOME NESTLED ON LARGE CORNER LOT ESTABLISHED NEIGHBORHOOD IN THE FRONT OF KINGWOOD WITH EASY ACCESS TO 59 NORTH AND KINGWOOD DRIVE. THIS HOME SITS ON OVER AN ACRE WITH A POOL, DETACHED 3 CAR GARAGE WITH 3 CAR-CARPORT AND LOTS OF SPACE FOR PARKING, STORAGE BUILDING. ALL THIS AND LOCATED APROXIMATELY 30 MINUTES FROM DOWNTOWN HOUSTON. THIS PROPERTY IS BEING SOLD AS IS - NO REPAIRS. PLEASE MEASURE ALL ROOMS FOR ACCURACY - DON\'T DELAY CALL TODAY!','1.0191','32','','','','','Estate,Probate','1','','','Kingwood West','Central Gas','1','LT 9 BLK 33 FOREST COVE SEC 5 U/R','Corner,Subdivision Lot','44390','Appraisal District','','160','0','','3','','1','In Ground','','Freestanding Range,Gas Range','','Composition','29 - Humble','FOSTER ELEMENTARY SCHOOL (HUMBLE)','KINGWOOD PARK HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Forest Cove Sec 05 U/R','6709','2.5839','Public Sewer,Public Water','1971','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T22:28:21.920' ,`MLSNumber` = '58333347' ,`ListAgentFullName` = 'Ahmad Farooqi' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822050' ,`Longitude` = '-95.395426' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = '40th' ,`StreetNumber` = '310A' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This new construction, modern-farmhouse style, three bedroom, two and a half bath house features impeccable finishes throughout, a soft monochromatic palette and clean lines, and the spacious back yard, which is perfect for relaxing after a long day at work or kids to play. In the chef’s kitchen, there are stainless steel Samsung appliances, dovetail soft close cabinets, and a wine refrigerator. And upstairs, the ensuite primary bath features a stand-alone tub, spacious enclosed shower, and a walk-in closet. Conveniently located minutes from downtown, the galleria and heights restaurants and shopping. Pictures are renderings and approximate images. This house will be ready for move-in in Nov 2022!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Ranar Pines' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 9 BLK 5 INDEPENDENCE HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Independence Heights' ,`TaxAmount` = '3605' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1667835545' WHERE `Matrix_Unique_ID` = '214407706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-06T21:24:09.610' ,`MLSNumber` = '59749859' ,`ListAgentFullName` = 'Nicole Hohman' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.559076' ,`Longitude` = '-95.749572' ,`PhotoCount` = '24' ,`PostalCode` = '77469' ,`RoomCount` = '6' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Olive' ,`StreetNumber` = '2906' ,`StreetSuffix` = 'Way' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2469' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous custom Pulte home on a corner lot located in the premier Del Webb 55+ Community. Showcasing amazing upgrades to include brand new paint, baseboards, Coretec Plus Flooring, & all LED lighting. 3 beds, 2.5 baths plus a study & an open floorpan throughout the living room & kitchen. The kitchen offers a recently installed island, Cambrian quartz countertops, new light pendants, glass tile backsplash, under cabinet lighting, bar seating & a breakfast nook. The primary retreat is a generous size w/an oversized shower, soaking tub, dual sinks, vanity space & a walk-in closet. A bonus screened in porch w/tiled floors & plumbed for an outdoor kitchen. A whole house Generator system included, commercial grade irrigation system & oversized garage. Stunning stone & brick facade w/a huge front Travertine tiled patio. Check out the lake house with a number of amenities to select from such as a gym, ballroom, clubhouse, indoor/outdoor pool, & tennis courts. Find your Happy here at Del Webb!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'DEL WEBB RICHMOND SEC 4, BLOCK 2, LOT 7, 50.000000% UDI' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8692' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb' ,`TaxAmount` = '295' ,`TaxRate` = '5101' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667835546' WHERE `Matrix_Unique_ID` = '214410778' --> 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','214452539','1667835546','214452539','2022-11-06T22:53:53.873','3064580','Randall Peraza-Borbon','Vylla Home','','','28.986401','-95.954456','20','77414','3','124900.00','Active','10th','3002','Street','Bay City','3','0','3','2276','Single-Family','Large two story home with lots of space, for a total of 3036 Sq. Ft, of living space. Main living area one has approximately 2,276 Sq Ft. and living area two has about 760 Sq. Ft., Living area two has a large office/extra bedroom. Main living area one features three bedrooms and two bathrooms with one car port. Located not too far from Tennie Holmes Elementary. Near all amenities, shopping, and entertainment in the heart of Bay City, Texas.','0.1091','54','','','','','Real Estate Owned','','','','','Central Gas','0','SILVER HEIGHTS, BLOCK 6, LOT 12 (W-73\') + (S 22\' X 50\' OF LO','Subdivision Lot','4752','Appraisal District','','','0','','0','','0','','','','','Composition','132 - Bay City','TENIE HOLMES ELEMENTARY SCHOOL','BAY CITY HIGH SCHOOL','BAY CITY JUNIOR HIGH SCHOOL','Temporarily No Showings','Appraisal District','2','Traditional','Silver Heights','3436','2.8238','Public Sewer,Public Water','1963','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','214466856','1667835546','214466856','2022-11-06T21:17:21.700','80243877','Christopher Davidson','Walzel Properties','','','29.238473','-94.906786','27','77554','4','269000.00','Active','Sonny','2818','Lane','Galveston','1','0','3','1092','Single-Family','Fully remodeled 3 bed, 1 bath home in the heart of Galveston! 4 minutes away from the Beach! This beautiful gem was stripped to the studs and refurbished with all new Electrical, Plumbing, A/C, Flooring, Cabinets in the bathroom and kitchen and much more! Sitting on a +13,000sqft Lot ,this property has endless potential! Aluminum roof, new light fixutres, tile and all new appliances in the kitchen include a gas range and stove! Brand new patio deck in the backyard to relax with friends & family. The opportunity to own a fully remodeled home in Galveston are few and far between so call now to schedule a viewing today!','0.305','33','','','','','Sellers Disclosure','1','','','West End','Central Electric','0','ABST 121 HALL & JONES SUR LOT 8 SONNY LANE UNRECORDED SUB','Cleared,Subdivision Lot','13286','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Aluminum','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Lockbox Front','Appraisal District','1','Traditional','Sunnylane Unrec T&L Sec 2','3147','2.0324','Public Water,Septic Tank','1945','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','214467114','1667835546','214467114','2022-11-06T21:58:38.953','65857057','Latisha Bradshaw','Texas Diamond Realty','','','29.537562','-95.122646','9','77598','6','480000.00','Active','Hubert','323','Street','Webster','2','1','2','2575','Single-Family','Welcome to the heart of Webster! This home boasts so much potential with 2 bedrooms and 3 baths (two inside the home and one located in garage) Sitting on a double corner lot, this classic comes with custom built-in cabinets and china cabinets through out the entire home. Huge open living room to entertain your guests. Light the fire and relax by the gorgeous fireplace. The back yard is completely fenced with a small shed in the back. It has an attached sunroom which could be a green house. Comes with an on site generator. Completely fenced with custom gates. Fruit bearing tree in the front yard with different foliage all over the property. The storage area above the garage is large enough to convert to another room if you wanted. There’s 2 carports on each side of the property , one is for an RV with complete hookups. There is a 2 car double garage, and a one car separate garage. This home won’t last long. Schedule your showing now.','0.4304','7','','','Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections','1','Clear Lake Area','Central Gas','0','LTS 7 & 8 BLK 38 WEBSTER','Cleared,Corner','18750','Appraisal District','','','0','','3','Gas Oven','0','','','Gas Range,Grill','','Composition','9 - Clear Creek','MCWHIRTER ELEMENTARY SCHOOL','CLEAR CREEK HIGH SCHOOL','CLEAR CREEK INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Webster','7765','2.1594','Public Sewer,Public Water','1989','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214470371','1667835546','214470371','2022-11-06T21:57:00.007','17949874','Stephanie Lambrecht','EXIT Lone Star Realty','','','30.049742','-95.450996','34','77388','11','325000.00','Active','Holly Walk','2703','Lane','Spring','2','0','3','2040','Single-Family','You\'ve got to see this house! All new interior paint. Brand new Silestone Countertops in the kitchen and guest bath. Kitchen cabinets just painted and new lighting! Light and bright, open floor plan. Wood blinds throughout the home. 3 Bedroom/2 full bath one story in Devonshire Woods. This home is in a private cul de sac and is zoned for Klein ISD! You\'ll enjoy a neighborhood park with shaded walking trails and a pool. You will love the mature trees! The living areas have wood floors and the bedrooms are carpeted. The primary bathroom was renovated with lighting, new cabinets, counters and double sinks in 2021. The guest bath was renovated in 2019. New roof in 2021. You\'ll love the big kitchen with an island and gas stove. The pantry will hold everything you need and more. There is a designated study and formal dining. This home is perfect for entertaining. Make your appointment to see it today.','0.1993','13','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Spring/Klein','Central Gas','1','LT 19 BLK 4 DEVONSHIRE WOODS SEC 3','Cul-De-Sac','8681','Appraisal District','','520','0','','2','Gas Oven','0','','','Gas Range','','Composition','32 - Klein','LEMM ELEMENTARY SCHOOL','KLEIN COLLINS HIGH SCHOOL','STRACK INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Devonshire Woods Sec 03','5660','2.534','Water District','1999','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214472303','1667835546','214472303','2022-11-06T21:13:41.713','13991988','Alma Puerto','Texas Fast Realty','','','30.214426','-95.322123','27','77302','3','173000.00','Active','Hill Country','16458','Drive','Conroe','2','0','3','1344','Single-Family','Great corner location next to park waiting to be your next home. Perfect of first time home buyer or Investor looking to add a great rental to a portfolio. Recently updated, priced to sell New AC.','0.4132','19','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','','Conroe Southeast','Central Electric','1','LONE STAR RANCH 03, BLOCK 6, LOT 1, MH SERIAL # TXFL112A8471','Subdivision Lot','18000','Appraisal District','','175','0','','1','Electric Oven','0','In Ground','','Electric Range','','Composition','11 - Conroe','SAN JACINTO ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Lockbox Front,No Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Lone Star Ranch 03','2281','1.8488','Public Sewer,Public Water','2001','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214473135','1667835546','214473135','2022-11-06T21:54:08.347','22130406','Julia Pecina','Camelot Realty','','','29.841126','-95.311543','21','77016','4','205000.00','Active','Dandy','8810','Street','Houston','3','0','4','1683','Single-Family','CALLING ALL INVESTORS!! NEW LEASES IN PLACE- CASH FLOWING PROPERTY. Back house (415 sq ft) is 1/1 renting for $725/month and front house (1268 sq ft) is 3/2 renting for $1,400. Square footage listed encompasses both properties. Total rent is $2,125 and leases end November 2023 (will auto-renew).\r\nLess than 15 minutes from Downtown, this recently updated home has new vinyl flooring, carpet, paint, lighting, electric work, & plumbing. The updated kitchen features new countertops, backsplash, and flooring leading to a spacious breakfast/dining room. \r\nThere isn\'t an easier passive investment out there! This area is growing!','0.1653','2','','','','','Sellers Disclosure','','','','Northside','Central Gas','0','LT 5 BLK 1O NORTH SHADYDALE','Other','7200','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','COOK ELEMENTARY SCHOOL (HOUSTON)','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Seller','1','Other Style','North Shadydale','1968','2.3307','Public Sewer,Public Water','1950','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','214473594','1667835546','214473594','2022-11-06T22:40:09.547','33544380','Jason Vo','Walzel Properties','','','30.033153','-95.530418','28','77379','9','355000.00','Active','Mystic Morning','7107','Lane','Spring','2','1','3','2148','Single-Family','Welcome to a beautiful two stories home with 3 beds, 2 and a half-bath, 2 car garage, nice size yard, and no back neighborhood. Located in Klein Grove community built by HistoryMaker Homes conveniently located between Spring Cypress and Louetta with easy access to I-45 and The Grand Parkway, making the commute to The Woodlands, George Bush International Airport, and the Exxon/Mobil campus quick and easy. This beautiful Gladewater Plan with over $25,000 upgrade boasts a chef-inspired kitchen with 42\" white cabinetry, crown molding, stainless-steel Whirlpool appliances, stunning quartz countertops, and a corner walk-in pantry, and a large island. Luxury vinyl plank flooring throughout the first floor. All bedrooms are located on the second floor and the master suite features a large walk-in closet, dual sinks, a garden tub, and a separate shower. A beautiful home, a good school district, a convenient location, and an incredibly low tax rate. CALL NOW FOR A PRIVATE SHOWING.','0.1268','13','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Champions Area','Central Gas','1','LT 44 BLK 1 KLEIN GROVE','Cul-De-Sac,Subdivision Lot','5523','Appraisal District','','600','0','','2','Gas Oven','0','','','Electric Cooktop,Gas Range','','Composition','32 - Klein','EHRHARDT ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Klein Grove','6092','2.5085','Public Sewer,Public Water,Water District','2019','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','214473635','1667835546','214473635','2022-11-06T22:34:58.553','72083962','Charles Miller','RE/MAX Lake Livingston','','','30.610081','-95.168005','13','77331','3','150000.00','Active','Creek','271','Lane','Coldspring','2','0','3','1120','Single-Family','2.4 unrestricted acres in Coldspring. 3/2 Manufactured home, storage building, fenced, mostly wooded, very private and quiet. Roughly 1 hour North of Houston','2.402','64','','','','','Sellers Disclosure','','','','Coldspring/South San Jacinto County','Window Unit','0','DOVE CREEK, LOT 67, ACRES 2.402','Wooded','104631','Appraisal District','','','0','','0','','0','','','','','Composition','101 - Coldspring-Oakhurst Consolidated','JAMES STREET ELEMENTARY SCHOOL','COLDSPRING-OAKHURST HIGH SCHOOL','LINCOLN JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Dove Creek','474','1.6254','Septic Tank','1992','Appraisal District'); --> New record created successfully