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-12-02T16:08:52.380' ,`MLSNumber` = '39121352' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802055' ,`Longitude` = '-95.329754' ,`PhotoCount` = '10' ,`PostalCode` = '77026' ,`RoomCount` = '4' ,`ListPrice` = '185999.00' ,`Status` = 'Active' ,`StreetName` = 'Leffingwell' ,`StreetNumber` = '4601' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a cute 2 bedroom and 1 bathroom home located inside the 610 loop near Lyndon B Johnson Hospital. Newly remodeled home give you modern touches without losing the historic feel. It features fresh interior/exterior paint, new fixtures, vinyl wood flooring in living areas, new carpet in bedrooms, and a nice kitchen area. New 30 year roof! This is the perfect starter home for those looking to live near central Houston. What are you waiting for? Give us a call today!' ,`Acres` = '0.2686' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 35 CITY GARDENS SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City Gardens Sec 01' ,`TaxAmount` = '1553' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086534' WHERE `Matrix_Unique_ID` = '209689054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:22:31.450' ,`MLSNumber` = '46300011' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708579' ,`Longitude` = '-95.299085' ,`PhotoCount` = '11' ,`PostalCode` = '77087' ,`RoomCount` = '2' ,`ListPrice` = '199999.00' ,`Status` = 'Active' ,`StreetName` = 'Linden' ,`StreetNumber` = '6705' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2 bedroom, 1 bathroom home is the perfect place for you and your family. It features hard wood flooring in select areas and a large backyard for your kids and pets to play in. It presently features foundation repairs and new roof. It will soon feature interior/exterior cosmetic repairs throughout the home! This property is centered around schools, shops, eateries and plenty of parks with quick access to I-45 South. Great location just fifteen minutes away from downtown Houston and the Houston Museum District! Contact us for more information!' ,`Acres` = '0.1452' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 73 PECAN PARK PLACE SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SOUTHMAYD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Park Place Sec 01' ,`TaxAmount` = '2622' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1943' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086534' WHERE `Matrix_Unique_ID` = '210525654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T15:31:44.233' ,`MLSNumber` = '75859190' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861354' ,`Longitude` = '-95.797031' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '482375.00' ,`Status` = 'Active' ,`StreetName` = 'Marsh Lake' ,`StreetNumber` = '6022' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2637' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Fitzgerald plan features four bedrooms, three full bathrooms, and an upstairs gameroom!' ,`Acres` = '0.1859' ,`Area` = '25' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 5, Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8100' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`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` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Katy Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086534' WHERE `Matrix_Unique_ID` = '210554535' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:58:36.217' ,`MLSNumber` = '90482891' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.261069' ,`Longitude` = '-95.463103' ,`PhotoCount` = '44' ,`PostalCode` = '77515' ,`RoomCount` = '13' ,`ListPrice` = '774990.00' ,`Status` = 'Active' ,`StreetName` = 'Chenango Ranch' ,`StreetNumber` = '303' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on almost 2.5 acres, the Laguna II is a sophisticated design packed with unique features! A 2 story grand entry with a sweeping spiral staircase, along with a two-story family room makes an impressive statement in this stunning five-bedroom plan. The secluded primary suite features a huge luxurious bathroom with his and hers walk-in closets, separate vanities, a large soaker tub, and a separate oversized walk-in shower. This home makes entertaining a breeze with a family-size media and game room on the second story.' ,`Acres` = '2.465' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 5, Section 1' ,`LotDesciption` = 'Other' ,`LotSize` = '107375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Chenango Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086535' WHERE `Matrix_Unique_ID` = '210637343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:58:12.207' ,`MLSNumber` = '10349414' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.263719' ,`Longitude` = '-95.471467' ,`PhotoCount` = '21' ,`PostalCode` = '77515' ,`RoomCount` = '9' ,`ListPrice` = '699990.00' ,`Status` = 'Active' ,`StreetName` = 'Redbird' ,`StreetNumber` = '711' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning plan includes 4 bedrooms, 3.5 bathrooms, a gameroom & a covered patio!' ,`Acres` = '2.031' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12, Block 2, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '88470' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chenango Ranch' ,`TaxAmount` = '' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086535' WHERE `Matrix_Unique_ID` = '210726627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:57:49.400' ,`MLSNumber` = '87818732' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.264366' ,`Longitude` = '-95.468002' ,`PhotoCount` = '30' ,`PostalCode` = '77515' ,`RoomCount` = '10' ,`ListPrice` = '713990.00' ,`Status` = 'Active' ,`StreetName` = 'Chenango Lake' ,`StreetNumber` = '21303' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The gorgeous Frisco plan boasts 5 bedrooms, 4 bathrooms & a gameroom and media room!' ,`Acres` = '1.385' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '60330' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Chenango Ranch' ,`TaxAmount` = '' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086535' WHERE `Matrix_Unique_ID` = '210730116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:57:19.637' ,`MLSNumber` = '83069526' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.261058' ,`Longitude` = '-95.464189' ,`PhotoCount` = '29' ,`PostalCode` = '77515' ,`RoomCount` = '11' ,`ListPrice` = '718990.00' ,`Status` = 'Active' ,`StreetName` = 'Chenango Ranch' ,`StreetNumber` = '319' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Castlerock Communities highly sought-after Frisco plan is a beautiful, spacious 5 bedroom/4 bathroom, 2 story home that is situated on 1.62 acres! Your new home greets you with a 2 story grand entry that boasts a sweeping spiral staircase! Retreat into the study through 8ft double doors! The huge eat-in island kitchen features built-in stainless steel GE appliances and a large walk-in pantry! Engineered wood flooring throughout main living areas of 1st floor. Separate media and game room upstairs. Upgraded kitchen countertops, cabinets, and appliances! Upgraded 3 car garage with 8ft garage doors and a huge dedicated area for a shop or extra storage!' ,`Acres` = '1.62' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7, Block 5, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '70567' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Chenango Ranch' ,`TaxAmount` = '' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086535' WHERE `Matrix_Unique_ID` = '210956810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T15:30:58.357' ,`MLSNumber` = '52390163' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.805640' ,`Longitude` = '-95.068840' ,`PhotoCount` = '18' ,`PostalCode` = '77351' ,`RoomCount` = '8' ,`ListPrice` = '207990.00' ,`Status` = 'Active' ,`StreetName` = 'Hollow Oak' ,`StreetNumber` = '203' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FLEX SPACE | OPEN-CONCEPT LAYOUT\r\nDon’t miss this opportunity to own a BEAUTIFUL NEW 2 Story home in the Cedar Point Community! The elegant 2002 Plan offers flex room on the main floor. The kitchen features gorgeous cabinets, granite countertops, and stainless-steel appliances (includes, range, microwave, and dishwasher). All bedrooms including the laundry room are on the 2nd floor. The primary suite has a private bath with dual vanity sinks and a walk-in closet. This desirable plan also comes complete with a 2-car garage.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = 'Century Complete Bld' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 1 BLK 12 LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '566' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Point' ,`TaxAmount` = '' ,`TaxRate` = '1.81' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086535' WHERE `Matrix_Unique_ID` = '212783520' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:14:56.177' ,`MLSNumber` = '17579438' ,`ListAgentFullName` = 'Miguel Canas' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '36' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5027' ,`StreetNumber` = '531' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2225' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular Home!! This home features luxurious interior finished throughout. Stunning Open concept! Three bedroom down includes primary, guess room upstairs with a full bath, all bedrooms are equipped with ceiling fan. The primary bathroom has a shower completed with Quartz slab, deep soaking tub and Quartz countertops with double vanities. The Kitchen comes with brand new Samsung appliances including Refrigerator, Custom make cabinets and a Quartz large island with a lot of cabinetry, large walk-in pantry, all blinds included. Beautiful flooring tile and huge cover patio with two ceiling fan. The attached oversized 2 car garage features a built in storage room, 30 years Timberland roof. This Home sits on a large corner lot. Make this your primary home!!' ,`Acres` = '0.51' ,`Area` = '52' ,`BuilderName` = 'Gilbero Estrada' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAMINO REAL, SEC 3, BLOCK 13, LOT 726, ACRES 0.5100' ,`LotDesciption` = 'Corner' ,`LotSize` = '22216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Camino Real, Sec 3' ,`TaxAmount` = '1307' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675086536' WHERE `Matrix_Unique_ID` = '213028848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T15:22:03.870' ,`MLSNumber` = '20511224' ,`ListAgentFullName` = 'Aneline Herrero' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.636658' ,`Longitude` = '-95.467068' ,`PhotoCount` = '11' ,`PostalCode` = '77085' ,`RoomCount` = '7' ,`ListPrice` = '264888.00' ,`Status` = 'Active' ,`StreetName` = 'Violet Path' ,`StreetNumber` = '5535' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With a NEW AC UNIT. Remarkable 2004 Beazer Home. Located on a corner lot with a large yard. Only 7 miles away from the Texas Medical Center. Back to Green belt. All rooms have ceiling fans and blinds. The formal living has arched openings—a large den with a ceiling fan. The bright kitchen features a breakfast bar, electric oven, maple-colored cabinets, pantry, and stainless sink. The master has a walk-in closet and a tub in The Bath. 3 Additional bedrooms and a full bath with a tub. Living room was recently painted to a neutral color.' ,`Acres` = '0.1122' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 POST OAK PLACE SEC 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '4887' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HINES-CALDWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Oak Place Sec 05' ,`TaxAmount` = '4604' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086536' WHERE `Matrix_Unique_ID` = '213689440' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T15:54:17.310' ,`MLSNumber` = '24491869' ,`ListAgentFullName` = 'Cameron Namazi' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672408' ,`Longitude` = '-95.496818' ,`PhotoCount` = '31' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Rutherglenn' ,`StreetNumber` = '6027' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful ranch style home in the Meyerland area. 3 bedrooms, 2 full baths. The perfect starter home for a family in the quiet neighborhood of Maplewood. The living room is spacious with a cozy fireplace. An extra room included that could be used as a playroom or study room. The kitchen is upgraded with high-end stainless steel appliances and light fixtures. Quartz countertops throughout the home. Fully renovated master bath. The backyard is complete with an upgraded swimming pool, and a detached 2 car garage. The neighborhood amenities include a park, soccer field, pool, and swim team. Easy access to I-610. Home did NOT flood during Harvey! Call and make an appointment to view your future home!' ,`Acres` = '0.1901' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 20 MAPLEWOOD SOUTH SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '453' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ELROD ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Maplewood South Sec 06' ,`TaxAmount` = '6839' ,`TaxRate` = '2.6304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675086536' WHERE `Matrix_Unique_ID` = '213770278' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:34:46.330' ,`MLSNumber` = '53031859' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151246' ,`Longitude` = '-95.615713' ,`PhotoCount` = '33' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '264990.00' ,`Status` = 'Active' ,`StreetName` = 'Grey Fox' ,`StreetNumber` = '27254' ,`StreetSuffix` = 'Run' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOODED VIEWS! Colina Homes believes in building your dream 1-Story w/ 3 Bedrooms + 2 Full Baths at a price you CAN afford! Come see this open-concept home (same as MODEL HOME) with space in all the right places. This beautiful Kitchen features Dark 42” Shaker Cabinets + Luxury Granite + Mosaic Tile Backsplash on Herringbone Pattern + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a HUGE walk-in Closet, 36\"-High Cabinets with Double Sinks, Large soaking Garden Tub with Arm Rests & Spacious Separate Shower with Shampoo Ledge! Stone Accents, 3-Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System & much more! This Energy Efficient home will SAVE you $$$! CALL & MAKE YOUR APPOINTMENT TO VISIT TODAY!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27 Block 2 Sec 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086536' WHERE `Matrix_Unique_ID` = '213817625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:48:47.083' ,`MLSNumber` = '57751275' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147385' ,`Longitude` = '-95.617508' ,`PhotoCount` = '15' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Whooping Crane' ,`StreetNumber` = '10137' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mill Creek Trails Quick Move - In Colina Homes believes in building your dream 1-Story w/ 3 Bedrooms + 3 Full Baths at a price you CAN afford! Come see this open-concept home that lives BIG. Large, Spacious Kitchen with 42” Dark, Rich Cabinets + Luxury Granite + Subway Tile Backsplash on Grid + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Extra-Large Master Suite that boasts a walk-in Closet, 36\" Cabinets w/ Double Sinks, Large soaking Garden Tub with Arm Rests & Spacious Separate Shower with Shampoo Ledge! 3-Sides Acme Brick, 2” Faux Wood Blinds, 16 SEER Lennox Air System, In-Wall Pest Defense System & much more! Garage door opener included! This Energy Efficient home will SAVE you $$$! CALL & MAKE YOUR APPOINTMENT TO VISIT TODAY! 365 DAY RATE LOCK WITH 1X RATE FLOAT DOWN AVAILABLE.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1 Sec 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086537' WHERE `Matrix_Unique_ID` = '213857281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:48:05.090' ,`MLSNumber` = '52025052' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150209' ,`Longitude` = '-95.615596' ,`PhotoCount` = '36' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Grey Fox' ,`StreetNumber` = '27130' ,`StreetSuffix` = 'Run' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2102' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mill Creek Trails Quick Move - In Why pay Woodlands pricing when you can have this brand new Colina Home just minutes away. Nestled inside mature trees Colina Homes has introduced one of it\'s greatest plans, the 2102. This home features a two story living room as well as 2 bedrooms down and 2 up giving you a versatile plan. As expected from Colina Homes this house comes loaded with features most builders consider upgrades: Premium level granite in kitchen, stainless appliance package, 42\" birch cabinets, barn sink, upgraded back splashes, 2 fans, 2\" faux wood blinds through out, covered back patio, 2 sinks in master bath, oversized shower, extensive luxury vinyl planked floors including the living room and extended entry, and so much more. Colina is offering unprecedented so call for more details, Please visit our model located at 10005 Ocelot Court, Magnolia, TX 77354.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 1 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086537' WHERE `Matrix_Unique_ID` = '214155703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:47:24.513' ,`MLSNumber` = '21080348' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.148441' ,`Longitude` = '-95.616456' ,`PhotoCount` = '36' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Kestrel Trail' ,`StreetNumber` = '27120' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2102' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mill Creek Trails Quick Move - In Magnolia ISD-365 Day Rate Lock Available. Priced to SELL w/ impressive features. 2 story 4 bedrooms/ 3 BATH HOME/3 Sides Brick, Decked out with an upgraded kitchen island,9\" deep farm sink with a modern designer kitchen B/S. The kitchen is open to the family room, 42\" Sleek kitchen cabinets+stainless steel appliances to include a SS 5 burner stove+microwave+ Elegant Vinyl Wood Floors in the Entry, Foyer, Hallways, Family Room;Carpet only in the bedrooms, Blinds, Covered Back Patio,Agreeable Grey Interior Paint, 16 SEER HVAC, Pex Plumbing System, Vinyl Double Pane E Windows that open to the inside of the home for cleaning. Amenities of the community to include a Brand New PlayGround & Picnic Area. Located only 8 minutes from Hwy 249, 12 minutes from Hwy 99, and 35 minutes from Downtown Houston, Work & Shop in the City & Come Home to Mill Creek Trails. Visit the model home: 10005 Ocelot Ct. Magnolia, Tx 77354.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 3 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5726' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086537' WHERE `Matrix_Unique_ID` = '214155844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:46:51.177' ,`MLSNumber` = '51325797' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147972' ,`Longitude` = '-95.615597' ,`PhotoCount` = '15' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Grey Fox run' ,`StreetNumber` = '27126' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mill Creek Trails Quick Move - In Colina Homes believes in building your dream 1-Story w/ 3 Bedrooms + 3 Full Baths at a price you CAN afford! Come see this open-concept home with space in all the right places. This beautiful Kitchen features 42” Shaker Cabinets + Stormy Night Dolomite Polished Premium Granite + Tiled Backsplash on a Herringbone Pattern + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a HUGE walk-in Closet, 36\"-High Cabinets with Double Sinks, garden tub and separate shower. 3-Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System & much more! This Energy Efficient home will SAVE you $$$! Ask about our amazing programs like \"Up to 365 Day Rate Lock\". Visit the model home located at 10005 Ocelot Court, Magnolia, TX 77354' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 1 Sec 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086537' WHERE `Matrix_Unique_ID` = '214158493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-02T16:46:09.137' ,`MLSNumber` = '32686643' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.147952' ,`Longitude` = '-95.615560' ,`PhotoCount` = '15' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Grey Fox Run' ,`StreetNumber` = '27087' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mill Creek Trails Quick Move - In Colina Homes believes in building your dream 1-Story w/ 3 Bedrooms + 3 Full Baths at a price you CAN afford! Come see this open-concept home with space in all the right places. This beautiful Kitchen features 42” Shaker Cabinets + Fantasy Brown Premium Granite + Tiled Backsplash on a Herringbone Pattern + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a HUGE walk-in Closet, 36\"-High Cabinets with Double Sinks, garden tub and separate shower. 3-Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System & much more! This Energy Efficient home will SAVE you $$$! Ask about our amazing programs like \"Up to 365 Day Rate Lock\". Visit our model home, 10005 Ocelot Ct. Magnolia , TX 77354' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 2 Sec 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675086538' WHERE `Matrix_Unique_ID` = '214238883' --> 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','214721707','1675086538','214721707','2022-12-02T16:36:37.663','49725639','Justin Dickey','Keller Williams Professionals','','','30.151246','-95.615713','34','77354','7','264990.00','Active','Grey Fox','27114','Run','Magnolia','2','0','4','1412','Single-Family','Colina Homes believes in building your dream 1-Story w/ 4 Bedrooms + 2 Full Baths at a price you CAN afford! Come see this open-concept home with space in all the right places. This beautiful Kitchen features 42” Shaker Cabinets + Fantasy Brown + Herringbone Tiled Backsplash + Stainless \"Farmhouse\" deep single-bowl sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a walk-in Closet, tall base cabinets with double sinks, and large shower. 3-Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System & much more! This Energy Efficient home will SAVE you $$$! Ask about our amazing programs such as \"Up to 365 Day Rate Lock\" and other programs.','','15','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Magnolia/1488 East','Central Gas','1','Lot 8 Block 1 Sec 2','Subdivision Lot','5080','Other','','450','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Mill Creek Trails','','3.11','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','214723913','1675086538','214723913','2022-12-02T16:40:11.907','74429293','Justin Dickey','Keller Williams Professionals','','','30.150209','-95.615596','44','77354','7','309990.00','Active','Grey Fox','27110','Run','Magnolia','3','0','4','2102','Single-Family','MILL CREEK TRAILS Quick Move-In !! Colina Homes believes in building your dream 2-Story w/ 4 Bedrooms + 3 Full Baths at a price you CAN afford! Come see this open-concept home with space in all the right places. This beautiful Kitchen features 42” Shaker Cabinets + Stormy Night Premium Granite + Subway tile Backsplash + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a HUGE walk-in Closet, 36\"-High Cabinets with Double Sinks, separate shower. 3-Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System & much more! This Energy Efficient home will SAVE you $$$! Please visit our model located at 10005 Ocelot Court, Magnolia, TX 77354.','','15','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Magnolia/1488 East','Central Gas','1','Lot 9 Block 1 Section 2','Subdivision Lot','','Survey','','450','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Accompany','Builder','2','Traditional','Mill Creek Trails','','3.11','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','215114439','1675086538','215114439','2022-12-02T15:55:31.687','81851200','Becky Wied','Wied Realty','','','29.317111','-96.100193','17','77488','2','142950.00','Active','Richmond','620','Road','Wharton','0','1','0','500','Single-Family','The possibilities are endless. 2 large rooms, half bathroom building and oversized covered parking bay for your motorhome right next to the building. Property was formerly used as a barber shop. Corner lot. High traffic area for 24/7/365 advertising exposure.','0.1446','55','','','','','Sellers Disclosure','0','','0','','Central Electric','0','COLLEGE HEIGHTS LOT 21B','Corner','6299','Appraisal District','','','0','','0','','0','','','','','Aluminum','180 - Wharton','CG SIVELLS/WHARTON ELEMENTARY SCHOOL','WHARTON HIGH SCHOOL','WHARTON JUNIOR HIGH','Appointment Required','Appraisal District','1','Other Style','College Heights','749','2.3512','Public Sewer,Public Water','1950','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215168464','1675086538','215168464','2022-12-02T16:41:54.210','66686346','Justin Dickey','Keller Williams Professionals','','','30.147952','-95.615560','15','77354','8','305185.00','Active','Grey Fox Run','27098','','Magnolia','3','0','3','1784','Single-Family','Mill Creek Trails Quick Move - In Colina Homes believes in building your dream 1-Story w/ 3 Bedrooms + 3 Full Baths at a price you CAN afford! Come see this open-concept home with space in all the right places. This beautiful Kitchen features 42” Shaker Cabinets + Fantasy Brown Premium Granite + Tiled Backsplash on a Herringbone Pattern + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a HUGE walk-in Closet, 36\"-High Cabinets with Double Sinks, garden tub and separate shower. 3-Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System & much more! This Energy Efficient home will SAVE you $$$! Ask about our amazing programs like \"Up to 365 Day Rate Lock\". Visit our model home, 10005 Ocelot Ct. Magnolia , TX 77354','','15','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','0','Magnolia/1488 East','Central Gas','1','Lot 12 Block 1 Sec 2','Cul-De-Sac,Subdivision Lot','4800','Survey','','450','1','To Be Built/Under Construction','2','','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Mill Creek Trails','','3.11','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','215224255','1675086538','215224255','2022-12-02T16:56:25.960','13098112','Patrick McGrath','Meritage Homes Realty','','','29.515015','-95.320048','15','77584','4','418740.00','Active','Spanish Moss','6412','Drive','Pearland','3','1','4','2425','Single-Family','Brand NEW energy-efficient home ready May 2023! Step your family’s game nights up in the Pioneer’s impressive second floor game room. Downstairs, the main level primary suite offers privacy from the other bedrooms and features dual sinks and large walk-in closet. Escape the bustle of the city without adding to your commute. Located in popular Pearland, Massey Oaks combines outdoor amenities like lakes, parks, and trails with everyday conveniences like access to shopping, dining, and entertainment. The neighborhood is zoned in the desirable Alvin ISD. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.','','5','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Heat Pump','1','SF 0109 Plan L470C','Subdivision Lot','','','','600','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','G W HARBY J H','Appointment Required','Builder','2','Traditional','Massey Oaks','','3.67','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','215224269','1675086538','215224269','2022-12-02T16:56:54.210','60686181','Patrick McGrath','Meritage Homes Realty','','','29.515090','-95.320005','17','77584','4','436090.00','Active','Spanish Moss','6420','Drive','Pearland','3','1','4','2636','Single-Family','Brand NEW energy-efficient home ready May 2023! Turn the kids loose in the Royal’s second-story media and game rooms while you entertain in the open concept great room. The main level primary suite boasts dual sinks and a walk-in closet. Escape the bustle of the city without adding to your commute. Located in popular Pearland, Massey Oaks combines outdoor amenities like lakes, parks, and trails with everyday conveniences like access to shopping, dining, and entertainment. The neighborhood is zoned in the desirable Alvin ISD. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.','','5','Meritage Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Heat Pump','1','SF 0111 Plan L481D','Subdivision Lot','','','','600','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','G W HARBY J H','Appointment Required','Builder','2','Traditional','Massey Oaks','','3.67','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','215232601','1675086538','215232601','2022-12-02T16:25:27.927','76324508','Dan Cook','SWE Homes','','','29.892408','-95.220788','6','77044','3','165999.00','Active','Kingslake Forest','11806','Drive','Houston','2','0','3','1410','Single-Family','Mobile home with 3 bedrooms and 2 baths located in Northeast Houston! The home will feature fresh paint on the porch and interior, new laminate vinyl in the living room and kitchen, and new carpet throughout bedrooms. Give us a call today for more information!','0.101','2','','','','','No Disclosures','','','','Northeast Houston','Other Heating','0','LT 17 BLK 2 GREENSBROOK SEC 1 R/P','Other','4400','Appraisal District','','','0','','0','','0','','','','','Composition','46 - Sheldon','GARRETT ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','MICHAEL R. NULL MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Other Style','Greensbrook Sec 01 R/P','2106','3.1593','Other Water/Sewer','2001','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','215251155','1675086538','215251155','2022-12-02T16:34:12.853','70671630','Judy Emmett','JLA Realty','','','30.733968','-95.526905','11','77320','10','159900.00','Active','Highway 30','1450','','Huntsville','2','0','3','1296','Single-Family','This house is an estate. It is being sold \"AS IS\". This property is on .5 of an acre. 3 bedrooms, 2 baths, 1 car port.\r\n\r\nNice property. The house has split bedroom, den, livingroom. breakfast room.','0.5','43','','','Electric Dryer Connections,Washer Connections','','No Disclosures','','','','Huntsville Area','Central Gas','0','MCMILLIAN T P (A-388), TRACT 35, ACRES .5','Other','21780','Appraisal District','','','0','','0','Freestanding Oven,Gas Oven','0','','','Freestanding Range','','Composition','64 - Huntsville','SCOTT JOHNSON ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Lockbox Front,No Supra Keybox','Appraisal District','1','Traditional','Mcmillian','1715','1.8868','Public Sewer,Public Water','1945','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215272491','1675086538','215272491','2022-12-02T16:47:59.223','5610251','Samantha Sloan','The Texas Living Real Estate G','','','30.171788','-95.199697','39','77357','3','335000.00','Active','Kelly Meadows','18718','Lane','New Caney','2','1','3','2522','Single-Family','Beautiful home on a cul-de-sac street in fabulous Tavola! NO BACK NEIGHBORS and close to greenbelts and park/clubhouse/pool. Step into one of the best designed floorplans in the neighborhood. Open living concept with a private study with double french doors, large island kitchen with an abundance of cabinet space and countertops, large pantry and extra storage closet! Kitchen conveniently open to living area with natural light and cozy fireplace. Two spacious secondary bedrooms that share a guest bath are at the front of the home opposite the secluded Owner\'s retreat with offers an overly spacious bedroom, large bath with separate tub/shower, and a closet to brag to your friends about! Outside, you\'ll enjoy a private backyard with no back fence neighbors, covered patio, and room to entertain. The SuperClean and organized family lives here and this home has been lovingly maintained. Immaculate! Quick access to 59, 99 Grand Pkwy, shopping, dining, and entertainment!','0.1478','40','','','','','Mud,Sellers Disclosure','','Gaslog Fireplace','1','Porter/New Caney East','Central Gas','1','S921104 - TAVOLA 04, BLOCK 1, LOT 3','Subdivision Lot','6438','Appraisal District','','800','0','','2','','0','','','','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Tavola 04','8936','3.3731','Water District','2018','Appraisal District'); --> New record created successfully