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-09-20T23:42:09.483' ,`MLSNumber` = '45324625' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471078' ,`Longitude` = '-95.510416' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '724572.00' ,`Status` = 'Active' ,`StreetName` = 'Camille Park' ,`StreetNumber` = '1918' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 45324625 - Built by Toll Brothers, Inc. - September completion! ~ The popular 1.5 story Turner plan is filled with amazing features. The covered entry leads into a dramatic foyer with two-story ceiling. Glass doors and sloped ceiling in the office give an elegant yet private feel and is large enough for two work spaces. Your guests will appreciate the bedroom suite with full bath and walk-in closet just off the great room. Enjoy entertaining on movie night in the media room or relaxing in the upstairs flex/game room. The great room features 12-foot ceilings and is open to a desirable kitchen with large island, an abundance of cabinets, butler\'s pantry and walk-in pantry. The casual dining area is conveniently located off the kitchen with views to the backyard. A secluded and relaxing primary bedroom includes a tray ceiling and en-suite with a luxurious freestanding tub, ultra shower and spacious walk-in closet. Located in acclaimed Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9511' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = '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` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Sienna - Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794255' WHERE `Matrix_Unique_ID` = '199716300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:42:38.250' ,`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` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 9 Blk 3' ,`LotDesciption` = 'Corner,Other' ,`LotSize` = '11718' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`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,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794255' WHERE `Matrix_Unique_ID` = '200571208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:43:05.877' ,`MLSNumber` = '27972860' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472116' ,`Longitude` = '-95.510829' ,`PhotoCount` = '16' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '699061.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Oak' ,`StreetNumber` = '10515' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 27972860 - Built by Toll Brothers, Inc. - Ready Now! ~ The Watson High Plains plan is a single-story plan with room to grow. The stucco and stone exterior provides curb appeal and welcomes you home. The covered entry opens to the foyer with tray ceiling. Two spacious secondary bedrooms and shared hall bath are split from the activity of the main living space. A secluded office with double-door entry provides an excellent remote working space. The gourmet kitchen features a casual dining room, and large center island with view to the great room. A breathtaking sloped ceiling in the great room extends onto the covered patio that can be accessed by 15-foot sliding glass doors that expand entertaining space to outdoor living space. Host game night in the game room just off the main living area. Guest will appreciate the bedroom suite with full bath. The primary bedroom offers privacy and includes an expanded shower and oversized walk-in closet. Dreams can come true!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9483' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sienna Select' ,`TaxAmount` = '' ,`TaxRate` = '3.72' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794255' WHERE `Matrix_Unique_ID` = '202874347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:52:00.360' ,`MLSNumber` = '76432475' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.468092' ,`Longitude` = '-95.525340' ,`PhotoCount` = '17' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '549672.00' ,`Status` = 'Active' ,`StreetName` = 'Rustling Creek' ,`StreetNumber` = '1715' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76432475 - Built by Toll Brothers, Inc. - September completion! ~ The Waller Mission boast curb appeal with the stylish stucco exterior with shutters and covered entry. The impressive two-story foyer with tray ceiling flows into the secluded office with double doors. A spacious great room offers a multi-slide door that opens to an expanded back patio. The grand and private back yard has plenty of room for a future pool and outdoor recreational activities. The gourmet kitchen features a casual dining room, walk-in pantry and island that overlooks the great room. The first-floor primary bedroom includes dramatic sloped ceilings and ensuite bath with dual vanities, free standing tub with separate shower and walk-in closet with convenient access to the utility room. Additional highlights are three spacious bedrooms, one with private bath, shared hall bath and a loft overlooking the great room!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Blk 2' ,`LotDesciption` = 'Greenbelt,Other,Subdivision Lot' ,`LotSize` = '8693' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`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.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794255' WHERE `Matrix_Unique_ID` = '202961781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:44:09.353' ,`MLSNumber` = '60947278' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472147' ,`Longitude` = '-95.510670' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '724855.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Oak' ,`StreetNumber` = '10519' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 60947278 - Built by Toll Brothers, Inc. - September completion! ~ The stunning Langdon Transitional is a two-story home that offers a spacious open concept. This home features a spacious guest bedroom on the main floor and a luxurious primary bedroom with sloped ceiling and en-suite with dual sinks, freestanding tub, and roomy walk-in closet. A generous office space makes for a great place for remote work or study. The generous cabinet and counter top space in the kitchen, is what makes this home perfect for any sized party. Atop the curved staircase, you will enjoy a large game/flex room and private media room with two secondary bedrooms and full bath. Filled with craftsmanship and quality you expect, with the luxury and premium finishes you deserve!!' ,`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` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 11 blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9244' ,`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 - Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794255' WHERE `Matrix_Unique_ID` = '202968197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:19:12.533' ,`MLSNumber` = '72418021' ,`ListAgentFullName` = 'Kristina Santana' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.352438' ,`Longitude` = '-95.080853' ,`PhotoCount` = '25' ,`PostalCode` = '77327' ,`RoomCount` = '2' ,`ListPrice` = '119000.00' ,`Status` = 'Active' ,`StreetName` = 'Church' ,`StreetNumber` = '1217' ,`StreetSuffix` = 'Avenue' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming updated 2 bedroom 1 bath home. 1 year old appliances, new flooring, new paint. Kitchen has brand new Granite counter tops, beautiful white cabinets and white tile back splash. New stack-able washer and dryer. Updated restroom. Large backyard.' ,`Acres` = '0.1607' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'SMITH-CLEV, BLOCK A, LOT 5, ACRES .1607' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Smith-Clev' ,`TaxAmount` = '1648' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794256' WHERE `Matrix_Unique_ID` = '203243019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:23:03.647' ,`MLSNumber` = '31806654' ,`ListAgentFullName` = 'Kristina Santana' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.386948' ,`Longitude` = '-94.980329' ,`PhotoCount` = '20' ,`PostalCode` = '77591' ,`RoomCount` = '4' ,`ListPrice` = '109000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodrow' ,`StreetNumber` = '6113' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING HOME! FULLY RENOVATED, WOOD FLOOR THROUGH THE WHOLE HOUSE, 2 BEDS 1 BATH, SPACIOUS MASTER BEDROOM, FULL BATH , LARGE LIVING ROOM FOR FAMILY ENTERTAINING, NICE KITCHEN WITH STAIN-LESS STEEL APPLIANCES, WAHER &DRYER ARE INCLUDED. LARGE PATIO FOR CHILDREN ACTIVITIES AND SUMMER PARTIES. THIS HOME IS CONVENIENT LOCATED CLOSE TO FWY, SHOPPING CENTERS AND RESTAURANTS. CALL/TEXT' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 197 M AUSTIN SUR LOT 43 WRIGHT CUNEY SUB' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'SIMMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wright Cuney' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794256' WHERE `Matrix_Unique_ID` = '205081300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:44:37.933' ,`MLSNumber` = '31786152' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150766' ,`Longitude` = '-95.585521' ,`PhotoCount` = '22' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '1039979.00' ,`Status` = 'Active' ,`StreetName` = 'Tynan Ridge Drive' ,`StreetNumber` = '8522' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 31786152 - Built by Toll Brothers, Inc. - December completion! ~ The Venetian Calais plan offers luxurious style and design. The impressive exterior featuring a porte cochere with motor court, 3-car split garage, and covered front porch and patio, makes for great curb appeal. The foyer provides elegance with it\'s curved staircase, two-story ceilings, and views into the formal dining room. A private office and bedroom suite off the foyer provide convenience of remote working and solitude for guests. Entertaining is easy in the open concept kitchen and great room. The primary suite includes a tray ceiling, and luxurious bath with freestanding tub, large vanity with double sinks, separate shower and huge walk-in closet. Upstairs, you will find a spacious flex-game room and media room, along with three generous bedrooms with full baths!!' ,`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` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Blk 3' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '12850' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`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` = 'Other Style' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794256' WHERE `Matrix_Unique_ID` = '205387513' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:11:49.323' ,`MLSNumber` = '29034348' ,`ListAgentFullName` = 'Traci Ethington' ,`ListOfficeName` = 'Covenant Properties RealEstate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.164386' ,`Longitude` = '-95.630214' ,`PhotoCount` = '15' ,`PostalCode` = '77486' ,`RoomCount` = '9' ,`ListPrice` = '464900.00' ,`Status` = 'Active' ,`StreetName` = 'Amherst' ,`StreetNumber` = '316' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2450' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful new-built home has been built by a local builder. This is a 4/5 bedroom, 2 1/2 bath house with a large upstairs game room/media room and computer/study niche off the landing area. The spacious kitchen has granite counters on custom-built cabinets with soft-close doors, and the kitchen opens to the large living area. The great room will feature surround sound speakers. All bathrooms will have granite countertops. The house has PEX plumbing and spray-foam insulation for extra insulating for the summer months. The primary bath has a jetted tub and separate shower. The primary bedroom has 2 walk-in closets. There is a laundry chute directly into the utility room. This house backs up to the green space which was part of the golf course so there are no back neighbors, and there is a separate garage for the golf cart. There will be amenities not found in other homes in the area. The completion should be by 9/30/2022. Make an appointment to see all that this house has to offer.' ,`Acres` = '0.2296' ,`Area` = '5' ,`BuilderName` = 'Randy Roberts Constr' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 4 (A0133 M VARNER) BLK 41 LOT 38' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '328' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794256' WHERE `Matrix_Unique_ID` = '205530585' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:55:46.917' ,`MLSNumber` = '95199340' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.411858' ,`Longitude` = '-95.057373' ,`PhotoCount` = '9' ,`PostalCode` = '77568' ,`RoomCount` = '4' ,`ListPrice` = '399990.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Flora' ,`StreetNumber` = '13017' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 95199340 - Built by Highland Homes - September completion! ~ Two Bedrooms downstairs! Completely Upgraded Kitchen features Painted Cabinets with Hardware, Pendant Lighting, Silestone Countertops, and Built-in Stainless Steel Appliances! Tile plank flooring is featured throughout the common area of the first floor! And as always, our ‘Smart from the Start’ Technology Package!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6 BLK 2 LAGO MAR POD 5 SEC 3 (2021) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794256' WHERE `Matrix_Unique_ID` = '205757180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:56:13.357' ,`MLSNumber` = '23996280' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471816' ,`Longitude` = '-95.529276' ,`PhotoCount` = '49' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '679996.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Bridge' ,`StreetNumber` = '8922' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 23996280 - Built by Highland Homes - Ready Now! ~ Soaring 13\' ceilings, natural light & functional design. Double door entry! Open concept living space. Chef\'s dream kitchen with custom hutch & 12\' island which opens to family room. Sliding glass doors lead out to the extended covered patio. Study & media room included! Grand double door entry! Elegant fireplace in family. Exterior stone and painted brick! New smart home package included. Pool sized lot!!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13, Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9286' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794256' WHERE `Matrix_Unique_ID` = '205923344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:56:39.220' ,`MLSNumber` = '43794789' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.210055' ,`Longitude` = '-95.329848' ,`PhotoCount` = '28' ,`PostalCode` = '77302' ,`RoomCount` = '6' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Bird of Paradise' ,`StreetNumber` = '15823' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1968' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 43794789 - Built by Highland Homes - Ready Now! ~ Gorgeous open concept home with a stunning black and white interior! The kitchen is the center staple of this home with a large curved island open to both dining and living areas, including a cozy fireplace. Outside you have large covered patio. Tucked away are the secondary bedrooms and the primary bedroom featuring a gorgeous bay window overlooking the backyard. This a smart home with a tankless water heater, wifi thermostat, doorbell camera and garage door opener!!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'lot 4; block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5929' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia 45\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794256' WHERE `Matrix_Unique_ID` = '206407194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:52:00.360' ,`MLSNumber` = '32167895' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979811' ,`Longitude` = '-95.746001' ,`PhotoCount` = '12' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '734522.00' ,`Status` = 'Active' ,`StreetName` = 'Via Santa Caterina' ,`StreetNumber` = '20719' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 32167895 - Built by Toll Brothers, Inc. - Ready Now! ~ New Plan! The Indio Transitional plan offers single-level living at it\'s finest. A split plan with two generous secondary bedrooms and hall bath at the front of the home. A private office with dramatic sloped ceiling and double door entry is perfect for remote work. A sizable guest suite with full bath and walk-in closet is ideal for overnight guests or multi-generational living. Entertaining is easy in the private media room with easy access to the butler\'s pantry for snacks. An open concept great room is overlooked by a chef inspired kitchen and casual dining space. Expand your living space outdoors by opening the multi-slide doors from the great room onto the expanded covered patio. End the day soaking in the freestanding tub in the primary bath!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 38 Blk 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9417' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794257' WHERE `Matrix_Unique_ID` = '206621752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:52:00.360' ,`MLSNumber` = '95066896' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.978895' ,`Longitude` = '-95.746621' ,`PhotoCount` = '7' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '749462.00' ,`Status` = 'Active' ,`StreetName` = 'Via Del Obispo' ,`StreetNumber` = '20719' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 95066896 - Built by Toll Brothers, Inc. - Ready Now! ~ Now open! Our popular Belmore High Plains plan offers single-story living with room for everyone. This amazing home features 4 spacious bedrooms, private media room and additional flex space that could be used for a home office, gym, playroom and beyond. The open concept kitchen comes complete with center island, stainless steel appliances and walk-in pantry. The great room boasts a 17-foot sloped ceiling with electric fireplace and 12-foot multi-slide door the opens to the covered patio, expanding entertaining space. A relaxing primary bedroom includes a spacious walk-in closet and en-suite with freestanding tub, separate shower, double sinks and linen closet. This impressive house is ready for you to call it home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Blk 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9254' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794257' WHERE `Matrix_Unique_ID` = '206622040' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:46:06.260' ,`MLSNumber` = '76306361' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.644255' ,`Longitude` = '-95.027607' ,`PhotoCount` = '30' ,`PostalCode` = '77571' ,`RoomCount` = '10' ,`ListPrice` = '379487.00' ,`Status` = 'Active' ,`StreetName` = 'Lucky Manor' ,`StreetNumber` = '167' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76306361 - Built by HistoryMaker Homes - Ready Now! ~ This 5 bedroom, 3 full bathroom, two-story home boasts 9\' ceilings throughout the 1st floor. Luxury vinyl plank can be found in the common areas and all baths. The chef-inspired kitchen offers 42-inch white cabinetry with crown molding, ceramic tile backsplash, granite countertops, a corner walk-in pantry, and stainless-steel appliances that make entertaining easy. Settle into the spacious primary bedroom located on first floor and bathroom with dual sink vanity and oversized shower with separate soaking tub. This home comes with full sod, full irrigation, and covered back patio!!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 ARTESIA VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artesia Village' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794257' WHERE `Matrix_Unique_ID` = '206646612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:57:08.393' ,`MLSNumber` = '33631402' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.920687' ,`Longitude` = '-95.733307' ,`PhotoCount` = '21' ,`PostalCode` = '77433' ,`RoomCount` = '5' ,`ListPrice` = '789990.00' ,`Status` = 'Active' ,`StreetName` = 'Big Spring Park' ,`StreetNumber` = '15010' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 33631402 - Built by Highland Homes - September completion! ~ ** WATER VIEW ** PARKLAND VILLAGE ** CY-FAIR ISD ** New & Fresh Design Plan 216 D by Highland Homes! Soaring Ceilings, Natural Light & Functional Design. 1 Story, 4 Bed, 4.5 Bath, 3 Car features On Suite Baths For Each Bedroom, Soaring 13ft Ceilings & 8ft Windows. Hardwoods throughout Main Living Area, Study & Primary Bedroom. Family Room 8ft Windows Overlook Water View. Sliding Doors Open to Patio for Water View. Media Room Pre-wired For Surround Sound! Expanded Primary Suite, Dual Vanities, Drop in Tub & Large Shower. HUGE Expanded Outdoor Living on Lot w Full Yard Sprinkler & No Rear Neighbors, Backs to Water, 4 Sides, Brick & More. HERS Energy Rated = LOW Electric Bills! Built with the Quality & Craftsmanship you expect only in a Highland Home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29, Block 1, Sec 47' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '9155' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.62' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794257' WHERE `Matrix_Unique_ID` = '206853734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:54:49.210' ,`MLSNumber` = '96289747' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.527232' ,`Longitude` = '-95.097771' ,`PhotoCount` = '49' ,`PostalCode` = '77598' ,`RoomCount` = '6' ,`ListPrice` = '599990.00' ,`Status` = 'Active' ,`StreetName` = 'Livermore' ,`StreetNumber` = '643' ,`StreetSuffix` = '' ,`City` = 'Webster' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 96289747 - Built by Highland Homes - Ready Now! ~ Lifestyle Room is ideal as Second TV Area or Study/Office Space. Primary Room tucked in the back, overlooking the backyard. Two Bedrooms Downstairs is ideal as an In-Law Suite or for guests. See Sales Counselor for Interior Selections.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'MCWHIRTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewater' ,`TaxAmount` = '' ,`TaxRate` = '3.24' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794257' WHERE `Matrix_Unique_ID` = '206923748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:57:35.350' ,`MLSNumber` = '88464862' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946828' ,`Longitude` = '-95.780320' ,`PhotoCount` = '21' ,`PostalCode` = '77433' ,`RoomCount` = '5' ,`ListPrice` = '939368.00' ,`Status` = 'Active' ,`StreetName` = 'Hindwing' ,`StreetNumber` = '11106' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3870' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 88464862 - Built by Highland Homes - December completion! ~ No Rear Neighbors!! Oversized Cul-de-sac Homesite!! New & Fresh Design Plan 221 D by Highland Homes! Soaring Ceilings, Natural Light & Functional Design. 2 Story, 5 Bed, 5.5 Bath, 3 Car features Baths For Each Bedroom. Luxury Wood Floor Staircase. Upgraded Wood Floors at Main Living Area & Study. Downstairs Media Room Pre-wired For Surround Sound. Study & Living Space features Large Windows. Kitchen Opens to Family Room w/ Uppers & Silestone Quartz Counters! Expanded Primary Suite, Dual Vanities, Drop in Tub & Large Shower. Expanded Bedrooms Upstairs w/ Gameroom, Expanded Outdoor Living on Lot w Full Yard Sprinkler & No Rear Neighbors, 4 Sides, Brick & More. 2022 HERS Energy Rated = LOW Electric Bills! Built with the Quality & Craftsmanship you expect only in a Highland Home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 1, Sec 6PRV' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11531' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.52' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794257' WHERE `Matrix_Unique_ID` = '207130459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:52:00.360' ,`MLSNumber` = '82574053' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979918' ,`Longitude` = '-95.746848' ,`PhotoCount` = '14' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '744263.00' ,`Status` = 'Active' ,`StreetName` = 'Via Santa Caterina' ,`StreetNumber` = '20735' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 82574053 - Built by Toll Brothers, Inc. - Ready Now! ~ NEW PLAN! The Fenton High Plains plan offers an abundance of space and function in a single-story home made for long term living. Situated on a 60-foot wide home site, this amazing home features a 12-foot ceiling in the office just off the foyer. A private secondary bedroom with full bath is perfect for overnight guests. The open concept kitchen comes complete with center island, stainless appliances and walk-in pantry. The great room boasts high ceilings and a 60 linear electric fireplace. 15-foot multi-slide glass doors open to the expanded covered patio allowing the outdoor\'s in and opening entertaining space. A relaxing primary bedroom includes a walk-in closet, oversized shower with drying area and separate vanities. Additional highlights include an additional multi-purpose flex room and spacious secondary bedrooms.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 34 Blk 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9264' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794257' WHERE `Matrix_Unique_ID` = '207316292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:48:20.683' ,`MLSNumber` = '15235168' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841495' ,`Longitude` = '-95.861174' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '319295.00' ,`Status` = 'Active' ,`StreetName` = 'Laguna Green' ,`StreetNumber` = '817' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1438' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 15235168 - Built by HistoryMaker Homes - Ready Now! ~ Spacious and light one-story home with large primary suite. Large open kitchen and dining area with window nook in breakfast area. Tray ceilings in family room and primary suite. Neutral color palette compliments this spacious and functional floor plan!!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S800008 SUNTERRA SECTION 8 BLK 1 LOT 105' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5664' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794258' WHERE `Matrix_Unique_ID` = '207435686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:49:52.580' ,`MLSNumber` = '34161678' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194748' ,`Longitude` = '-95.419044' ,`PhotoCount` = '48' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '404048.00' ,`Status` = 'Active' ,`StreetName` = 'Chinese Violet' ,`StreetNumber` = '10726' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 34161678 - Built by HistoryMaker Homes - Ready Now! ~ he exclusive, gated, Harper’s Preserve offers exemplary schools, resort-style amenities and is located just minutes away from The Woodlands world class dining, shopping, and entertainment. This charming Cypress 4 bedroom and 2 bath floor plan boasts exceptional curb appeal with its Brick accented covered entry, 10\' ceilings throughout, an extended covered patio (the perfect spot for outdoor dining and your grill), and a box out window in the dining area. The home-chef will love the stainless-steel appliances, quartz counter tops, large island, 42 inch white cabinetry w/crown molding, and walk-in pantry. The primary bedroom suite offers dual vanities, a garden tub, separate shower, and large walk-in closet.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794258' WHERE `Matrix_Unique_ID` = '207462024' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:50:21.970' ,`MLSNumber` = '81309648' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194862' ,`Longitude` = '-95.419662' ,`PhotoCount` = '41' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '449794.00' ,`Status` = 'Active' ,`StreetName` = 'Chinese Violet' ,`StreetNumber` = '10714' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 81309648 - Built by HistoryMaker Homes - Ready Now! ~ Welcome to HistoryMaker Homes in Harper’s Preserve. The exclusive, gated, Harper’s Preserve offers exemplary schools, resort-style amenities and is located just minutes away from world class dining, shopping, and entertainment. This home has 10 ft Ceilings with 8 ft doors on 1st Floor, an extended covered patio just waiting for your grill or smoker, three bedrooms on the 1st Floor with a bedroom and large game room upstairs. The primary bedroom suite boasts a garden tub, separate shower, dual sinks, and vanities, and not just one but TWO walk-in closets! The chef-inspired kitchen features quartz counter tops, 42 cabinetry w/crown molding, and stainless-steel Whirlpool appliances.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794258' WHERE `Matrix_Unique_ID` = '207611111' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:49:24.127' ,`MLSNumber` = '6176399' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841157' ,`Longitude` = '-95.861611' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '365250.00' ,`Status` = 'Active' ,`StreetName` = 'Laguna Green' ,`StreetNumber` = '812' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1917' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 6176399 - Built by HistoryMaker Homes - Ready Now! ~ COME BE A PART OF THE LAGOON LIFE @ STUNTERRA!! SOMERVILLE ­ U 1917 sq ft / 3 BEDS / 2 BATHS / 1 PWDR 2 GARAGE / 2­STORY 9\' Ceilings Throughout First Floor Luxury Vinyl Tile Flooring in Entry, Family Room, Kitchen, Nook & Utility 42 inch White Kitchen Cabinets with Crown Moulding and Kitchen Island Quartz Countertops with Ceramic Tile Backsplash Stainless Steel Whirlpool Kitchen Appliances including Microwave Box Window in Nook Master Suite with 60 inch Shower and Double Vanity with Second Sink Full Yard Sod with Irrigation Covered Patio UNDER CONSTRUCTION!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S800008 SUNTERRA SECTION 8 BLK 1 LOT 89' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5528' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794258' WHERE `Matrix_Unique_ID` = '207871150' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:50:48.443' ,`MLSNumber` = '64669583' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194725' ,`Longitude` = '-95.418953' ,`PhotoCount` = '28' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '464405.00' ,`Status` = 'Active' ,`StreetName` = 'Chinese Violet' ,`StreetNumber` = '10730' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 64669583 - Built by HistoryMaker Homes - Ready Now! ~ Welcome to HistoryMaker Homes in Harper’s Preserve. The exclusive, gated, Harper\'s Preserve offers exemplary schools, resort-style amenities and is located just minutes away from world class dining, shopping, and entertainment. This stunning Sequoia plan features10\' Ceilings Throughout First Floor, Luxury Vinyl Plank Flooring in Entry, Kitchen, Nook, Family Room & Utility Room, 42 White Kitchen Cabinets with Crown Molding and Kitchen Island, Granite Countertops with Ceramic Tile Backsplash, Stainless Steel Whirlpool Kitchen Appliances including Microwave, Box Window in Nook, Master Suite with Garden Tub & Separate Shower with Double Vanity & Second Sink, Full Yard Sod with Full Irrigation with Rotary Heads, Extended Covered Patio and more. Schedule your appointment today.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572731 - Harper\'s Preserve 31, BLOCK 1, Lot 23' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794258' WHERE `Matrix_Unique_ID` = '207897161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:59:04.487' ,`MLSNumber` = '5240736' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444179' ,`Longitude` = '-95.397190' ,`PhotoCount` = '24' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '534041.00' ,`Status` = 'Active' ,`StreetName` = 'Wright' ,`StreetNumber` = '9610' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 5240736 - Built by Highland Homes - October completion! ~ New Model Home Plan! Tall ceilings and natural light welcome you into this brand new home. Spacious entertainment room is the perfect place to host your own movie nights! Kitchen area overlooks the family room and dining area, so entertaining is easy. Kitchen features plenty of cabinet & countertop space so meal prepping is a breeze! Work from home comfortably in the study overlooking the backyard. Sliding glass doors lead you to the Texas-sized covered patio overlooking a yard big enough for a POOL and more!! Retreat to the owners suite with luxurious freestanding tub and large walk-in closet. Smart home features included. Located only 10 min from Pearland and easy access to Med Center! On-site schools in community. Meridiana offers a lifestyle like no other. Make an appointment today and come visit our model home to see this plan furnished!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = '15/1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '0' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794258' WHERE `Matrix_Unique_ID` = '207983030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:52:00.360' ,`MLSNumber` = '81415413' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979741' ,`Longitude` = '-95.747571' ,`PhotoCount` = '12' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '799885.00' ,`Status` = 'Active' ,`StreetName` = 'Garibaldi' ,`StreetNumber` = '14219' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 81415413 - Built by Toll Brothers, Inc. - September completion! ~ The Hardy Transitional has a sleek stucco exterior and filled with architectural details inside. The two-story foyer with curved staircase is flanked by a private office with double-door entry. A secluded bedroom with full bath and walk-in closet provides space for multigenerational living or overnight guests. The great room allows you to enjoy warm fires with the electric fireplace or open the multi-slide doors to the covered patio to expand entertaining space. The gourmet kitchen features an expansive island, walk-in pantry, stainless appliances and casual dining room. The upper level is host to two spacious bedrooms and two full baths, enormous loft and media room!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 17 blk 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8905' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794259' WHERE `Matrix_Unique_ID` = '208241881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:59:30.757' ,`MLSNumber` = '2458775' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563331' ,`Longitude` = '-95.746834' ,`PhotoCount` = '26' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '514990.00' ,`Status` = 'Active' ,`StreetName` = 'Travers Hill' ,`StreetNumber` = '23723' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 2458775 - Built by Highland Homes - Ready Now! ~ 23723 Travers Hill Road features our model floor plan, the 539, built on a home site with no near back neighbors! This plan includes a corner fireplace for cozy evenings, separate dining areas, a luxurious primary suite, and timeless architectural details such as eight-foot windows and soaring ceilings. Upscale options such as 8’ doors, built-in appliances, engineered hardwood floors in common areas and the primary bedroom, and more have been selected for the home. 23723 Travers Hill Road is being built in our final section of 55’ homes for Veranda that is walking distance to the upcoming elementary school! Visit our model (22914 Henderson Row Drive, Richmond, TX 77469) to learn more about what this home has to offer you and to take a tour today!!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7136' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1095' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda 55s' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794259' WHERE `Matrix_Unique_ID` = '208403772' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:59:57.527' ,`MLSNumber` = '64197036' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563360' ,`Longitude` = '-95.747739' ,`PhotoCount` = '43' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '499990.00' ,`Status` = 'Active' ,`StreetName` = 'Travers Hill' ,`StreetNumber` = '23743' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2519' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 64197036 - Built by Highland Homes - Ready Now! ~ 23743 Travers Hill Road features our model floor plan, the 539, built on an oversized, northeast-facing home site with no near back neighbors. This plan includes a corner fireplace for cozy evenings, separate dining areas, a luxurious primary suite, and timeless architectural details such as eight-foot windows and soaring ceilings. Upscale options such as 8’ doors, built-in appliances, engineered hardwood floors in common areas and the primary bedroom, and more have been selected for this home. 23743 Travers Hill Road is being built in our final section of 55’ homes for Veranda that is walking distance to the upcoming elementary school! Visit our model (22914 Henderson Row Drive, Richmond, TX 77469) to learn more about what this home has to offer you and to take a tour.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15, Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8692' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1095' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda 55s' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794259' WHERE `Matrix_Unique_ID` = '208414603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:43:12.753' ,`MLSNumber` = '10509484' ,`ListAgentFullName` = 'Charman Escobedo' ,`ListOfficeName` = 'Green And Associates, REALTORS' ,`SellingAgentFullName` = 'Joey Hulsey' ,`SellingOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`Latitude` = '29.175593' ,`Longitude` = '-95.424507' ,`PhotoCount` = '23' ,`PostalCode` = '77515' ,`RoomCount` = '8' ,`ListPrice` = '169900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Kyle' ,`StreetNumber` = '741' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently remodeled home, MOVE IN READY, in a quaint well established neighborhood. This lovely home features a living and dining area, and a massive family room. Both are located off the kitchen for easy entertaining. Kitchen features granite counter tops, bright white cabinets, and dramatic black appliances. Primary suite is large with good sized closet. En-suite has tub/shower combo and nice tile surround. Two additonal spacious bedrooms have lots of windows for natural light. Family room opens to covered back patio, great for BBQ\'s, entertaining, or just relaxing in the large backyard. Carport is large enough to easily fit two cars. Great location, close to downtown Angleton for shopping, dining, antiquing, and entertainment. Easily get to Houston, Lake Jackson, or Freeport for work. Get that great country living feel while being close enough to all amenities. Make an appointment to view this great home at a great price today. It absolutely will not las long!' ,`Acres` = '0.178' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'K & S PLAZA (ANGLETON), BLOCK 2, LOT 30' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7754' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'K & S Plaza Angleton' ,`TaxAmount` = '3198' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794259' WHERE `Matrix_Unique_ID` = '209144419' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:28:42.630' ,`MLSNumber` = '47913672' ,`ListAgentFullName` = 'Kristina Santana' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851971' ,`Longitude` = '-95.284784' ,`PhotoCount` = '18' ,`PostalCode` = '77078' ,`RoomCount` = '2' ,`ListPrice` = '124900.00' ,`Status` = 'Active' ,`StreetName` = 'Hamlet' ,`StreetNumber` = '7870' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0579' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 PARK NORTH SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2524' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HILLIARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Park North Sec 01' ,`TaxAmount` = '798' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794259' WHERE `Matrix_Unique_ID` = '209324114' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:28:38.023' ,`MLSNumber` = '39025813' ,`ListAgentFullName` = 'Veronica Mendoza' ,`ListOfficeName` = 'Veronica Mendoza Realty, LLC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973300' ,`Longitude` = '-95.409755' ,`PhotoCount` = '32' ,`PostalCode` = '77073' ,`RoomCount` = '7' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Kiley' ,`StreetNumber` = '631' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1941' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a Must-See Home! Spacious one-story home in Remington Ranch-3 bed/2 Full Bath with a study and a formal Dining Area. Enjoyable Nice sized backyard! Zoned to Spring ISD. Includes an area pool in the community, perfect for these hot summer days! It is Conveniently located with access to the I-45, Beltway, and Bush Intercontinental Airport.' ,`Acres` = '0.1416' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 REMINGTON RANCH SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6166' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILTON COOPER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Ranch Sec 4' ,`TaxAmount` = '5020' ,`TaxRate` = '2.8804' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794259' WHERE `Matrix_Unique_ID` = '209592368' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:10:10.187' ,`MLSNumber` = '94580781' ,`ListAgentFullName` = 'William Phillips' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = 'Michael Flores' ,`SellingOfficeName` = 'Keller Williams HoustonCentral' ,`Latitude` = '30.166280' ,`Longitude` = '-95.296019' ,`PhotoCount` = '29' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '289990.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Battle Branch' ,`StreetNumber` = '20102' ,`StreetSuffix` = 'Trail' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1855' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SELLERS ARE MOTIVATED! JUST REDUCED! Why wait on new construction delays & price increases. This stunning one-story four bedroom, two bath home is move in ready, has been meticulously maintained & sits on one of the largest lots in the highly sought after Porters Mill community. Open concept floor plan with private primary & en suite featuring soaking tub, separate shower, double vanities & spacious walk in closet. The large, functional kitchen boasts stainless steel appliances, over-sized island, granite counter tops & abundance of cabinetry & flows seamlessly into the large family room. The adjacent dining area makes a perfect area to entertain. Luxurious tile flooring add warmth & character to this beautiful home. On demand tankless water heater, custom solar screens on all windows, landscape package, full automatic sprinkler system & high efficiency HVAC round out the amenities. Conveniently located to shopping, dining & entertainment with easy access to 45, 69 & the Grand Parkway.' ,`Acres` = '0.2379' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S812702-PORTERS MILL 02, BLOCK 1, LOT 20' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '10363' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Porters Mill' ,`TaxAmount` = '7069' ,`TaxRate` = '3.0331' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794259' WHERE `Matrix_Unique_ID` = '209865489' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:45:22.637' ,`MLSNumber` = '3856726' ,`ListAgentFullName` = 'Krystle Rodriguez' ,`ListOfficeName` = 'Bayou Vista Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695533' ,`Longitude` = '-95.652110' ,`PhotoCount` = '16' ,`PostalCode` = '77083' ,`RoomCount` = '3' ,`ListPrice` = '277800.00' ,`Status` = 'Active' ,`StreetName` = 'Winkleman' ,`StreetNumber` = '7427' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1963' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1389' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 2 MISSION BEND SAN GABRIEL SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'PETROSKY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Bend San Gabriel 02' ,`TaxAmount` = '4572' ,`TaxRate` = '2.202' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794260' WHERE `Matrix_Unique_ID` = '209911257' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:32:12.943' ,`MLSNumber` = '12382133' ,`ListAgentFullName` = 'Marynes Cobo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.716944' ,`Longitude` = '-95.789075' ,`PhotoCount` = '48' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '1130000.00' ,`Status` = 'Active' ,`StreetName` = 'Starlight Beach' ,`StreetNumber` = '23110' ,`StreetSuffix` = 'Road' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4273' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with great curb appeal in desired gate community at Avalon. Backing to lake will provide hours of enjoyment, high ceilings, granite countertops. Gorgeous infinity pool/spa. Sunroom off kitchen, and kitchen with lake view. Mediaroom upstairs wired with surround sound. Roof replaced 2019. A/C units new, one from 2019 and another 2020. Totally remodeling bathrooms, kitchen, pool area. New custom shutters. Walk to elementary and Jr. high school.' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Avalon at Seven Meadows Sec 5,Block 4,Lot 13' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Waterfront' ,`LotSize` = '12792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GRIFFIN ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Avalon at Seven Meadows' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794260' WHERE `Matrix_Unique_ID` = '209950289' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:52:53.737' ,`MLSNumber` = '9244444' ,`ListAgentFullName` = 'Sean Namli' ,`ListOfficeName` = 'Dr. Sean Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.758163' ,`Longitude` = '-95.549681' ,`PhotoCount` = '40' ,`PostalCode` = '77042' ,`RoomCount` = '5' ,`ListPrice` = '834000.00' ,`Status` = 'Active' ,`StreetName` = 'Briar' ,`StreetNumber` = '10007' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 5 bedroom, 5 bathroom house tucked away in Eastern most part of the neighborhood, away from the Beltway. House is full of fantastic updates including new electric, PEX & PVC plumbing, double pained windows, engineered hardwood floors, high end appliances. No expense was spared during upgrades. Huge lot with inground pool and outdoor kitchen area. Outdoor jacuzzi. A must see. Also available for lease at MLS #94389687' ,`Acres` = '0.2331' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 824 BLK 30 BRIARGROVE PARK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10154' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove Park Sec 01' ,`TaxAmount` = '12722' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794260' WHERE `Matrix_Unique_ID` = '209985168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:48:37.387' ,`MLSNumber` = '19108015' ,`ListAgentFullName` = 'Raquel Johnson' ,`ListOfficeName` = 'Sapphire Homes Realty LLC' ,`SellingAgentFullName` = 'Raquel Johnson' ,`SellingOfficeName` = 'Sapphire Homes Realty LLC' ,`Latitude` = '29.770804' ,`Longitude` = '-95.037872' ,`PhotoCount` = '48' ,`PostalCode` = '77520' ,`RoomCount` = '6' ,`ListPrice` = '324900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Burnett' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just remodeled -1 Story - 4 Bedroom 3 1/2 Bathroom in 1 acre land.\r\nNo HOA. Home has been updated, some of the new features include inside paint, recent laminated flooring installed throughout the home, remodeled kitchen with new granite countertops and new faucet. the bathrooms also were refreshed with new toilets, updated showers, new restroom vanities & faucets. Some other updates are new fans and light fixtures throughout the home, new PEX water lines, freshly painted deck and the roof has new 30yr shingles.\r\nSchedule your private viewing today!' ,`Acres` = '1.0073' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 2 & 3 BLK 9 LAKEWOOD SEC B' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '43876' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Sec B' ,`TaxAmount` = '9418' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794260' WHERE `Matrix_Unique_ID` = '210344544' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:47:00.967' ,`MLSNumber` = '18094755' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.644806' ,`Longitude` = '-95.027348' ,`PhotoCount` = '28' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '342376.00' ,`Status` = 'Active' ,`StreetName` = 'Lucky Manor' ,`StreetNumber` = '172' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 18094755 - Built by HistoryMaker Homes - Ready Now! ~ This 3 bedroom, 2.5 bathroom, two-story home boasts a soaring two-story entry and 9\' ceilings throughout the remainder of the 1st floor. Luxury vinyl plank can be found in the common areas and all baths. The chef-inspired kitchen offers 42 inch gray cabinetry with crown molding, ceramic tile backsplash, quartz countertops, a corner walk-in pantry, and stainless-steel appliances that make entertaining easy. Settle into the spacious primary bedroom with on suite bathroom featuring dual sink vanity and oversized shower and soaking tub. This home comes with full sod, full irrigation, and covered back patio!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 ARTESIA VILLAGE' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artesia Village' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794260' WHERE `Matrix_Unique_ID` = '210550099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:40:52.090' ,`MLSNumber` = '8742351' ,`ListAgentFullName` = 'Knakita Jones' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Yesica Saldana' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '30.023920' ,`Longitude` = '-95.573392' ,`PhotoCount` = '32' ,`PostalCode` = '77375' ,`RoomCount` = '11' ,`ListPrice` = '289900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Forest Haven' ,`StreetNumber` = '17718' ,`StreetSuffix` = 'Trail' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2277' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home, 4 sides brick, 4 bedrooms, 2 bathrooms, located in the established community of Memorial Springs, in the exclaimed Klein School district. The home has an extended foyer, as well as both formals with double crown molding and an island kitchen that opens to the family room with a cozy fireplace. This home is ready for new owners to come in and make it their own.' ,`Acres` = '0.1653' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 MEMORIAL SPRINGS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Spgs Sec 01' ,`TaxAmount` = '5629' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794260' WHERE `Matrix_Unique_ID` = '210655249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:53:54.113' ,`MLSNumber` = '97610532' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471793' ,`Longitude` = '-95.509249' ,`PhotoCount` = '19' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '749712.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Oak' ,`StreetNumber` = '10618' ,`StreetSuffix` = '' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3769' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 97610532 - Built by Toll Brothers, Inc. - September completion! ~ Located in The Sienna Community of Fort Bend County, the popular 1.5 story Turner Transitional, which sits on a 9,700 sf home site nestled in the base of a cul-de-sac. As you enter through the double front doors, you walk into a spacious tiled entry featuring 11\' tray ceilings. The study hosts 2 elegant glass doors and is large enough to occupy 2 work spaces. When relaxing in your family room, you can enjoy the view of your fireplace or look into the backyard through the 12\' sliding glass doors. The kitchen has a large island and plenty of cabinet space, a walk in pantry as well as a butler\'s pantry. The primary bedroom includes a tray ceiling and en-suite with a large tub perfect for soaking your troubles away. Your guests will appreciate their own bedroom suite with full bath and walk in closet. Enjoy entertaining on movie night either in the media room or upstairs flex/gameroom!!' ,`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 Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 22 blk 1' ,`LotDesciption` = 'Corner,Cul-De-Sac,Other' ,`LotSize` = '3769' ,`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 - Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794261' WHERE `Matrix_Unique_ID` = '211014644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:53:43.220' ,`MLSNumber` = '27945280' ,`ListAgentFullName` = 'Agnes Casimiro' ,`ListOfficeName` = 'Texas Homestead, Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602367' ,`Longitude` = '-95.262197' ,`PhotoCount` = '8' ,`PostalCode` = '77075' ,`RoomCount` = '5' ,`ListPrice` = '249500.00' ,`Status` = 'Active' ,`StreetName` = 'Opal Glen' ,`StreetNumber` = '11126' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Corner Lot, Easy Access to Beltway 8, Hwy 288 and Hwy 45.' ,`Acres` = '0.1484' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 DURHAM PARK SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Durham Park Sec 1' ,`TaxAmount` = '5583' ,`TaxRate` = '3.2063' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794261' WHERE `Matrix_Unique_ID` = '211022295' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:58:05.787' ,`MLSNumber` = '61655253' ,`ListAgentFullName` = 'Tifany Teague' ,`ListOfficeName` = 'Icon Realty Group, L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047435' ,`Longitude` = '-95.602813' ,`PhotoCount` = '23' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Havenmist' ,`StreetNumber` = '12130' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in ready 1-story, zoned to the coveted Klein Cain, and just seconds from 99 and 249! Wide-open 4-bedroom plan - huge family room with gorgeous wood laminate flooring, endless countertop space and a wrap-around breakfast bar, formal dining, and a huge master suite w/ soaking tub and vanity seat! Spacious back yard, and a prime lot location near the front of the family-centric Pinecrest Forest! Don’t miss it! House is back on the market..bring your Buyers today!\n\n\n' ,`Acres` = '0.1562' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 3 PINECREST FOREST SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6806' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KOHRVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Pinecrest Forest' ,`TaxAmount` = '5550' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794261' WHERE `Matrix_Unique_ID` = '211332525' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:20:56.470' ,`MLSNumber` = '6601049' ,`ListAgentFullName` = 'Glenda Jackson' ,`ListOfficeName` = 'Jackson Enterprises' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.674763' ,`Longitude` = '-95.306954' ,`PhotoCount` = '14' ,`PostalCode` = '77087' ,`RoomCount` = '7' ,`ListPrice` = '183500.00' ,`Status` = 'Active' ,`StreetName` = 'Cherrydale' ,`StreetNumber` = '6823' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Andover Place' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7552' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GREGG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Andover Place' ,`TaxAmount` = '2617' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794261' WHERE `Matrix_Unique_ID` = '211395491' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:47:03.320' ,`MLSNumber` = '17309717' ,`ListAgentFullName` = 'Susan Mellen' ,`ListOfficeName` = 'Cy-Fair Properties, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531395' ,`Longitude` = '-95.026035' ,`PhotoCount` = '30' ,`PostalCode` = '77565' ,`RoomCount` = '4' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Meadow' ,`StreetNumber` = '1711' ,`StreetSuffix` = 'Drive' ,`City` = 'Kemah' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful, recently renovated home. The home boasts two primary bedrooms. The first primary includes an on-suite bath with separate tub/shower, double sinks, and a large walk-in closet. The second primary includes a large bedroom with spacious sitting/office area and walk-though closet. Air Conditioner/Heater and dishwasher were recently replaced in June 2022. *Water heater, hosing, and stand replaced September 12, 2022.* The home is nestled on a cul-de-sac street just feet away from a serene pond and just minutes away from Galveston Bay, the Kemah Boardwalk, shopping, and the Houston/Metro area.' ,`Acres` = '0.1345' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 PAGE 16 LOT 8 BLK 2 KEMAH OAKS SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '484' ,`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` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kemah Oaks Sub 92' ,`TaxAmount` = '3678' ,`TaxRate` = '1.7835' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794261' WHERE `Matrix_Unique_ID` = '211401911' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:49:42.937' ,`MLSNumber` = '54336506' ,`ListAgentFullName` = 'Mark Sonnier' ,`ListOfficeName` = 'George E. Johnson Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671437' ,`Longitude` = '-95.346309' ,`PhotoCount` = '21' ,`PostalCode` = '77033' ,`RoomCount` = '7' ,`ListPrice` = '190000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgeway' ,`StreetNumber` = '5110' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you\'re a potential homeowner or investor looking for rental property, this home is for you! Home includes granite countertops, luxury vinyl flooring, mosaic backsplash, ceramic tiled tub surround, granite vanities and carport. Location is convenient to Medical Center, Pearland, The Galleria, Downtown and Hobby Airport. MEASUREMENTS ARE ESTIMATES - RE-MEASURE IF IMPORTANT.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 9 INWOOD TERRACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Courts' ,`TaxAmount` = '3905' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794261' WHERE `Matrix_Unique_ID` = '211404971' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:02:18.920' ,`MLSNumber` = '67555733' ,`ListAgentFullName` = 'Hayward Huntsberry' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = 'Melchor Garcia' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '30.023124' ,`Longitude` = '-95.101214' ,`PhotoCount` = '32' ,`PostalCode` = '77336' ,`RoomCount` = '6' ,`ListPrice` = '205000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fall Creek Dr' ,`StreetNumber` = '923' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare Find!!! Great Starter and Move In Ready Home in an established neighborhood!!! This gorgeous 2/3 bedroom home sits on a huge corner lot. The 2 bedroom can easily be converted to a 3 bedroom at anytime. This beautiful home features a huge Living/Dining area to accommodate your family and guests just in time for the holidays. Galley Kitchen with plenty of counter space and cabinets. Kitchen has upgraded stainless steel appliances! All bedrooms feature built in dressers and a lift up storage under window seat. Master bath has a walk in shower and seat. This huge backyard has endless possibilities for family gatherings, there\'s even a drive through gate with an 8ft privacy fence. Also included is a whole home standby generator in the event of a power outage. A/C is only 2 years old. This home is incredible and won\'t last long! Schedule your showing today!' ,`Acres` = '0.2686' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 636 BLK 29 LAKEWOOD HEIGHTS SEC 3 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '267' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Heights Sec 03 R/P' ,`TaxAmount` = '3376' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794262' WHERE `Matrix_Unique_ID` = '211432121' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:00:33.527' ,`MLSNumber` = '45569557' ,`ListAgentFullName` = 'Whitnee Mahon' ,`ListOfficeName` = 'The McKellar Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.728586' ,`Longitude` = '-95.931684' ,`PhotoCount` = '36' ,`PostalCode` = '77423' ,`RoomCount` = '6' ,`ListPrice` = '294000.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Point' ,`StreetNumber` = '32510' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookshire' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1660' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautifully updated and well maintained 3 bedroom 2 full bath Anglia build! This charming one story is perfectly situated on a cul-de-sac with no back neighbors and neighbors on one side only. Upon entering this home you will be greeted with bright freshly painted walls and an open floor concept with high ceilings. The kitchen has beautiful granite countertops and under cabinet lighting. The primary suite is situated away from secondary bedrooms and the home study could even serve as a fourth bedroom! Located in the Vanbrooke comm. offers amenities such as a resort style pool, splashpad, park, walking path and soccer field. This home is zoned to highly desired Fulshear area schools. Updates include: New HVAC, new paint, primary bathroom remodel, new tile, ceiling fans and light fixtures, decorative feature walls in the living room and primary bedroom, whole home gutters, and thermoplastic high temp loom in attic. Whole home monitoring and security system included!' ,`Acres` = '0.1118' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VANBROOKE SEC 1, BLOCK 1, LOT 47' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4871' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vanbrooke Sec 1' ,`TaxAmount` = '7005' ,`TaxRate` = '3.2948' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794262' WHERE `Matrix_Unique_ID` = '211498350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:38:19.587' ,`MLSNumber` = '47765159' ,`ListAgentFullName` = 'Nicholas Naik' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.879471' ,`Longitude` = '-95.786403' ,`PhotoCount` = '49' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '679900.00' ,`Status` = 'Active' ,`StreetName` = 'Crossvine Manor' ,`StreetNumber` = '7307' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'READY TO MOVE IN, EAST FACING LAKE VIEW WESTIN HOME with the most popular plan PRESTON III - Elevation B with Master design and modern luxury uniquely embodied in this two story home featuring 4 bedrooms, 3.5 baths, huge family room, spacious open concept kitchen with upgraded cabinets, huge game room and media room upstairs. The Primary suite has a breathtaking view of the lake, bath with two sinks, garden tub and standing shower with access to utility room. ELYSON is in the heart of KATY! with amenities such as pool, fitness center, game room, event lawn, tennis courts, parks, trails and so much more! A must-see home!!' ,`Acres` = '0.1845' ,`Area` = '25' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 3 (PURE ACCT*1418790030034) ELYSON SEC 26' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '8038' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1242' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '1464' ,`TaxRate` = '3.4957' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794262' WHERE `Matrix_Unique_ID` = '211580684' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:29:17.043' ,`MLSNumber` = '46828193' ,`ListAgentFullName` = 'Phuc Nguyen' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700265' ,`Longitude` = '-95.587986' ,`PhotoCount` = '35' ,`PostalCode` = '77072' ,`RoomCount` = '12' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Morrilton' ,`StreetNumber` = '12708' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1909' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never lived in! Beautiful 2-stories property in a quiet neighborhood, with 4 bedrooms and 3 full baths! Home is located near major shopping centers, dining areas, and park. New carpet and tile flooring layered throughout. Open floor plan, with granite kitchen countertop, and dual pantries! Brand new refrigerator is included.' ,`Acres` = '0.0891' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 MEDITERRANEAN FOREST' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3880' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'YOUENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'KILLOUGH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mediterranean Forest Sub' ,`TaxAmount` = '5466' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794262' WHERE `Matrix_Unique_ID` = '211595301' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:15:23.837' ,`MLSNumber` = '28940974' ,`ListAgentFullName` = 'Theresa Scheib' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = 'Mina Hemani' ,`SellingOfficeName` = 'Alna Realty, Inc' ,`Latitude` = '30.382918' ,`Longitude` = '-95.493223' ,`PhotoCount` = '48' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '280000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Cherry Hill' ,`StreetNumber` = '29' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3026' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home on 1-1/2 lots on the #1 fairway of Panorama\'s golf course. No maintenance fees in this lovely golf course community and no mud tax. Tile downstairs with laminate in study & primary bedroom. This home has great storage everywhere- 3 pantry areas - 1 in formal dining room with drawers & shelves for large items. Spacious primary bedroom has built in drawers & cabinets & 2 window seats with storage. The bath has dual sinks, vanity area, walk in closet w/pocket door, oversized jacuzzi tub, separate shower, walk-in closet & 2 separate toilets. Laundry room has space for additional refrigerator & an abundance of cabinets & hang up space. Built in desk area/butler\'s pantry in living room. 2 bedrooms up w/full bath. See room above garage. Extended concrete patio in back w/fireplace & fire pit. New main house A/C condenser 7-22. Enjoy the beauty & peaceful views all year long!' ,`Acres` = '0.3439' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S771500 - PANORAMA-CHERRY HILLS, LOT 29, 30-A, ACRES 0.3439' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '14980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Panorama-Cherry Hills' ,`TaxAmount` = '5496' ,`TaxRate` = '2.4982' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794262' WHERE `Matrix_Unique_ID` = '211687293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:18:46.633' ,`MLSNumber` = '85864984' ,`ListAgentFullName` = 'Alexandra McCauley' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675027' ,`Longitude` = '-95.471867' ,`PhotoCount` = '20' ,`PostalCode` = '77096' ,`RoomCount` = '3' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Braesheather' ,`StreetNumber` = '5207' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors, builders or those looking for a passion project, 5207 Braesheather is the property for you! This stunning home sits on an oversized corner lot just shy of 13,000 sq ft. Tucked away in the highly desired community of Meyerland, this 3 bedroom/4.5 bath has endless potential for someone looking to take on their next project. Brick exterior makes the home easy to power wash & paint. The layout is a dream w/a stunning curved staircase as your focal point as you enter & a grand foyer that will impress. The architecture is stunning w/grand arched doorways giving this home a classic yet inviting feel. The chefs kitchen has endless potential w/ample room to design a waterfall island, upgraded countertops, sleek cabinetry, chefs appliances & elegant under cabinet lighting. The living room is made for entertaining w/the focal point being the brick fireplace & floor to ceiling windows. Zoned to Kolter Elem & Bellaire HS, this is not an opportunity you want to miss!' ,`Acres` = '0.29614325' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 26 MEYERLAND SEC 8 R/P I' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '12900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Meyerland' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794262' WHERE `Matrix_Unique_ID` = '211710271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:57:34.757' ,`MLSNumber` = '28365095' ,`ListAgentFullName` = 'Cathy Harper' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Nora Jackson' ,`SellingOfficeName` = 'Texas Realty Associates' ,`Latitude` = '29.686318' ,`Longitude` = '-95.823071' ,`PhotoCount` = '32' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '380000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brighton Gardens' ,`StreetNumber` = '10906' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful Perry Homes property in coveted Westheimer Lakes! A soaring entryway opens to a formal dining room, followed by the open concept kitchen & living room. The kitchen offers a gas range, walk-in pantry, plenty of storage & counter space & a spacious breakfast room. The living room is inviting & bright & provides the perfect backdrop for relaxing & entertaining. The first floor primary bedroom is large & filled with natural light from tall windows overlooking the backyard. The primary bathroom is the perfect retreat featuring double vanities, a separate shower & wide soaking tub. Upstairs, three generous bedrooms & a full bathroom surround a fantastic game room! The home\'s floorplan offers a beautiful flow, plenty of storage & fantastic functionality. The backyard is quiet & spacious. A two car attached garage & double-wide driveway provide additional convenience. Fantastic community amenities include a pool, splash pad, gym, tennis, basketball & so much more!' ,`Acres` = '0.1331' ,`Area` = '37' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON LAKES AT WESTHEIMER LAKES SEC 2, BLOCK 3, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5796' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '855' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas 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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lakes At Westheimer Lakes Sec 2' ,`TaxAmount` = '6134' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794263' WHERE `Matrix_Unique_ID` = '211736938' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:37:01.210' ,`MLSNumber` = '45526148' ,`ListAgentFullName` = 'David Hageman' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.131822' ,`Longitude` = '-95.746907' ,`PhotoCount` = '47' ,`PostalCode` = '77355' ,`RoomCount` = '10' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Meadow' ,`StreetNumber` = '17718' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A one-story, 4 Bedroom - 3 Full bath masterpiece with property well beyond the backyard privacy fence and sitting on a beautiful 1.115-acre lot. The open concept floorplan is a dream for entertaining with a large family room that is open to the kitchen and offers breathtaking views of your oversized backyard. With a huge island, stainless steel appliances, and plenty of counter and storage space, the kitchen is sure to please your family chef. You\'ll love the walk-in pantry and spacious casual dining area. Overlooking your private backyard is the spacious owner\'s retreat complete with a spa-like bath boasting dual sinks, a glass shower, and a soaking tub. A fantastic walk-in closet completes the suite. The secondary bedrooms are large with generous closet space and the home still has space to offer a big home office and formal dining room! Check out the fantastic backyard with a great covered patio overlooking it all. THE BACKYARD GOES WAY BEYOND THE PRIVACY FENCE. Greenhouse included' ,`Acres` = '1.115' ,`Area` = '15' ,`BuilderName` = 'Infinity Classic Hms' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRY WOODS ESTATES 02, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '48569' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Magnolia Ranch Estates' ,`TaxAmount` = '8402' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794263' WHERE `Matrix_Unique_ID` = '211777802' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:05:57.610' ,`MLSNumber` = '25919595' ,`ListAgentFullName` = 'David Flory' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.857626' ,`Longitude` = '-95.430173' ,`PhotoCount` = '32' ,`PostalCode` = '77091' ,`RoomCount` = '6' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Pine' ,`StreetNumber` = '6427' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MODEL HOME. Welcome to The Park at Highland Pines, a Gated Community by Calidad Builders. Single Family two-story townhome with a private oasis situated among manicured grounds, mature trees, and a large dog park, one of Houston’s fastest-growing neighborhoods. This open floor plan combines kitchen, dining, and living areas. Custom kitchen with induction cooktop, oversized Quartz island/countertops, and an oversized walk-in pantry. Large windows with natural balanced light. Luxury vinyl flooring throughout and Porcelain tile. A lovely private patio just off the living area. The primary suite with an en-suite bath has a soaking tub, floor-to-ceiling tile walk-in shower with a bench, and an extensive walk-in closet. The utility room is upstairs with cabinets/built-ins. Convenient location with easy access to 610, Downtown, The Galleria, eateries, Whole Foods, and shopping abound. Green and pet-friendly community.' ,`Acres` = '0.0548' ,`Area` = '9' ,`BuilderName` = 'Calidad' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 HIGHLAND HEIGHTS LANDING' ,`LotDesciption` = 'Corner,Patio Lot,Subdivision Lot' ,`LotSize` = '2387' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Highland Heights Lndg' ,`TaxAmount` = '5916' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794263' WHERE `Matrix_Unique_ID` = '211974423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:56:49.420' ,`MLSNumber` = '4418988' ,`ListAgentFullName` = 'Rayshelle Bryant' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.601549' ,`Longitude` = '-95.376342' ,`PhotoCount` = '23' ,`PostalCode` = '77047' ,`RoomCount` = '5' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Maybrook Hollow' ,`StreetNumber` = '2823' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1683' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This 3 bed, 2 bath home has been well-maintained! Walls have been freshly painted and new carpet has been installed. There is a nice sized, tile kitchen with granite countertops and there are wood floors throughout. The back yard is great for entertaining! This home is ready for its new owner and won\'t last long at this price point. Schedule your showing today!' ,`Acres` = '0.101' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 2 BRUNSWICK MEADOWS SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '428' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brunswick Meadows' ,`TaxAmount` = '4797' ,`TaxRate` = '2.6498' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794263' WHERE `Matrix_Unique_ID` = '211997654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:10:28.250' ,`MLSNumber` = '13000662' ,`ListAgentFullName` = 'Jin Jin' ,`ListOfficeName` = 'Daytown International LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949289' ,`Longitude` = '-95.740573' ,`PhotoCount` = '45' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Alora Springs' ,`StreetNumber` = '17934' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must SEE! The beautiful single-story house with 3 bedrooms and 2 full baths; open kitchen and breakfast area, large master walk-in closet. Call for today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 ALDER TRAILS SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WELLS ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'ALDER TRAILS' ,`TaxAmount` = '6734' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794263' WHERE `Matrix_Unique_ID` = '212123919' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:02:50.443' ,`MLSNumber` = '58871856' ,`ListAgentFullName` = 'Gift Duffield' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.537848' ,`Longitude` = '-95.042239' ,`PhotoCount` = '50' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Hollow Reef' ,`StreetNumber` = '2117' ,`StreetSuffix` = 'Circle' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dream home alert! Tastefully updated two stories home with attached two cars garage on a cul-de-sac. Welcome your friends and family to your HGTV worthy home with dining room that opens to flex space so you can host any party size. Enjoy cooking in your spacious kitchen with walk-in pantry, lots of cabinet storage, \'22 Stainless Steel Sink and faucet upgrades, and durable and easy to clean seamless countertop-backsplash combo. All bedrooms are upstairs with great closets. Primary bedroom is huge with relaxing spa-like primary bathroom (Over $30K update in \'21.) 2018 & 2019 HVAC, \'20 Flooring upgrades in most rooms, \'22 Paint. Storm doors, Double panes windows, Hardi Planks siding. Lights fixtures and doorknobs are recently updated. Great size fenced in yard and patio. Well-established mature trees neighborhood with great amenities (Pools, parks, playground, jogging trails) & LOW TAXES (No MUD) CCISD schools. Per sellers, home never flooded, didn’t lose power during ’21 winter storm.' ,`Acres` = '0.1649' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 50 BLK 1 HARBOUR PARK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7182' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '605' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Harbour Park Sec 4 91' ,`TaxAmount` = '5251' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794263' WHERE `Matrix_Unique_ID` = '212133716' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:17:40.007' ,`MLSNumber` = '42267679' ,`ListAgentFullName` = 'Sonia Corbin-Davis' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.508795' ,`Longitude` = '-95.413444' ,`PhotoCount` = '10' ,`PostalCode` = '77578' ,`RoomCount` = '3' ,`ListPrice` = '464000.00' ,`Status` = 'Active' ,`StreetName` = 'Broad Reach' ,`StreetNumber` = '2643' ,`StreetSuffix` = 'Road' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home located in a beautiful vibrant community. Beautiful floral beds adorn this home upon entrance. The huge front porch is a decorator\'s paradise. This home boasts high ceilings and encompasses 3 bedrooms and a study, that can possibly be a 4th bedroom. There is a Jack and Jill bath that serves as a guest bath, and still leaves privacy for the 2nd bedroom. The home has an open living concept with beautiful picture Roller blinds with remote access has been added to all of the windows in the home, which is not only the perfect touch for a view to the lake that the home overlooks but these blinds give the entire home amazing appeal. The lake view scenes are accessible from the family room, as well as the Master suite! You must see to take it all in.' ,`Acres` = '0.2066' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NEWPORT LAKE ESTATES SEC 2 (A0299 HT&BRR) (MANVEL) BLK 4 LOT' ,`LotDesciption` = 'Water View' ,`LotSize` = '8999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Temporarily No Showings' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Newport Lake Estates' ,`TaxAmount` = '3633' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794264' WHERE `Matrix_Unique_ID` = '212197692' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:20:43.010' ,`MLSNumber` = '28206627' ,`ListAgentFullName` = 'Shadie-Lee Ragas' ,`ListOfficeName` = 'Shug Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.307947' ,`Longitude` = '-95.502217' ,`PhotoCount` = '29' ,`PostalCode` = '77304' ,`RoomCount` = '11' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Pine' ,`StreetNumber` = '2034' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2192' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A MUST SEE! Beautiful 2-Story 4/2.5/2 Craftsman Style Home w/ Stone Wainscoting Front Elevation in the Pinewood Forest community. Inviting cvr’d entry w/ sidelights & transom windows surrounding the front door that opens to the spacious family room w/ soaring vaulted ceiling, plenty of windows, rustic wood-look vinyl plank flooring & fan. Kitchen boasts mocha oak cabinets w/ 42” uppers; tile backsplash; window over sink; black appliances incl gas range, dishwasher, microwave & fridge; brkfst bar; plenty of counter space; pantry; & bright breakfast area. Lrg 1st floor primary en-suite w/ mocha oak vanity, shower/tub combo, custom shelving & walk-in closet. Expansive Gameroom upstairs! 9/2022 Carpet. 2” Blinds. Incl: Washer & Dryer. Spacious back yard…perfect for BBQs (room for a pool). No back neighbors. Long Driveway w/ample parking. Cement-Board Siding. Double pane windows. Minutes to I45, Lake Conroe, Dining, The Woodlands Mall, Cynthia Woods Pav, Exxon Campus & more. Did NOT Flood.' ,`Acres` = '0.1263' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S799100 - PINEWOOD FOREST, BLOCK 1, LOT 28, ACRES 0.126' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '352' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinewood Forest' ,`TaxAmount` = '4505' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794264' WHERE `Matrix_Unique_ID` = '212199253' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:20:31.310' ,`MLSNumber` = '65013351' ,`ListAgentFullName` = 'Katie Long' ,`ListOfficeName` = 'Alpha Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542635' ,`Longitude` = '-95.399686' ,`PhotoCount` = '33' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Rashell' ,`StreetNumber` = '11515' ,`StreetSuffix` = 'Way' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2552' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OWNER IS A LICENSED REAL ESTATE AGENT IN THE STATE OF TEXAS. \r\nBeautiful one-story home on a cul-de-sac. The home offers 3-4 bedrooms &/or an office. Large kitchen that opens to family room. Kitchen has an updated walk-in pantry and an abundance of natural light. Spacious master bedroom & bathroom features updated shower & cabinets, large mirrors, his & her closets, & high ceilings. Large backyard includes fenced pool, retractable awning, custom-built playset, & gazebo with string lights & misters. Home also features a 4-car garage with an upstairs garage apt. Apt has a full bathroom & its own AC unit. The upstairs also has a large storage room beyond the apartment. Lots of possibilities with this space! The main AC unit was replaced in August 2022 & master bathroom was updated in January 2022. The home is zoned to Alvin ISD & is close to Pearland Town Center & a quick drive to the Med Center. Seller is offering $2,000 at closing to repair the damaged carpet in the master bedroom.' ,`Acres` = '0.3039' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHGATE SEC 4 (A0300 HT&B) (PEARLAND) BLK 1 LOT 19' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13238' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'RED DUKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'NOLAN RYAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southgate Sec 4' ,`TaxAmount` = '8397' ,`TaxRate` = '2.8209' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794264' WHERE `Matrix_Unique_ID` = '212266830' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:20:40.823' ,`MLSNumber` = '10714579' ,`ListAgentFullName` = 'Luz Elena Jaramillo' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848311' ,`Longitude` = '-95.814370' ,`PhotoCount` = '46' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Tall Pine Grove' ,`StreetNumber` = '25403' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story home in a Cul-de-sac in Katy ISD. You have a large covered front porch with the front door opening to the stairs going up and a large kitchen open to family room and dining, or even a sunroom! Up the stairs there is a large gameroom, a large primary bedroom and bathroom. The laundry room is also upstairs for easy access from the bedrooms! As you go into the backyard, you have a covered patio and a huge backyard perfect for entertaining!' ,`Acres` = '0.2687' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 4 KATY MANOR SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11703' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '466' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Manor Sec 7' ,`TaxAmount` = '10293' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794264' WHERE `Matrix_Unique_ID` = '212295245' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:28:31.660' ,`MLSNumber` = '78744967' ,`ListAgentFullName` = 'Angela Wells' ,`ListOfficeName` = 'Stanfield Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.539811' ,`Longitude` = '-95.042354' ,`PhotoCount` = '23' ,`PostalCode` = '77573' ,`RoomCount` = '12' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunset Ridge' ,`StreetNumber` = '213' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2531' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedroom, 2.5 bath brick home in League City\'s desirable Harbour Park neighborhood! A two-story foyer makes way to a lovely living & dining room with custom paint trimmed with picture frame and crown molding, & direct access to the recently updated kitchen that boasts high-end quartz countertops with a beautiful decorative backsplash, stainless appliances, modern pendant lights, and a sunlit breakfast room. The family room with custom paint, gaslog fireplace, & built-in shelves opens to the kitchen for easy entertaining. Upstairs, find all bedrooms, including the master suite with gambrel ceiling, wood laminate floors, & en-suite bath with dual granite top vanities, a soaking tub, separate shower, & large walk-in closet, plus a bonus room with French doors, dual walk-in closets, & added living space or possibly a 4th bedroom. In addition, a shaded backyard with covered patio, 16kw Generac whole home generator and updated energy-efficient storm windows w/ noise reduction.' ,`Acres` = '0.1846' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 27 BLK 3 HARBOUR PARK SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harbour Park Sec 4 91' ,`TaxAmount` = '5496' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794264' WHERE `Matrix_Unique_ID` = '212297502' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:47:52.977' ,`MLSNumber` = '49098050' ,`ListAgentFullName` = 'Tosha Hypolite' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = 'Quynh Nguyen' ,`SellingOfficeName` = 'Prime Realty Group' ,`Latitude` = '29.503450' ,`Longitude` = '-95.392658' ,`PhotoCount` = '29' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Old Presidio Way' ,`StreetNumber` = '16' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This ONE STORY home located in Rodeo Palms Master Planned community is THE ONE! This charming home includes a large kitchen with lots of cabinet space, new stainless steel appliances and an adorable breakfast area with window seating. This beautiful home has a lovely formal dining room and family room that\'s perfect for entertaining. The large Office/Study has two entrances. The beautiful ensuite is spacious and large enough to accommodate over sized furniture. It is also equipped with double sinks, and a large soaking tub with a separate shower. The large backyard that\'s newly fenced, has a garden box with solar lighting and is the perfect backdrop for your backyard oasis. This home has a new hot water heater and AC unit. Rodeo Palms is a lovely community that has several sparkling lakes, pocket parks, and a pool area. Located not far from Pearland Town Center and Downtown Houston, this beautiful home is perfect. Schedule your showing today!' ,`Acres` = '0.1326' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS PALM VILLAS SEC 1 (A0459 ACH&B)(MANVEL) BLK 3 LO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5776' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms, Palm Villas Sec 1' ,`TaxAmount` = '7721' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794264' WHERE `Matrix_Unique_ID` = '212432209' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:22:28.917' ,`MLSNumber` = '59009337' ,`ListAgentFullName` = 'Ana Gonzalez' ,`ListOfficeName` = 'Metro Plus Realty PLLC' ,`SellingAgentFullName` = 'Ana Gonzalez' ,`SellingOfficeName` = 'Metro Plus Realty PLLC' ,`Latitude` = '29.661945' ,`Longitude` = '-95.215459' ,`PhotoCount` = '34' ,`PostalCode` = '77587' ,`RoomCount` = '9' ,`ListPrice` = '359999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Avenue F' ,`StreetNumber` = '1205' ,`StreetSuffix` = '' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Take an opportunity to come visit this beautiful home built in an extended lot in South Houston area! The home has 4 bedrooms and 2.5 baths, plenty of space. To complement that there is a spacious of driveway parking available for up 8 cars! But along with space, the home has other qualities that truly make it stand out. A cozy and warm fire place to enjoy with your loves ones. A swimming pool with a beautiful water fall for those warm evenings, and even a mother in law suite to accommodate extra guests! This home truly is waiting for somebody to come right in and call it home..... Will that be you?' ,`Acres` = '0.326' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'South Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 11 & 12 BLK 289 SOUTH HOUSTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'PEARL HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Houston' ,`TaxAmount` = '7646' ,`TaxRate` = '2.8255' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794265' WHERE `Matrix_Unique_ID` = '212446683' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:14:47.207' ,`MLSNumber` = '59656078' ,`ListAgentFullName` = 'Dianna Morales' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736989' ,`Longitude` = '-94.958747' ,`PhotoCount` = '28' ,`PostalCode` = '77520' ,`RoomCount` = '9' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Aron' ,`StreetNumber` = '521' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful upgraded home conveniently located in a corner lot. The home has a cozy front porch that everyone can enjoy. Offers an open floor concept, which is perfect for entertaining guests and allows space to move freely throughout the home. Natural almond laminate flooring in the rooms with matching fans in every bedroom, along with tile in all wet areas, including the kitchen. Granite countertops with backsplash in the kitchen and restrooms along with the fresh new paint on the interior brighten up the home. A/C is new and the exterior of the home along with the interior of garage has been painted. Both bathrooms have been remodeled with new fixtures and tubs. Garage has a bonus room with door that can be used for additional storage. Schedule your appointment today for this must see home, don\'t miss this opportunity.' ,`Acres` = '0.0849' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 3 WRIGHT W P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '3700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'ASHBEL SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wright W P' ,`TaxAmount` = '3031' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794265' WHERE `Matrix_Unique_ID` = '212448159' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:25:14.967' ,`MLSNumber` = '59533845' ,`ListAgentFullName` = 'Elizabeth Marshall' ,`ListOfficeName` = 'Global Advantage Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.228940' ,`Longitude` = '-95.443580' ,`PhotoCount` = '22' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Haven' ,`StreetNumber` = '700' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very large updated home, 4 bedroom, Formal Living and Dining Rooms,Ceramic floored Den with Fireplace and blower, Entry Hall, Updated kitchen, double ovens, dishwasher, quartz counters, stainless steel appliances, Beautiful updated baths, walk-in shower, vanity, wet bar, .40 acre lot, great for family, garden, play area, extra storage building, AND WATER WELL FOR ALL YOUR WATERING NEEDS. Public water and private water well. Stair lift installed on stairway. Formals could easily be converted to Mother-in-law suite, shower could be added to half bath downstairs. Beautiful engineered wood flooring in Master Suite, Extra large bedroom, lots of room with king size bed.' ,`Acres` = '0.4132' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S828600 - RIVERBROOK-FOREST HLS, LOT 85, 86-A' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverbrook-Forest Hls' ,`TaxAmount` = '1700' ,`TaxRate` = '2.3044' ,`WaterSewer` = 'Water District,Well' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794265' WHERE `Matrix_Unique_ID` = '212486300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:21:32.340' ,`MLSNumber` = '78610837' ,`ListAgentFullName` = 'Nhung Samaan' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = 'Nhung Samaan' ,`SellingOfficeName` = 'Keller Williams Professionals' ,`Latitude` = '29.972741' ,`Longitude` = '-95.554897' ,`PhotoCount` = '32' ,`PostalCode` = '77070' ,`RoomCount` = '6' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Villa Lago' ,`StreetNumber` = '8019' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1623' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom - 2.5 bath Home located in gated community on a premium corner lot. Home has open floor plan and high ceilings. Family room with windows providing ample natural lighting warmly greets you as you enter the home. Large primary bedroom with walk-in closet. Primary bath has tub with separate shower and double sinks. The Island kitchen is beautiful with GRANITE countertops and stainless steel appliances. Partly covered patio deck with astro turf. Close to Vintage park, Kickerillo-Mischer Preserve, Willowbrook Mall and Methodist Hospital. Easy access to SH 249, Beltway 8. Property has never flooded per seller and did not lose power during Winter freeze. Front yard is maintained by HOA. Highly acclaimed Cy-Fair ISD. Will not last!' ,`Acres` = '0.0667' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 2 VILLAS AT WILLOWBROOK' ,`LotDesciption` = 'Corner' ,`LotSize` = '2904' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (CY-FAIR)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villas/Willowbrook' ,`TaxAmount` = '5059' ,`TaxRate` = '2.4087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794265' WHERE `Matrix_Unique_ID` = '212488045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:37:01.210' ,`MLSNumber` = '17318050' ,`ListAgentFullName` = 'Mariela Knapp' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140031' ,`Longitude` = '-95.521799' ,`PhotoCount` = '24' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '730000.00' ,`Status` = 'Active' ,`StreetName` = 'Arrow Canyon' ,`StreetNumber` = '78' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning house for sale! Every buyer requires four bedrooms, 3.5 baths, a three-car Tandem Garage, and a home office private with a french door. This house is David Weekley\'s home. Near to the elementary Creekside Forest. The best location at Creekside park. New roof, new paint in the entire house. High ceiling, floor, and kitchen update. Great layout, and it is easy to show this beautiful home. Near to HEB, shopping center, excellent restaurant, and amenities.' ,`Acres` = '0.2093' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 2 THE WOODLANDS VLG OF CREEKSIDE PARK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9116' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas 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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'The Woodlands Creekside Park' ,`TaxAmount` = '11624' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794265' WHERE `Matrix_Unique_ID` = '212517968' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:32:04.040' ,`MLSNumber` = '81901970' ,`ListAgentFullName` = 'Lindy Chappell' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.867954' ,`Longitude` = '-95.728785' ,`PhotoCount` = '32' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Settlers Square' ,`StreetNumber` = '6227' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story 3 bedroom Katy home in popular Lakeville! Fantastic opportunity to own a terrific low maintenance home. Small fenced back yard and garage access from the rear alley. Tile floors throughout - no carpet. Kitchen open to living room and dining. Primary en-suite bedroom with a Large walk-in closet. Ideal floor plan for starter home or downsizing. HOA mows the front yard. Well cared for, with many recent \"big ticket\" enhancements, such as: 9/22, interior completely repainted a neutral color and new water heater installed, 2021: tile flooring installed in the bedrooms and built-in microwave replaced, 2020: dishwasher replaced, 2019: roof and A/C condenser unit replaced, gas stove replaced in 2017, even the garage door was replaced in 2015! \r\nThis \"clean as a whistle\" home is move in ready, so if YOU are ready to make this house your HOME, make arrangements to see it soon!' ,`Acres` = '0.0618' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 1 LAKEVILLE SEC 1' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2690' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HEMMENWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeville Sec 01' ,`TaxAmount` = '4119' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794266' WHERE `Matrix_Unique_ID` = '212534115' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:35:51.403' ,`MLSNumber` = '15456664' ,`ListAgentFullName` = 'Nery Mazariegos' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.754348' ,`Longitude` = '-95.741964' ,`PhotoCount` = '34' ,`PostalCode` = '77450' ,`RoomCount` = '6' ,`ListPrice` = '382000.00' ,`Status` = 'Active' ,`StreetName` = 'Park Timbers' ,`StreetNumber` = '21526' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1927' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME to this *NEWLY REMODELED* home offering 3 bedrooms, 2 bathrooms, POOL & attached two-car garage. This gem is LOADED WITH UPGRADES- designer paint, luxe flooring, natural stone surrounded fireplace, ceiling fans, stylish light fixtures and hardware & tall tray ceilings with luxe crown molding. The home’s UPDATES include; new HVAC, new 30 year roof, all new SS appliances, fresh carpet & flooring, gleaming new Quartz countertops, new water heaters & brand new pool equipment. The newly renovated kitchen features freshly painted cabinets, sprawling countertops, a walk-in pantry, and beautiful gold hardware. Windows spread across the entire rear of the home for ample amounts of natural lighting & views of the backyard oasis. The layout is open & inviting! Retreat to the luxe primary suite that offers a large closet & spa-like ensuite bathroom. Step outside to enjoy your backyard w/ in-ground POOL & TUB, green space, and covered patio. Zoned to Katy ISD. Easy access to 99 & I-10.' ,`Acres` = '0.1627' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 81 BLK 2 MEMORIAL PARKWAY SEC 18' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '7089' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HAYES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Pkwy' ,`TaxAmount` = '6099' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794266' WHERE `Matrix_Unique_ID` = '212550496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:31:33.760' ,`MLSNumber` = '84468812' ,`ListAgentFullName` = 'Kevin Urrutia' ,`ListOfficeName` = 'Woodrow Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.233578' ,`Longitude` = '-95.705902' ,`PhotoCount` = '26' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '329995.00' ,`Status` = 'Active' ,`StreetName` = 'Red Poppy' ,`StreetNumber` = '40414' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2292' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Upon entry, you will notice its uniqueness in the long covered entryway and a layout of two bedrooms on the 1st floor and two bedrooms on the 2nd floor; perfect for overnight guests. The living space features a kitchen with an island open to the living room and dining area. The primary bathroom features a standup shower and a large walk-in closet. You will be surprised at the closet space for the bedrooms! There is a sprinkler system installed that covers the entire yard.' ,`Acres` = '0.1444' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S714800 - MILL CREEK ESTATES 01, BLOCK 3, LOT 62' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6290' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Estates 01' ,`TaxAmount` = '614' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663794266' WHERE `Matrix_Unique_ID` = '212592654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:15:39.997' ,`MLSNumber` = '76367215' ,`ListAgentFullName` = 'Evan Ballew' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.461178' ,`Longitude` = '-95.553546' ,`PhotoCount` = '49' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Starboard' ,`StreetNumber` = '15083' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1374' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FULLY REMODELED 3 bedroom, 2 bath, 1 story home in Conroe Bay Subdivision, a community on Lake Conroe with a gazebo and boat ramp. Bring the outdoor rockers and enjoy the HUGE covered front patio and basketball goal with addl concrete for extra parking! Inside features an open layout with the kitchen open to the oversize dining space and large living area. Updates include beautiful laminate flooring laid in 2021, granite counters, newer white cabinets, AC and water heater replaced in 2021 and fresh paint. The master suite is light and bright with an attached ensuite with mosaic tile flooring and an updated vanity. The two guest suites are generous in size with ceiling fans. This home sits on 2 lots giving it excellent side and backyard spaces! The large storage shed stays with the home and has plenty of space for tools or additional storage and the large hardwood trees provide additional shade. Excellent price! Excellent location and low HOAs! We do not expect this one to last long' ,`Acres` = '0.2181' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S344200 - CONROE BAY, BLOCK 2, LOT 33, 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Conroe Bay' ,`TaxAmount` = '2547' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794266' WHERE `Matrix_Unique_ID` = '212593290' --> 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','212603232','1663794266','212603232','2022-09-20T22:57:23.320','67884065','Yeinelda Mendoza','Generation Realty & Associates','','','29.972874','-95.408839','25','77073','10','299000.00','Active','Sweet Flower','707','Drive','Houston','2','1','4','2893','Single-Family','This beautiful, well-maintained, 1-owner house is ready for you to call home! This two-story house is one of the biggest houses built in Remington Ranch! All bedrooms are oversized! It has a total of 2,893sq ft. 4 bedrooms,2.5 baths, and a spacious game room ready for hosting game night! What makes this home unique is the extra room added to the house with a second stove with tons of space to make it whatever works best for you! Schedule a showing soon, this is one-of-a-kind and will definitely go fast!','','12','','','','','Mud,Sellers Disclosure','1','','','Aldine Area','Central Gas','1','Lot 3 Block 1 Remington Ranch Sec 22','Subdivision Lot','5607','Appraisal District','','570','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','48 - Spring','MILTON COOPER ELEMENTARY SCHOOL','ANDY DEKANEY H S','DUEITT MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,Request Online Appointment,Supra Keybox','Seller','2','Traditional','Remington Ranch','6695','2.8804','Public Sewer,Public Water','2011','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:02:59.413' ,`MLSNumber` = '89291055' ,`ListAgentFullName` = 'Daicel Prat' ,`ListOfficeName` = 'J.D. Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.873041' ,`Longitude` = '-95.474162' ,`PhotoCount` = '49' ,`PostalCode` = '77088' ,`RoomCount` = '11' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Antoine' ,`StreetNumber` = '7531' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2494' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunningly Renovated 4 Bedrooms, 2 1/2 Baths home overlooking the golf course in Inwood Forest! This beautiful home has received a Complete makeover for your enjoyment. Newly installed roof w/warranty & Newly installed HVAC system w/warranty. As soon as you walk in, the open-concept floor plan greets you to the beautiful golden fixtures/finishes. Just placed porcelain tile flooring on the 1st floor, newly installed carpet in bedrooms on the 2nd floor & laminate floor in Primary Suite. Entertain a family meal in the updated kitchen displaying Quartz countertops & new appliances. Recessed lights all throughout & white walls to indulge in the light-filled living area. Unwind under the rain shower in Primary Ensuite bathroom displaying newly installed tempered glass sliding shower glass doors. From recently placed Electrical Panel, new garage doors w/remote, toilets, & freshly painted interior/exterior.' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 1' ,`LotDesciption` = 'Cleared,Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '11543' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'SMITH ACADEMY' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'HOFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Frst Sec 7' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663794266' WHERE `Matrix_Unique_ID` = '212610885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:30:44.820' ,`MLSNumber` = '47801819' ,`ListAgentFullName` = 'Guillermo Martinez' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.555988' ,`Longitude` = '-95.723216' ,`PhotoCount` = '44' ,`PostalCode` = '77469' ,`RoomCount` = '7' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Helen Springs' ,`StreetNumber` = '22331' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home! available' ,`Acres` = '0.1377' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WILLIAMS RANCH SEC 2, BLOCK 1, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Ranch Sec 2' ,`TaxAmount` = '7524' ,`TaxRate` = '3.1798' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794266' WHERE `Matrix_Unique_ID` = '212619982' --> 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','212633018','1663794267','212633018','2022-09-20T22:13:04.360','20703957','Rose Gibson','BHGRE Gary Greene','','','29.804101','-95.495011','20','77055','6','325000.00','Active','Highcrest','8401','Drive','Houston','1','0','3','1236','Single-Family','Wonderful Opportunity to be in sought after neighborhood of Ridgecrest! Large 8,125sqft Treed Lot perfectly located on Quiet Street in Fast Growing Section of Spring Branch. New Construction Custom Homes popping up throughout. Close in town to Galleria, Memorial Area, Downtown, Memorial Park, 610, I-10, 290, Shops, and Restaurants. Update and Move In or Build New! Location, Location, Location!','0.1865','24','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Estate','1','','','Spring Branch','Central Gas','0','LT 6 BLK 1 RIDGECREST SEC 1','Subdivision Lot,Wooded','8125','Appraisal District','','','0','','1','Electric Oven','0','','','Gas Range','','Composition','49 - Spring Branch','RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)','NORTHBROOK HIGH SCHOOL','LANDRUM MIDDLE SCHOOL','Appointment Required,Supra Keybox','Seller','1','Ranch,Traditional','RIDGECREST Sec 01','3406','2.4415','Public Sewer,Public Water','1951','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:56:44.323' ,`MLSNumber` = '82075308' ,`ListAgentFullName` = 'Therese Landa' ,`ListOfficeName` = 'Houstonian Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.821981' ,`Longitude` = '-95.548300' ,`PhotoCount` = '32' ,`PostalCode` = '77043' ,`RoomCount` = '10' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Stetson' ,`StreetNumber` = '2726' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2447' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely home is located in the highly sought after Spring Shadows Neighborhood. This street has some of the nicest neighbors. The charming sidewalk leads to your front door. There is an elegant entry with formals on both sides. The kitchen is large and spacious. Lots of room for your gourmet activities. The Sunny breakfast room overlooks the back yard. There is a huge family/den with a cozy center fireplace. You could spend your time snuggling by the fire on cold nights. Upstairs the primary suite is enormous. The baths upstairs have been remodeled. The secondary bedrooms are also very spacious. There are shutters on most of the windows in the home. Which is great, you can control how much light you get in. Buy now, remodel on your schedule. This home is priced to sell and ready for your designer touches.' ,`Acres` = '0.2211' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK W1 SPRING SHADOWS SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9630' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '336' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'TERRACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Shadows Sec 09' ,`TaxAmount` = '7936' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794267' WHERE `Matrix_Unique_ID` = '212633602' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:43:11.473' ,`MLSNumber` = '80378986' ,`ListAgentFullName` = 'Dan Gad' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775341' ,`Longitude` = '-95.371776' ,`PhotoCount` = '18' ,`PostalCode` = '77007' ,`RoomCount` = '10' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Spring' ,`StreetNumber` = '1402' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2024' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate 3-level home in gated community with spacious private yard and rooftop terrace with spectacular downtown views! This home is also located in a great location on the Hike and Bike Trail that connects The Heights to Downtown and Buffalo Bayou park areas, also with easy access to I-10 and I-45. Home features dark bamboo wood floors, espresso Armstrong cabinetry, modern chrome hardware, vessel sinks, sparkling granite countertops, frosted bedroom doors and soaring 10 ft ceilings. First floor has a private bedroom with bathroom. Second floor is the open living area with surround sound speakers, kitchen with large island/breakfast bar, stainless Kitchen Aid convection oven and gas stove. The third floor has a secondary bedroom with a private bath and the master suite with private balcony. The forth floor offers a stunning rooftop terrace with views of downtown with plenty of room for a grill. Home offers commercial grade blinds and hurricane security film. Hurry, won’t last long!' ,`Acres` = '0.0445' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 ZENITH VILLAS' ,`LotDesciption` = 'Corner' ,`LotSize` = '1938' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Zenith Villas' ,`TaxAmount` = '8882' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794267' WHERE `Matrix_Unique_ID` = '212649934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:50:52.357' ,`MLSNumber` = '16916940' ,`ListAgentFullName` = 'Sheila Lewis' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928101' ,`Longitude` = '-95.185751' ,`PhotoCount` = '17' ,`PostalCode` = '77044' ,`RoomCount` = '10' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Chartley Falls' ,`StreetNumber` = '14434' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this beautiful 4-bedroom, 3.5 bathroom house your new home. Great open floorplan. Island kitchen with double ovens and stainless steel appliances. Covered back patio with super spacious backyard, quite possibly one of the largest backyards in the community. Don\'t hesitate! It won\'t last long.' ,`Acres` = '0.3476' ,`Area` = '1' ,`BuilderName` = 'Partners In Building' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 SUMMERWOOD SEC 7 EDGEWATER VLG' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15141' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood Sec 07 Edgewater 06' ,`TaxAmount` = '7811' ,`TaxRate` = '2.683' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794267' WHERE `Matrix_Unique_ID` = '212653212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:26:22.210' ,`MLSNumber` = '32631632' ,`ListAgentFullName` = 'Kay Robbins' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738407' ,`Longitude` = '-95.632868' ,`PhotoCount` = '24' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '259500.00' ,`Status` = 'Active' ,`StreetName` = 'Overbrook' ,`StreetNumber` = '13742' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming & Inviting best describes this cozy well maintained home. This warm friendly neighborhood is near the Energy Corridor, Eldridge Parkway & minutes from West Houston\'s growing medical center. Tasteful landscaping accents this pretty traditional entry. As you enter you will find the front living/dining area, leading to the kitchen and spacious den w/fireplace. Granite counters in the kitchen,gas cooktop. New faux wood mini-blinds. The den opens to the outdoor covered patio where you can relax & enjoy the mature landscaping & birds chriping.\r\nSpacious bedrooms and primary bath remodeled w/nice vanity,countertop,sink & faucet,tile floors. Nice condition and priced for buyer\'s personal remodeling. Competitive price to sell quickly and \"As IS\". Per seller no known defects of previous flooding.' ,`Acres` = '0.1667' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 BRIAR PARK SEC 1 R/P U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7260' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '565' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Park' ,`TaxAmount` = '4176' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794267' WHERE `Matrix_Unique_ID` = '212662119' --> 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','212685340','1663794267','212685340','2022-09-20T23:54:53.923','11226623','Erika Alvarez','Exceed Realty','','','29.682427','-95.272764','14','77017','3','150000.00','Active','Ogden','8118','Street','Houston','2','0','3','2208','Single-Family','**NO SHOWINGS** Property selling for Lot value only, The house is not safe to show per the seller\'s request, there is a lot of debris and utilities are not connected. The house needs a complete remodeling, buyer to verify school information.','0.4477','3','','','','','Sellers Disclosure','0','','','Hobby Area','Central Electric','0','LT 5 & TR 4A BLK 71 PARK PLACE COUNTRY CLUB','Other','19500','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','PARK PLACE ELEMENTARY SCHOOL','CHAVEZ HIGH SCHOOL','ORTIZ MIDDLE SCHOOL','Temporarily No Showings','Appraisal District','1','Traditional','Park Place Country Club','3951','2.3307','Public Sewer,Public Water','1935','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T22:31:09.950' ,`MLSNumber` = '38567139' ,`ListAgentFullName` = 'Rene Hightire' ,`ListOfficeName` = 'George E. Johnson Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.693841' ,`Longitude` = '-95.834203' ,`PhotoCount` = '37' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '469900.00' ,`Status` = 'Active' ,`StreetName` = 'Elizabeth Brook' ,`StreetNumber` = '11507' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2391' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move In Ready! Canyon Village at Westheimer Lakes, One Story Brick Perry Homes for Sale. Open Floor Plan with High Ceilings at End of 12\' Extended Entry, Welcomes you into your home. Tile and Wood Floors Throughout, Window\'s Encased Family Room provides natural light which flows into Kitchen and Breakfast Area. Kitchen has an Oversize Granite Top Island with storage cabinets on both sides; 42\' Cabinets with Chrome Handles. Primary Bedroom Suite has lots of Windows, Large walk in Closet, Dual Sinks, Garden Tub, Separate Shower and Private Commode. Spacious Dining area, large window in laundry room. Private Street Entrance to the Covered Extended Paver & Brick Backyard Patio that Overlooks a Greenbelt that has no neighbors at backyard. Entertainers Dream!' ,`Acres` = '0.1341' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON VILLAGE AT WESTHEIMER LAKES SEC 3, BLOCK 1, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5842' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '865' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas 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,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Village At Westheimer Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794267' WHERE `Matrix_Unique_ID` = '212694429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T23:28:02.803' ,`MLSNumber` = '56971880' ,`ListAgentFullName` = 'Robert Pollard' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835387' ,`Longitude` = '-95.682660' ,`PhotoCount` = '44' ,`PostalCode` = '77084' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Spellbrook' ,`StreetNumber` = '18310' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a fantastic home! 4 great size bedrooms, large den, formal dining, HUGE GAME ROOM DOWNSTAIRS could also be used as media room of formal living, Island kitchen and large breakfast room. Kitchen totally updated in 2016 with granite counter tops, Kitchenaid appliances, new cabinets w/soft closing drawers and cabinet doors, added island with electric. Other Updates include: Guest baths w/ cabinetry and tile. Downstairs is tile throughout, double pane windows, plantation shutters, light fixtures throughout, bathrooms have granite, downstairs A/C 2020. Outside is fantastic too! Gorgeous backyard with Oak trees for shade, swing and air conditioned 10x12 work shed, FULL sprinkler system, gutters replaced in 2016, exterior painted in 2016, front and back landscaping updated, back patio has been extended across the whole back for those outside parties. VERY POPULAR subdivision with greenbelt, tennis courts, large pool (and swim team). Very popular Wilson Elementary.' ,`Acres` = '0.2204' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 32 DEERFIELD VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village Sec 04' ,`TaxAmount` = '5196' ,`TaxRate` = '2.251' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794267' WHERE `Matrix_Unique_ID` = '212713754' --> 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','212717107','1663794268','212717107','2022-09-20T22:36:43.863','76436521','Porche Kimble','Legacy Homes & Properties, LLC','','','29.527396','-95.184982','18','77546','5','265000.00','Active','Oxnard','16406','Lane','Friendswood','2','0','3','1708','Single-Family','Quaint and cozy single story nestled in the established community of charming Friendswood. This 3 bedroom 2 bath home is exactly what you have been looking for! The family room has a wood burning fireplace with brick wall. Family room is open to kitchen, breakfast and formal dinning. The refrigerator is staying with the home. There are ceiling fans in each room. Lush green landscape surrounds this beautiful house. Large backyard with a pool and perfect for entertaining. This home is conveniently located to Bay Brook Mall, HEB, Walmart, Sam\'s and several restaurants. Home could use your special touch. Don\'t forget to schedule an appointment today! \r\n\r\nAll room dimensions are approximate - please verify.','0.1832','7','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Friendswood','Central Electric','1','LT 2 BLK 43 WEDGEWOOD VILLAGE SEC 6','Subdivision Lot','7980','Appraisal District','','60','0','','1','','1','Above Ground','','','','Composition','9 - Clear Creek','WEDGEWOOD ELEMENTARY SCHOOL','CLEAR BROOK HIGH SCHOOL','BROOKSIDE INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Request Online Appointment','Appraisal District','1','Traditional','Wedgewood Village Sec 06','4310','2.2534','Public Sewer,Public Water','1976','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','212719102','1663794268','212719102','2022-09-20T22:49:32.920','96673726','Raquel Johnson','Sapphire Homes Realty LLC','','','29.818776','-94.987440','40','77521','3','229000.00','Active','Black Rock','4822','Street','Baytown','2','0','3','1463','Single-Family','Very well maintained 3 Bed 2 Bath house in the heat of Eastpoint subdivision, this property features a very large covered back patio perfect to entertain your guests, Tile floors throughout the house, granite counter tops in the kitchen. Also a 2 yrs old roof, 1 year old AC unit and ducts. This is a must see!','0.1567','2','','','','','Sellers Disclosure','','','','Baytown/Harris County','Central Gas','1','LT 226 EASTPOINT R/P','Subdivision Lot','6825','Appraisal District','','280','0','','2','','0','','','','','Composition','23 - Goose Creek Consolidated','VICTORIA WALKER ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Eastpoint R/P','4931','2.97','Public Sewer,Public Water','1998','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','212747665','1663794268','212747665','2022-09-20T22:02:58.383','97550906','Yvonne Pruneda','Nan & Company PropertiesChristie\'s International R','','','29.160299','-95.629385','50','77486','11','419990.00','Active','Shalmar','2238','Drive','West Columbia','2','0','4','2402','Single-Family','This elegant New Construction single family home sits on a tree-lined street in highly desirable Columbia Lakes, a breathtaking community, surrounded by 2,000 wooded acres, lakes, and lagoons. The sleek front elevation and thoughtfully landscaped grounds invite you into the front yard. Meticulous attention to detail is presented in the kitchen with quartz countertops, customized backsplash, custom fitted cabinets, and brand-name appliances. Adjacent to the living room an oversized primary bedroom with en-suite bathroom featuring double sinks, stand-alone shower, soaking tub, and a walk-in closet. Other features of this home include a study, 3-secondary bedrooms w/full bath, and spacious utility room. The backyard includes a large, covered patio providing plenty space for gardening and entertaining. Upgraded to the max this home is move-in ready; stop in today!','0.2391','5','Barrientos Construct','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections','1','West of the Brazos','Central Gas','1','COLUMBIA LAKES SEC 2 (A0133 M VARNER) BLK 25 LOT 17','On Golf Course,Subdivision Lot','10415','Appraisal District','','600','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','10 - Columbia-Brazoria','','COLUMBIA HIGH SCHOOL','WEST BRAZOS JUNIOR HIGH','Appointment Required,Lockbox Front,Vacant/Unoccupied','Builder','1','Traditional','Columbia Lakes Sec 1-2-3-4-5','911','2.1863','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212751406','1663794268','212751406','2022-09-20T23:23:05.470','16966584','Alexandra Marquez','Zarco Properties, LLC','','','30.324927','-95.507290','40','77304','6','584000.00','Active','Pilot Point','7','','Conroe','4','1','4','3156','Single-Family','Come live a great lifestyle in this brand new custom home on this wonderful Golf Course Community. Home features 1.5 stories, 4 bedrooms, 4.5 baths, high ceilings, lots of natural light, huge gameroom upstairs w/full bath, plus a small flex area downstairs, covered back pork & a full 2 Car Garage with Epoxy flooring. Stucco & brick exterior, wood tile all throughout, large open island kitchen with quartz countertop & large pantry, SS appliances & tons of storage, all bathrooms with granite countertops & electric mirrors. Sprinkler system added, too. Easy access to I-45.','','19','Stonewood Landmark','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Lake Conroe Area','Central Gas','1','S949103 - West Fork 03, Block 7, Lot 45','Corner,Cul-De-Sac','11935','Appraisal District','','450','1','Never Lived In','3','','0','','','Gas Range','','Composition','11 - Conroe','GIESINGER ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Lockbox Front','Builder','1.5','Traditional','West Fork','','2.1863','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212751650','1663794268','212751650','2022-09-20T22:41:03.337','45325570','Alexandra Marquez','Zarco Properties, LLC','','','30.325142','-95.507077','46','77304','5','594000.00','Active','West Fork','4783','Boulevard','Conroe','4','1','4','3278','Single-Family','This one checks all the boxes! Come live a great lifestyle in this brand new, custom home on a huge lot in this wonderful Golf Course Community. Home features 1.5 stories, 4 bedrooms, 4.5 baths, high ceilings, lots of natural light, huge gameroom upstairs w/full bath, plus study, covered back pork, summer kitchen with granite countertop, 3 Car Garage with Epoxy flooring & Sprinkler System. Stucco & brick exterior, wood tile all throughout, large open island kitchen with quartz countertop, SS appliances & tons of storage. All bathrooms have large showers, granite countertops & electric mirrors. Easy access to I-45.','0.3792','19','Stonewood Landmark','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Lake Conroe Area','Central Gas','1','S949103 - WEST FORK 03, BLOCK 7, LOT 46, ACRES 0.3792','Subdivision Lot,Wooded','16518','Appraisal District','','450','1','Never Lived In','3','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','GIESINGER ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Lockbox Front','Builder','2','Traditional','West Fork 03','1030','2.1863','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212751671','1663794268','212751671','2022-09-20T22:37:44.923','36367823','Zahabia Bandukwala','REALM Real Estate Professional','','','30.031764','-95.374533','9','77338','9','225000.00','Active','Skyla','21530','Circle','Humble','2','0','3','1383','Single-Family','COMPLETELY RENOVATED WITH NEW FLOORING, CARPET, LIGHT FIXTURES, DOORS, BRAND NEW KITCHEN, AND APPLIANCES. OPEN FLOOR PLAN, FIREPLACE, BREAKFAST AREA, 3 BEDROOMS, 2 BATHS, PRIMARY BEDROOM, HAS SHOWER AND BATH, 2 SINKS, FENCED YARD.','','12','','','Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Aldine Area','Central Gas','1','LT 42 BLK 2 WERRINGTON SEC 1','Subdivision Lot','5042','Appraisal District','','620','0','','2','Electric Oven','0','','','Gas Range','','Composition','1 - Aldine','OGDEN ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','TEAGUE MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Werrington Sec 01','','','Water District','2006','Appraisal District'); --> New record created successfully