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-19T14:24:11.217' ,`MLSNumber` = '90857603' ,`ListAgentFullName` = 'Zulma Cuevas' ,`ListOfficeName` = 'DBL Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.952095' ,`Longitude` = '-95.903307' ,`PhotoCount` = '20' ,`PostalCode` = '77864' ,`RoomCount` = '3' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairview' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Street' ,`City` = 'Madisonville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS!! Older Home with many Updates in a Great Location! This home features three-bedrooms, 2 full bathrooms, laminate flooring, a separate dining area, and carport. Situated on a corner lot, this property would make a great starter home or investment as it is currently used as a rental. The mobile home at the back of property is also leased and will convey with the sale of the property. Historic Madisonville has so much to offer its residents, including Madisonville ISD, several nearby restaurants, and shopping. Roof replaced OCT 2022.' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Madisonville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0010 JOB S COLLARD TRACT 329 .479 ACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '175 - Madisonville Consolidated' ,`SchoolElementary` = 'MADISONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MADISONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'NA' ,`TaxAmount` = '1059' ,`TaxRate` = '2.4226' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675093177' WHERE `Matrix_Unique_ID` = '209313899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T14:23:32.157' ,`MLSNumber` = '89553482' ,`ListAgentFullName` = 'Zulma Cuevas' ,`ListOfficeName` = 'DBL Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.945328' ,`Longitude` = '-95.912028' ,`PhotoCount` = '25' ,`PostalCode` = '77864' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Whistle and 602 S Madison' ,`StreetNumber` = '101' ,`StreetSuffix` = 'Street' ,`City` = 'Madisonville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS! these units are roughly 1,074 square feet each. Each unit has 2 bedrooms, 1 bath, a full-sized laundry room, kitchen, living and dining area. These corner lot properties are conveniently located near schools and shopping, both units are tenant occupied. DO NOT ENTER or DISTURB, shown by appointment ONLY.' ,`Acres` = '0.3287' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Madisonville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0110 J S HUNTER TRACT 259 .332 ACRES 2 HOUSES' ,`LotDesciption` = 'Corner' ,`LotSize` = '14320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '175 - Madisonville Consolidated' ,`SchoolElementary` = 'MADISONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MADISONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '2616' ,`TaxRate` = '2.4226' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093177' WHERE `Matrix_Unique_ID` = '209339616' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T14:03:04.273' ,`MLSNumber` = '15974707' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026861' ,`Longitude` = '-95.845856' ,`PhotoCount` = '17' ,`PostalCode` = '77447' ,`RoomCount` = '10' ,`ListPrice` = '432023.00' ,`Status` = 'Active' ,`StreetName` = 'Kildeer Point' ,`StreetNumber` = '16015' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2122' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Create unforgettable moments with this charming property. This home features a stone elevation, 3 car garage, luxury vinyl plank flooring, extended covered patio and a versatile flex room. No Back neighbors! Create new recipes in the spacious island kitchen, fully equipped with Omegastone countertops, tile backsplash, double ovens, gas cooktop, stainless steel appliances and a large pantry. Relax in the tranquil primary suite, complete with a bay window, a walk-in closet, dual vanities, Large Spa Shower. Enjoy a variety of amenities including the neighborhood pool, large dog park, playground and a beautiful community lake with walking trail. Come visit us this weekend!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 46 Block 1 Section 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'I T HOLLEMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093177' WHERE `Matrix_Unique_ID` = '209358237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T14:03:29.123' ,`MLSNumber` = '35911557' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.026861' ,`Longitude` = '-95.845856' ,`PhotoCount` = '18' ,`PostalCode` = '77447' ,`RoomCount` = '13' ,`ListPrice` = '447000.00' ,`Status` = 'Active' ,`StreetName` = 'Will Park' ,`StreetNumber` = '16019' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous house has it all. Stone elevation, 3 and a half baths, luxury vinyl plank flooring, a 3-car garage, an extended covered patio, formal dining room and a spacious game room on a quiet cul-de-sac lot. Try a new recipe in the island kitchen complete with granite countertops, tile backsplash, 30” gas cooktop, double ovens and stainless steel appliances. Take a well-deserved break in the serene primary suite, fully equipped with a bay window, a walk-in closet, dual vanities, and a walk-in spa shower. Situated minutes from Highway 290, residents have easy access to the Grand Parkway and the rest of the Greater Houston area. Popular shopping, dining, and entertainment are also a short drive away. Community comforts include a community pool, recreation center, playground, dog park and a beautiful lake with a walking trail. Call or visit us soon!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 34 Block 1 Section 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'I T HOLLEMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093177' WHERE `Matrix_Unique_ID` = '209363836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T13:12:13.510' ,`MLSNumber` = '76468408' ,`ListAgentFullName` = 'Juanita Christie' ,`ListOfficeName` = 'Alford Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.006726' ,`Longitude` = '-96.001647' ,`PhotoCount` = '25' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Upper Colorado' ,`StreetNumber` = '139' ,`StreetSuffix` = 'Drive' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WATCH NATURE OUT YOUR FRONT DOOR WITH QUIET LIVING IN AN ADORABLE FAMILY HOME. ACROSS FROM THE BANKS OF THE COLORADO RIVER. 3/2/2 ATTACHED HOME HAS WOODBURNING FIREPLACE IN THE LIVING AREA WITH ACCESS TO A SCREENED IN PORCH, FORMAL ENTRY, COZY DINING AREA, LARGE MAIN BEDROOM WITH FRENCH DOORS ALSO TO THE SCREENED IN PORCH.TILE AND WOOD FLOORS, RECENTLY UPDATED DOUBLEPANE WINDOWS, RECENT WATER SOFTNER, FULLY FENCED YARD WITH STORAGE SHED. NO HISTORY OF HOUSE FLOODING! PRICED TO SELL' ,`Acres` = '0.2563' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RIVER OAKS S/D LOT 6 & S PART LOT 5 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11166' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'River Oak Sub' ,`TaxAmount` = '2804' ,`TaxRate` = '2.1477' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093177' WHERE `Matrix_Unique_ID` = '211745855' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T14:42:04.077' ,`MLSNumber` = '91118271' ,`ListAgentFullName` = 'Justin Phillips' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.430674' ,`Longitude` = '-95.411999' ,`PhotoCount` = '34' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Allegro' ,`StreetNumber` = '3731' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 2-story home is sure to impress with three oversized bedrooms, media room, and study. As you enter, you will be amazed by the soaring ceilings and sumptuous carpet flooring. The open-concept design will make entertaining guests a breeze from the kitchen to the family room. The gourmet kitchen is equipped with built-in stainless appliances with gas cooktop and an oversized island. At the end of the day, retreat to the spacious primary suite enhanced with bow window, separate shower adorned by ceramic tile, and stand-alone tub. Upstairs, you will discover a game room overlooking the family room, ideal for hosting game nights. This desirable rare floor plan is the last one of its kind. It\'s energy efficient and Environments for Living certified. Come visit this fabulous home today!' ,`Acres` = '0.1394' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 74 (A0513 HT&BRR) (IOWA COLONY) BLK 3 LOT 8' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '6072' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '11422' ,`TaxRate` = '3.6249' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093178' WHERE `Matrix_Unique_ID` = '211900324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T14:32:33.553' ,`MLSNumber` = '59657471' ,`ListAgentFullName` = 'Sonia Estrada' ,`ListOfficeName` = 'Lane Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042894' ,`Longitude` = '-95.432965' ,`PhotoCount` = '39' ,`PostalCode` = '77388' ,`RoomCount` = '11' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Branch' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2729' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 story home on corner cul-de-sac lot with 3/4 bedrooms, 2 baths, 2 car garage and a pool with hot tub. There are two separate living areas, one large family room with cathedral ceiling and wood beams with center fireplace with gas logs and the other living area off the kitchen with ceramic tile flooring and built in cabinets with bookshelves. Off the living room is a flex room that can be used as a study, game room or 4th bedroom. Good size backyard with pool and hot tub. New pool filters installed Sat. Oct 8, 2022.' ,`Acres` = '0.2118' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 104 BLK 4 017*E5332900-001-004-104 ENCHANTED OAKS SEC 1' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'LEMM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Call Occupant,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Spanish' ,`Subdivision` = 'Enchanted Oaks Sec 01' ,`TaxAmount` = '4959' ,`TaxRate` = '2.484' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093178' WHERE `Matrix_Unique_ID` = '212095340' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T13:27:13.403' ,`MLSNumber` = '17356273' ,`ListAgentFullName` = 'Antoinette Ruffino' ,`ListOfficeName` = 'Coldwell Banker Apex, REALTORS LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.392522' ,`Longitude` = '-95.722393' ,`PhotoCount` = '38' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Colby\'s Way' ,`StreetNumber` = '141' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2055' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why wait for new contstruction? This beautiful 4 bedroom, 3 bath home in the Hills of Town Creek is gently lived in and only 1 year old! This floor plan is ideal for hosting family and friends. After entering through the foyer, make your way into the open-concept kitchen and living room, a charming space with well placed windows that provide natural light throughout. The second bedroom suite with full bath provides a private space for your guests. You will love the storage space provided by the walk-in closets in every bedroom. The primary bedroom is a spacious retreat boasting of his and hers walk-in closets, a soaker tub, dual sinks, and a separate shower. Granite countertops throughout. Make your home just minutes from shopping, restaurants, Lake Conroe, and some of the best schools Montgomery County has to offer. Schedule your private tour TODAY!! SELLERS ARE HIGHLY MOTIVATED!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Stylecraft Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S582404 - The Hills of Town Creek 04, BLOCK 1, Lot 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Hills of Town Creek' ,`TaxAmount` = '' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093178' WHERE `Matrix_Unique_ID` = '212427024' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T13:59:29.240' ,`MLSNumber` = '94722354' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.601194' ,`Longitude` = '-95.443528' ,`PhotoCount` = '6' ,`PostalCode` = '77053' ,`RoomCount` = '8' ,`ListPrice` = '371346.00' ,`Status` = 'Active' ,`StreetName` = 'Bollardpoint' ,`StreetNumber` = '15338' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction - Liberty Home Builders-Sullivan Plan–2587 sqft–2 Story–4 bed, 2.5 Baths & Media Room, Game Room, 2 Car Garage w/ Covered Patio, Primary Bedroom with Bay Window, LVP Wood Flooring @ Family Room, Extended Entry, Kitchen/Breakfast/Powder Bath/Utility Room, Tile Floors @ Primary Bath (12” x 24”), Tile Floors Bathroom 2 (13” x 13”), 42” Kitchen Cabinets–Level 3 Madison Lien (White), Level 7 Omega Stone Counter Tops w/ 10” Depth Farmer Size Stainless Steal Sink & Upgrade Backsplash w/ Under Cabinet Lighting, (3) Pedant Lighting @ Kitchen Island, GE Stainless Steel Appliances, Level 6 Omega Stone Bath Counter Tops with Undermount Sinks in Bathrooms, Wrought Iron Spindles at Stairs, Walk-In Mud Set Shower w/ Rain Shower Fixtures in Primary Bath, Front/Back Full Sprinkler System w/ Fully Sodded Front/Back yard. Brick/Stone Elevation, 2” Designer White Blinds, Wi-Fi Garage Door Opener, 30 YR Roof Composite Shingle, High Density Level 3 Carpet & we use Tankless Water Heaters.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 2, Section 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '2.95' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093178' WHERE `Matrix_Unique_ID` = '212464815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T13:59:37.850' ,`MLSNumber` = '80940096' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.601194' ,`Longitude` = '-95.443528' ,`PhotoCount` = '7' ,`PostalCode` = '77053' ,`RoomCount` = '5' ,`ListPrice` = '337728.00' ,`Status` = 'Active' ,`StreetName` = 'Bollardpoint' ,`StreetNumber` = '15342' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1978' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction - Liberty Home Builders – Chelsea Plan – 1978 sq ft. – 2 Story – 3 bed, 2.5 Baths & Loft Game Room, 2 Car Garage w/ Covered Patio, LVP Wood Flooring Family room, Kitchen/Breakfast/Powder Bath/Utility room, Tile floors @ Primary Bath/ bath 2, Level 3 Madison Lien 42” cabinets w/ Level 5 Granite Counter Tops w/ Level 6 Tile backsplash w/ Stainless Steel 10” undermount Sink, Under cabinet lighting, (3) Drop Pedant lighting @ Kitchen Island, GE Stainless Steel Appliances, Level 6 Omega Stone Counter Tops in All Bathrooms, Wrought Spindles at Stairs, , Front/Back sprinkler system. Brick/Stone elevation, 2” Designer White Blinds, Wi-Fi Garage Door Opener, Spa Walk-In Mud Set Shower w/ Overhead Rain Shower Fixtures in Primary Bath, Front/Back Full Irrigation Sprinkler System w/ Fully Sodded Front/Back yard. 30 Year Roof Composite Shingle, High Density Level 4 Carpet. Must See TODAY!' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = 'Liberty Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5, Block 2, Section 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Anderson Lake' ,`TaxAmount` = '' ,`TaxRate` = '2.95' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093179' WHERE `Matrix_Unique_ID` = '212516887' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T13:56:41.800' ,`MLSNumber` = '97494870' ,`ListAgentFullName` = 'April Lendo' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.069234' ,`Longitude` = '-94.005049' ,`PhotoCount` = '14' ,`PostalCode` = '75931' ,`RoomCount` = '3' ,`ListPrice` = '219000.00' ,`Status` = 'Active' ,`StreetName` = 'Basil' ,`StreetNumber` = '121' ,`StreetSuffix` = 'Lane' ,`City` = 'Brookeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Darling weekend retreat in Rayburn Country! This 3 bedroom, 2 bath home is the only property located on the street! Plenty of space to spread out and store all your lake toys! Approximately 5 miles to the boat ramps on beautiful Lake Sam Rayburn and about 1 mile to the country club! Come be a part of this growing community!' ,`Acres` = '' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8,10-12 BLK 6 SEC 21 RC 1140/995 0.155 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '144 - Brookeland' ,`SchoolElementary` = 'BROOKELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROOKELAND HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKELAND HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rayburn Country Sub Sec 21' ,`TaxAmount` = '1831' ,`TaxRate` = '1.6721' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093179' WHERE `Matrix_Unique_ID` = '212691765' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T14:10:54.017' ,`MLSNumber` = '22605998' ,`ListAgentFullName` = 'Jon Skeele' ,`ListOfficeName` = 'Bayway Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.624548' ,`Longitude` = '-95.014315' ,`PhotoCount` = '7' ,`PostalCode` = '77571' ,`RoomCount` = '4' ,`ListPrice` = '354595.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Oaks' ,`StreetNumber` = '281' ,`StreetSuffix` = 'Street' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single family stilted home on a very large lot, BIG ENOUGH FOR A POOL!!. 3 bedrooms 2 full baths. Primary bedroom with bath and large walk in closet. La Porte on the border of Shoreacres are small Texas towns located just south of Houston, close to where the ship channel meets Galveston Bay. Rich in history and built on community, this small town is a nice escape from the big city. However, if you need to get to downtown Houston its just a 35 minute drive. Small town living with all the same amenities found in the big city, restaurants and shopping. What else could you ask for?! Model home is located at 341 Bay Oaks Dr' ,`Acres` = '0.3782' ,`Area` = '7' ,`BuilderName` = 'Bayway Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 BAY VILLAGE SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '16474' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Bay Village' ,`TaxAmount` = '563' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093179' WHERE `Matrix_Unique_ID` = '213514813' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T13:10:53.843' ,`MLSNumber` = '87873242' ,`ListAgentFullName` = 'Priscilla Duffy' ,`ListOfficeName` = 'Bay Haven Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.484156' ,`Longitude` = '-94.929765' ,`PhotoCount` = '27' ,`PostalCode` = '77539' ,`RoomCount` = '2' ,`ListPrice` = '139000.00' ,`Status` = 'Active' ,`StreetName` = '16th' ,`StreetNumber` = '915' ,`StreetSuffix` = 'Street' ,`City` = 'Dickinson' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this cute Bungalow nestled in a lust garden amongst mature tropical trees. The home has a nice front porch to relax on after work, or enjoy morning coffee. When entering the home, the den/kitchen combo has vaulted ceilings with exposed beams. There is a full bath in the hall with stand up shower and a half bath in the primary bedroom. The bathyard is a blank slate ready for landscaping or backyard furniture. The previous owner had an above ground pool. The home has never flooded. The community of San Leon has desirable restaurants and Beach Front Parks. Please call to schedule a showing.' ,`Acres` = '0.0769' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOT 12 BLK 163 SAN LEON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '1136' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093179' WHERE `Matrix_Unique_ID` = '213552027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T14:37:54.890' ,`MLSNumber` = '38028782' ,`ListAgentFullName` = 'Britany Freeman' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082478' ,`Longitude` = '-95.779060' ,`PhotoCount` = '10' ,`PostalCode` = '77447' ,`RoomCount` = '7' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Mount Bauer' ,`StreetNumber` = '20810' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2261' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOVELY Two-story home on a HUGE corner lot. This home has 4 bedrooms with the primary bedroom down. The executive en suite primary bath has jetted tub, double sinks, and large walk-in closet. The family room has newly added laminate wood flooring - so impressive when you enter the home. The kitchen granite countertops are in the same color scheme as the newly added backsplash. BEST for LAST - huge backyard is fully fenced with a huge, covered patio. Beautiful landscaping- plants/ flower beds accent all the sides of the yard. There are solar screens on the patio for watching TV on the patio. Flood free drainage system in front and back of the neighborhood. Great location with access to both Grand Pky 99 and Hwy 290. Close to movie theaters, restaurants and several shopping Centers. A small fishing pond is located at the front of community and this community provides a plethora of activities! Enjoy delicious food from any of the food trucks that stop by. Come view your new home today!' ,`Acres` = '0.2746' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 4 BAUER LANDING SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11961' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'EVELYN TURLINGTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bauer Lndg Sec 4' ,`TaxAmount` = '7048' ,`TaxRate` = '2.8556' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093179' WHERE `Matrix_Unique_ID` = '213563640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T14:16:13.497' ,`MLSNumber` = '32725929' ,`ListAgentFullName` = 'Roscoe Ford' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.311974' ,`Longitude` = '-96.085897' ,`PhotoCount` = '48' ,`PostalCode` = '77488' ,`RoomCount` = '16' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Hodges' ,`StreetNumber` = '1305' ,`StreetSuffix` = 'Lane' ,`City` = 'Wharton' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3155' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Amazing 3/4 bed, 4.5 bath custom home w/ private tennis court on just less than a 1/2 acre lot in the heart of beautiful Wharton, TX! This 2 story home on a corner lot is nestled between 2 huge live oak trees and adjacent to large hay fields offering a sense of privacy. The expansive living room w/ wood burning fireplace features a wall of windows overlooking the private backyard & tennis court. Kitchen w/ updated silestone counter tops, slate floors, white custom cabinets, double ovens and an abundance of storage. Huge laundry room w/ tons of cabinet storage, a sink and spot for a frig or freezer. Large master bedroom w/ built-ins for extra storage and a French door leading to a private covered patio. Two separate master bathrooms including an updated walk-in shower. Large gameroom upstairs along w/ both secondary ensuite bedrooms, each boasting a full bathroom. Recent 30 year 3D roof, Recent gutters. Recent tankless water heater. No HOA. Low taxes. DID NOT flood in Harvey.' ,`Acres` = '0.3948' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FRAZIER BLOCK 2 LOT 13A,14' ,`LotDesciption` = 'Corner' ,`LotSize` = '17197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Frazier' ,`TaxAmount` = '6790' ,`TaxRate` = '2.3512' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093180' WHERE `Matrix_Unique_ID` = '214024697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T14:17:37.797' ,`MLSNumber` = '67699491' ,`ListAgentFullName` = 'Collette King' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811285' ,`Longitude` = '-95.521907' ,`PhotoCount` = '50' ,`PostalCode` = '77080' ,`RoomCount` = '7' ,`ListPrice` = '789000.00' ,`Status` = 'Active' ,`StreetName` = 'Kerrwood' ,`StreetNumber` = '9425' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RARE!!!! Unrestricted property in the heart of Spring Branch. Perfect for your business or to build multi-living units! Home is habitable with 4 bedrooms, 2 baths and an oversized kitchen and laundry room! Enjoy the screened in porch as well! The lot is very private and treed. Easy to convert to a business as there are currently other businesses on the street. Or enjoy as quaint and secluded living. Easy to show. Commercial or residential. Possibilities are endless.' ,`Acres` = '0.8127' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 141 NEUEN MANOR' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '35400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUFFALO CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Neuen Manor' ,`TaxAmount` = '10554' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093180' WHERE `Matrix_Unique_ID` = '214612307' --> 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','215202266','1675093180','215202266','2022-12-19T14:50:38.283','68425655','Kieu Doan','Realty Associates','','','29.968081','-95.467276','19','77014','11','300000.00','Active','MARDI GRAS DR','12222','','Houston','2','1','4','2950','Single-Family','BEAUTIFUL 2 STORY HOUSE IN THE CONNER LOT. HIGH CEILING WITH OPEN LIVING ROOM. MASTER BEDROOM IS IN THE FIRST FLOOR WITH JETTED TUB AND SEPARATE SHOWER. THIS HOME IS CONVENIENT TO BELTWAY 8,I45,FM 1960. PLEASE COME AND SEE!!!','','13','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','1960/Cypress Creek South','Central Electric','1','LT 60 BLK 3 SILVERGLENH WEST SEC 1','Corner','7286','Appraisal District','','396','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','48 - Spring','DELORAS E THOMPSON ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','STELLE CLAUGHTON MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Silveglen West','','','Public Sewer,Public Water','2003','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','215402046','1675093180','215402046','2022-12-19T13:38:53.043','54013198','David Montalvo','Homelister, Inc','','','29.282927','-94.828669','21','77551','6','298800.00','Active','Fraser','5703','Avenue','Galveston','2','0','3','1727','Single-Family','Total remodel, 446 sq ft. of living space added, Complete new plumbing, completely new electric, new A/C and Heating system 3 independent units, 4 feet wide stairs, vinyl wood flooring down and carpet upstairs, custom deluxe designer bathrooms, open showers with seating bench, granite vanity tops. Huge living and dining room open to a brand new custom kitchen with granite countertops, beautiful Spaniard mosaic backsplash and almost new appliances. All windows and exterior doors have double pane impact resistant glass with UV light filter. House is Windstorm Certified. Living/dining area 24’ x 20’ Kitchen 10’ x 15’+ Pantry Bed 1: 12’ x 13’ + 4\" x 9\" closet Bed 2: 11’ x 12\" opens to a 4” by 19” Balcony Master: 16’ x 14’+ 8” by 8” closet, room also opens French door to a 10” by 10” roof deck.','0.1377','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Midtown - Galveston','Central Electric','0','ABST 628 PAGE 92 LOT 24 SHORE VIEW SEC 2','Subdivision Lot','6000','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop,Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Request Online Appointment','Builder','2','Traditional','Shoreview','3717','2.0161','Public Sewer,Public Water','2020','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','215540189','1675093180','215540189','2022-12-19T13:25:06.970','34124304','Daisy Lopez','Move Up America','','','30.101153','-95.621322','16','77375','5','409390.00','Active','Hickory Grove','1923','Lane','Tomball','3','0','4','2410','Single-Family','The Darby | 2,410Sq. Ft. | Single Story | 4 Bedrooms | 3 Bath | Covered Patio | 3 Car Garage','','14','Chesmar Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','0','Tomball','Central Electric','1','Lot:9 Block:1 Section:1','Subdivision Lot','6250','Other','','600','1','To Be Built/Under Construction','3','','0','','','Gas Range','','Composition','53 - Tomball','TOMBALL ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Leave Business Card','Builder','1','Traditional','Wood Leaf Reserve','','2.37','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','215735096','1675093180','215735096','2022-12-19T14:23:33.747','77185716','Ashlee Johnston','Realty ONE Group, Experience','','','30.348569','-95.606318','6','77316','3','199900.00','Active','St Lawrence River','1307','Road','Montgomery','2','0','3','1000','Single-Family','','0.0898','39','Starter Homes of TX','','Electric Dryer Connections','','No Disclosures','1','','','Lake Conroe Area','Central Electric','1','S658002 - LAKE CONROE FOREST 02, BLOCK 48, LOT 44','Subdivision Lot','3912','Appraisal District','','125','1','To Be Built/Under Construction','0','Electric Oven','0','','','Freestanding Range','','Composition','37 - Montgomery','KEENAN ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Builder','1','Traditional','Lake Conroe Forest 02','244','2.1625','Public Water,Septic Tank','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','215735374','1675093180','215735374','2022-12-19T14:32:07.550','85248758','Ashlee Johnston','Realty ONE Group, Experience','','','30.447930','-95.637095','7','77356','3','224900.00','Active','Valley','13946','Drive','Montgomery','2','0','3','1409','Single-Family','10\' ceilings in kitchen/Living, beautiful open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Great lighting and all LED! Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.','0.1274','39','Starter Homes of TX','','Electric Dryer Connections','','No Disclosures','1','','','Lake Conroe Area','Central Electric','0','S660000 - LAKE CONROE TERRACE, BLOCK 1, LOT 50','Subdivision Lot','5550','Appraisal District','','','1','To Be Built/Under Construction','0','Electric Oven','0','','','Freestanding Range','','Composition','37 - Montgomery','LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card','Builder','1','Traditional','Lake Conroe Terrace','42','1.8242','Septic Tank,Well','2022','Builder'); --> New record created successfully