Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T22:20:39.143' ,`MLSNumber` = '91191720' ,`ListAgentFullName` = 'Beatriz Olmedillo' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.144832' ,`Longitude` = '-95.665845' ,`PhotoCount` = '29' ,`PostalCode` = '77486' ,`RoomCount` = '4' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 691' ,`StreetNumber` = '708' ,`StreetSuffix` = '' ,`City` = 'West Columbia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is fully renovated, new roof, redone and updated water well and septic. 4 bedrooms and 3 full bathrooms an open kitchen space with plenty of natural light. It has a bonus room that can be used as separate guest room that has its private entry. Don\'t wait and come see the endless possibilities to become this your dream home.' ,`Acres` = '1' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BROWN BROS (A0040 J H BELL DIV 9) LOT 16F ACRES 1.00' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Brown Bros' ,`TaxAmount` = '2745' ,`TaxRate` = '1.6787' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669642564' WHERE `Matrix_Unique_ID` = '207495952' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T21:23:50.593' ,`MLSNumber` = '63251031' ,`ListAgentFullName` = 'Timothy Torlincasi' ,`ListOfficeName` = 'The Right Choice Realty' ,`SellingAgentFullName` = 'Janet Dziedzic' ,`SellingOfficeName` = 'RE/MAX Legends' ,`Latitude` = '29.576490' ,`Longitude` = '-95.544375' ,`PhotoCount` = '44' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '450000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bonney Briar' ,`StreetNumber` = '3111' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RELAX and SIP COCKTAILS on your wraparound covered patio overlooking your POOL and the centrally located Fort Bend GOLF COURSE. The GOURMET kitchen is open to the oversized family room & is the centerpiece of the home for gathering around the massive custom island w/ upgraded granite & breakfast bar. Enhance your cooking w/ CHEF’s DREAM 7-burner gourmet range, generous counter space & ample storage space w/custom cabinets that include pot/pan drawers, hidden spice drawer & slide out shelves. There is a space for everything in this kitchen including a coffee bar & custom walk-in pantry. The same style continues into the roomy laundry room that has custom tile & cabinetry throughout. The backyard is an oasis & has a wrap-around covered patio overlooking the tranquil pool & and the 15th hole. The Owners Retreat has an oversized shower, spacious closets & a view of the backyard oasis. There are more unique features of this home. Call us today to view!' ,`Acres` = '0.2507' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL VALLEY LA QUINTA , BLOCK 26, LOT 34' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '10919' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'QUAIL VALLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Valley La Quinta' ,`TaxAmount` = '7683' ,`TaxRate` = '2.34' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642564' WHERE `Matrix_Unique_ID` = '210280420' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T22:48:55.173' ,`MLSNumber` = '47962540' ,`ListAgentFullName` = 'Chris Carpentier' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.704485' ,`Longitude` = '-95.089987' ,`PhotoCount` = '40' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Nugent' ,`StreetNumber` = '280' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful open waterfront lots. These lots are absolutely beautiful with lots of shade and amazing trees that help create privacy. The home has been lovingly maintained and offers 3 bedrooms and 2 full baths, lots of cabinets and storage space and amazing views. Large front porch and great back porch with built in benches for lots of seating. The owner recently added an 85k $ boat house that is beautiful and provides for remote boat lift and 2 jet ski lift that is also remote, large seating area and swim platform for enjoyment and to help get in boat much easier. You will enjoy sunrise and sunset views from your pier. Schedule your tour today and start making memories soon!' ,`Acres` = '0.72' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'NUGENT\'S COVE SECTION 1 BLK 13 LOT 13 & 14 MH 56 X 28 NO TAG' ,`LotDesciption` = 'Subdivision Lot,Waterfront,Wooded' ,`LotSize` = '31240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Nugents Cove Sec 1' ,`TaxAmount` = '2495' ,`TaxRate` = '1.9558' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642565' WHERE `Matrix_Unique_ID` = '212145678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T21:39:36.893' ,`MLSNumber` = '41264623' ,`ListAgentFullName` = 'Sandra Anaya' ,`ListOfficeName` = 'Real Estate by Design' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804360' ,`Longitude` = '-95.144867' ,`PhotoCount` = '32' ,`PostalCode` = '77530' ,`RoomCount` = '2' ,`ListPrice` = '184999.00' ,`Status` = 'Active' ,`StreetName` = 'Great Dover' ,`StreetNumber` = '1523' ,`StreetSuffix` = 'Circle' ,`City` = 'Channelview' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '947' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 bedroom home in the establish neighborhood of Sterling Green South . Home boast tile throughout, neutral fresh paint palette in interior and exterior of home.High ceiling in living room perfect for gatherings.Kitchen includes stainless steel appliances and has window to allow natural light. Remodeled bathroom with granite countertops and ceramic tile in bathtub to create a modern/ contemporary look.Home has a functional floor plan with ceilings fans throughout. Property includes efficient windows, 2 covered patios, large backyard with storage shed. per seller never flooded. New roof and A/C unit. LOW TAX RATE. This is truly a hidden gem. Close to I10 and Beltway.' ,`Acres` = '0.1806' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 37A & 38 BLK 2 W PT OF LT 37 & NE PT OF LT 38 STERLING G' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7869' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '270' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'Brown Elementary School (Channelview)' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Green 08' ,`TaxAmount` = '2903' ,`TaxRate` = '2.518' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669642565' WHERE `Matrix_Unique_ID` = '212147189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T21:32:01.620' ,`MLSNumber` = '97613046' ,`ListAgentFullName` = 'Becki McAuley' ,`ListOfficeName` = 'Greystone Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827909' ,`Longitude` = '-95.467488' ,`PhotoCount` = '39' ,`PostalCode` = '77092' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Chantilly' ,`StreetNumber` = '5119' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 5119 Chantilly! Fully remodeled last year and beautiful. New floors throughout home, new kitchen cabinets and counters, new bathroom cabinets and counters, new doors, new interior and exterior paint. New light fixtures and ceiling fans throughout the home. Home features a large office/study space with French doors. This extra room could also be used as a dining room. Remodeling allowed for a new master bedroom with ensuite bath. Living room is open to the dining and kitchen. All secondary bedrooms are found upstairs. Home also features a built-in desk/homework area. 2 Workshops in backyard. Remodeled \"she\" shed or is it a \"he\" shed? You decide.' ,`Acres` = '0.2939' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 4 MANGUM MANOR SEC 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '12804' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WAINWRIGHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mangum Manor Sec 03' ,`TaxAmount` = '5154' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642565' WHERE `Matrix_Unique_ID` = '212665226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T21:01:21.717' ,`MLSNumber` = '45528882' ,`ListAgentFullName` = 'Anthonio Sardinea' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.514993' ,`Longitude` = '-95.439557' ,`PhotoCount` = '21' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Birchwood Bluff' ,`StreetNumber` = '4948' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1991' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to This beautiful, one-story, fully open concept 3-bedroom, 2 bathroom Home! This Home features, a large kitchen island, plenty of cabinet & pantry storage, elevated ceilings and neutral tones complemented by an abundance of natural light. The home lends beautifully to entertaining family and friends with a spacious backyard with covered patio and large kitchen which is open to the spacious family and dining room. The en-suite Owner\'s Retreat boasts a large walk-in closet, double sinks and a stunning walk in Shower. The Home sits just steps away from beautiful lakes and area walking trails.' ,`Acres` = '0.1738' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STEWART HEIGHTS SEC 11 (A0403 & A0625) BLK 1 LOT 3' ,`LotDesciption` = 'Other' ,`LotSize` = '7571' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stewart Hts/Savannah Sec 11' ,`TaxAmount` = '9117' ,`TaxRate` = '3.3694' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642565' WHERE `Matrix_Unique_ID` = '212987227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T21:02:15.177' ,`MLSNumber` = '36297031' ,`ListAgentFullName` = 'Lauren Silva' ,`ListOfficeName` = 'RE/MAX Adventure' ,`SellingAgentFullName` = 'Liberty Kent' ,`SellingOfficeName` = 'RE/MAX Adventure' ,`Latitude` = '29.416188' ,`Longitude` = '-95.249184' ,`PhotoCount` = '20' ,`PostalCode` = '77511' ,`RoomCount` = '7' ,`ListPrice` = '220000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Foley' ,`StreetNumber` = '704' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1527' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has all the charm! Welcome to 704 W Foley in Alvin. It is walking distance to the High School, Parks, and is on a sprawling 1/4 acre. Along with the charming original wood floors, it also has updated bathrooms and kitchen! Come see the home today and move in before all of the holidays!' ,`Acres` = '0.25' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0449 H T & B R R BLOCK F TRACT 1E3 ACRES .25 (ALVIN)' ,`LotDesciption` = 'Corner' ,`LotSize` = '10890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'ALVIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '5817' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642565' WHERE `Matrix_Unique_ID` = '213120002' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T22:04:04.813' ,`MLSNumber` = '57924290' ,`ListAgentFullName` = 'Edgardo Martinez' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.060846' ,`Longitude` = '-95.363882' ,`PhotoCount` = '44' ,`PostalCode` = '77373' ,`RoomCount` = '9' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Hurst' ,`StreetNumber` = '5023' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your search ends here! Beautiful 2 story house in Spring! Formal dining room has chair railing & upgraded light fixture. Open floor plan, includes formal dining room, Media Room, HUGE Game room, and Study. Kitchen has 42” cabinets, SS appliances, breakfast bar. Great family room with gas log fireplace. Large master bedroom down w/walk-in closet, dual sinks, garden tub & separate shower. 5th bedroom optional as study. Secondary bedrooms have large closets & large second full bath. Double Pane windows & Tech Shield. Conveniently located near Hardy Toll Rd, Grand Parkway, I-45, I-59, and George Bush international Airport.' ,`Acres` = '0.1205' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 4 FOREST POINT AT CYPRESSWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Forest Point/Cypresswood' ,`TaxAmount` = '6870' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642566' WHERE `Matrix_Unique_ID` = '213187770' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T21:34:54.310' ,`MLSNumber` = '85742843' ,`ListAgentFullName` = 'Colby Hearn' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.129642' ,`Longitude` = '-95.406633' ,`PhotoCount` = '30' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Glenboro' ,`StreetNumber` = '30323' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2330' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRIME LOCATION in sought after, original, Imperial Oaks! This well-loved, beautiful brick 2-story, 4 bedroom, 2.5 bath home is in a wonderful spot on a quiet back road. Primary suite downstairs, cozy formal dining room, and breakfast room with large windows look out to green, tree-shaded backyard. Spacious game room upstairs, with secondary bedrooms and bathroom. Conveniently located/walking distance to restaurants, grocery stores, and amenities! Equally close to 99 and I-45. Top-rated Conroe ISD schools. Low Tax rate! Come make this beautiful place your home! Recent drywall repair and paint in kitchen, master, master bath, dining room.' ,`Acres` = '0.2073' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS 01, BLOCK 6, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9030' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks' ,`TaxAmount` = '5665' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642566' WHERE `Matrix_Unique_ID` = '213295008' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T21:11:52.627' ,`MLSNumber` = '86206651' ,`ListAgentFullName` = 'Stacey Mai-Gardner' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.919556' ,`Longitude` = '-95.684939' ,`PhotoCount` = '50' ,`PostalCode` = '77095' ,`RoomCount` = '10' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Driftwood Prairie' ,`StreetNumber` = '17535' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home on a cul-de-sac in the master-planned gated community of Stone Gate. Great location with easy access to 290, Beltway 8, 99, nearby parks, National Golf Course, walking trails, large dog park, and minutes from the Towne Lake Boardwalk for entertainment/shopping and restaurants. Enjoy Towne Lake center without paying the higher tax rate, Zoned to the excellent Cy-Fair school district. As you enter the house, the rotunda gives an elegant vibe; some features include fresh paint, crown molding, formal living/dining, granite\r\ncountertops, tile backsplash, oversized kitchen island, SS appliance, ensuite bedroom, primary bathroom/double sinks, separate shower, soaking tub, high ceilings, new carpet in the master bedroom, the tandem was converted into a bonus room, extended covered patio, huge 15,005 sqft backyard with new fence, outdoor bar area, two decks area, storage shed and sprinkler system. Amenities include a clubhouse, pools & splash pad, and tennis court, and many more!' ,`Acres` = '0.3445' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 CANYON LAKES AT STONEGATE SEC 7' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '15005' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ARAGON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Lk/Stonegate Sec 07' ,`TaxAmount` = '8892' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642566' WHERE `Matrix_Unique_ID` = '213520713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T21:21:54.783' ,`MLSNumber` = '63904358' ,`ListAgentFullName` = 'Hope Livingston' ,`ListOfficeName` = 'Oak Story Realty, LLC.' ,`SellingAgentFullName` = 'Sardar Anamul' ,`SellingOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`Latitude` = '29.640908' ,`Longitude` = '-95.722681' ,`PhotoCount` = '39' ,`PostalCode` = '77406' ,`RoomCount` = '10' ,`ListPrice` = '490000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cool Corner' ,`StreetNumber` = '1006' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3045' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and bright home located in the center of Richmond\'s desirable Harvest Green agri-hood! Large cul-de-sac lot with massive curb appeal and relaxing front porch. Grand 2 story entryway with 8\' doors on first floor. Energy efficient home with 4 bedrooms, 3.5 bathrooms, dining room and enclosed study downstairs, and game room upstairs. The beautiful white kitchen is upgraded with high-end appliances, Silestone counters, spacious island, & walk-in pantry. Added door and patio outside of laundry room/kitchen for outdoor cooking. Large living room boasts 19\' ceiling with cast stone fireplace. Expanded garage built 5\' wider for extra storage. Wrap-around back patio w/gas, power, and ethernet. House is CAT6 pre-wired. Harvest Green offers a community farm, beautiful parks and trails, other unique amenities, three Fort Bend ISD schools (elementary, middle, and high school), & two daycares. Home is conveniently located within walking distance to the Farmhouse/resort-style pool & gym.' ,`Acres` = '0.2058' ,`Area` = '37' ,`BuilderName` = 'Newmark' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HARVEST GREEN SEC 3, BLOCK 1, LOT 24' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8963' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'NEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Green' ,`TaxAmount` = '10357' ,`TaxRate` = '3.1129' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642566' WHERE `Matrix_Unique_ID` = '213832342' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T21:56:42.877' ,`MLSNumber` = '31699772' ,`ListAgentFullName` = 'Beverly Roddy' ,`ListOfficeName` = 'Pacesetter Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.590785' ,`Longitude` = '-95.114519' ,`PhotoCount` = '30' ,`PostalCode` = '77059' ,`RoomCount` = '4' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Heatherdale' ,`StreetNumber` = '15906' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 4BD/3.5BA, KUSTOM KASTLE FAMILY HOME LOCATED IN BROOK FOREST! *CHEF\'S KITCHEN HAS LOADS OF GRANITE COUNTER & CABINET SPACE**STAINLESS STEEL REFRIGERATOR***THE GENEROUS (UPSTAIRS)MASTER BEDROOM WITH MASTER BATH OFFERS LARGE SHOWER & DUEL CLOSETS*SPACIOUS LIVING ROOM***DOWNSTAIRS GUEST SUITE COULD BE USED AS 2ND MASTER BEDROOM/BATH* LOTS OF STORAGE SPACE & BUILT-INS THROUGHOUT*VINYL SIDING*STORM WINDOWS*UTILITY ROOM**2 SECURITY CAMERAS*RELAX & WATCH TV IN YOUR OWN PRIVATE BACKYARD, UNDER THE EXTENDED COVERED PATIO*PLENTY OF ROOM FOR LOVELY SWIMMING POOL*GARDEN AREA THAT HAS BEEN TASTEFULLY DESIGNED***2 CAR GARAGE WITH ADDITIONAL AIR-CONDITION MULTIPURPOSE ROOM OR BUYER COULD EASILY CONVERT BACK TO 3RD CAR GARAGE!**WALKING DISTANCE TO ARMAND BAYOU ELEMENTARY SCHOOL & CLEAR LAKE HIGH SCHOOL**QUICK ACCESS TO I-45 AND 146. NEARBY SHOPPING,DINING AT BAY BROOK MALL***\r\nRECENT MUD ROOM-CLOSET/PAINT/LIGHTING/SECURITY CAMERAS****WAITING FOR YOUR FINAL TOUCHES' ,`Acres` = '0.2448' ,`Area` = '7' ,`BuilderName` = 'KUSTOM KASTLE' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 65 BROOK FOREST SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10662' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '478' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ARMAND BAYOU ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brook Forest Sec 03' ,`TaxAmount` = '7731' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642567' WHERE `Matrix_Unique_ID` = '213832929' --> 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','214148597','1669642567','214148597','2022-11-25T22:08:21.237','65026347','Liz Hunter','eXp Realty, LLC','','','29.446650','-95.093399','37','77539','9','309000.00','Active','Colony Creek','319','Drive','Dickinson','2','1','3','1910','Single-Family','This 3 bedroom 2 bath single story home located in Centerfield Lakes in Bay Colony Community features a nice size kitchen area with plenty of cabinet space, granite countertops, a nice size window seat and chef\'s desk for all to enjoy. You’ll love the split floor-plan with the secondary rooms tucked away opposite from the primary room. The primary suite features two walk in closets, tray ceilings and a luxurious bathroom with separate vanities to allow you some personal space. This home is located towards the end of a quiet cul-de-sac. The Bay Colony community offers two pools to choose from plus a playground area and tennis courts to entertain the whole family.','0.1712','33','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','League City','Central Gas','1','CENTERFIELD LAKES IN BAY COLONY SEC 2 (2000), ABST 19, BLOCK','Subdivision Lot','7456','Appraisal District','','560','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','17 - Dickinson','CALDER ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Centerfield Lakes Bay Colony','6444','2.7847','Public Sewer,Public Water','1999','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T22:30:50.160' ,`MLSNumber` = '87158454' ,`ListAgentFullName` = 'Aina Bayas' ,`ListOfficeName` = 'First Millennium Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.207683' ,`Longitude` = '-95.552374' ,`PhotoCount` = '37' ,`PostalCode` = '77382' ,`RoomCount` = '10' ,`ListPrice` = '925000.00' ,`Status` = 'Active' ,`StreetName` = 'Glentrace' ,`StreetNumber` = '59' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3675' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificient Renovated custom home in Alden Bridge. Dramatic 2 story ceiling entryway opens into spacious living room adjoins the kitchen. Wall of windows from the spacious living room and master suite overlooking the sparkling pool and spa. Study with Wall of built in and French door for privacy. Freshly painted walls and neutral colors tile throughout the first floor. Home with Modern Designs & Colors! Gorgeous kitchen with Granite countertops, stainless steel appliances with double ovens, Master bathroom has had a complete makeover, now featuring a freestanding bathtub and shower. Master suite down and 3 bedrooms and a game room upstairs. The Backyard Oasis w/ pool /spa is an entertainers dream! 3 car garages freshly painted , Tesla charging station is installed. Zoned to Top Ranked Conroe ISD Schools.' ,`Acres` = '0.2766' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 56, BLOCK 2, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12049' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 56' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642567' WHERE `Matrix_Unique_ID` = '214308027' --> 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','214661247','1669642567','214661247','2022-11-25T22:38:12.003','23726449','Joanie Caskey','Caskey Realty','','','29.573543','-95.563269','42','77459','7','250000.00','Active','Palm Grove','3634','Drive','Missouri City','2','1','4','2051','Single-Family','Located in sought after Quail Valley. 4 bedroom, 2 1/2 bath, 2 car garage. Granite countertops, new HVAC system. primary bedroom down with en suite bath with double sinks and tub/shower, formal dining with open concept kitchen/living along with a breakfast bar for additional seating and entertaining, lots of cabinetry and closets for extra storage space, gas fireplace in living area, additional play or sitting area upstairs. Breakfast room overlooks backyard and can also be used as a sunroom. Backyard has lots of space for your outdoor living space along with a kids play areas. Priced to sell! Convenient to Highway 6, Highway 59/69, restaurants, shopping and schools.','','38','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Reports Available,Sellers Disclosure','1','Gas Connections','1','Missouri City Area','Central Gas','1','QUAIL VALLEY THUNDERBIRD WEST COURTYARD HOMES, BLOCK 2, LOT','Patio Lot,Subdivision Lot','5000','Appraisal District','','500','0','','2','Electric Oven','0','','','Electric Range','','Composition','19 - Fort Bend','QUAIL VALLEY ELEMENTARY SCHOOL','ELKINS HIGH SCHOOL','QUAIL VALLEY MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Quail Valley Thunderbird West','','','Public Sewer,Public Water','1980','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T21:11:23.033' ,`MLSNumber` = '67121979' ,`ListAgentFullName` = 'Connie Nguyen' ,`ListOfficeName` = 'Houston Met Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.845941' ,`Longitude` = '-95.703627' ,`PhotoCount` = '18' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Broadwind' ,`StreetNumber` = '19114' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1764' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story 3/2/2 single family home with a great floor-plan and a huge back yard. Long extended driveway gives ample spaces for guest parking. This gorgeous home has a spacious floor plan with lots of natural light. All bedrooms located upstairs with and additional lounge or playroom area. Primary bedroom has double sin with shower and tub. Great opportunity to own this gem! This will not last!' ,`Acres` = '0.1136' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Real Estate Owned' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 1 WINDSTONE COLONY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'SHERIDAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Windstone Colony Sec 1' ,`TaxAmount` = '5152' ,`TaxRate` = '2.781' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642567' WHERE `Matrix_Unique_ID` = '214669365' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-25T22:09:24.230' ,`MLSNumber` = '17072956' ,`ListAgentFullName` = 'Pamela Roth' ,`ListOfficeName` = 'Roth & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906704' ,`Longitude` = '-95.721324' ,`PhotoCount` = '47' ,`PostalCode` = '77433' ,`RoomCount` = '11' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekdale Bend' ,`StreetNumber` = '20359' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2472' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 3 bedroom 2 1/2 bath home nestled inside the highly sought after Miramesa community in Canyon Lakes West. The kitchen features granite countertops, stainless steel appliances, dining/breakfast area, and a huge island for those large gatherings. The spacious living room has a bay of windows to the backyard which has no backyard neighbors! The first floor primary bedroom is generous in size. The primary en suite has a relaxing soaking tub and separate shower. It also has dual sinks and a fantastic size primary closet. Upstairs you will find 2 more spacious bedrooms with large walk in closets. The ginormous game room is sure to be an entertainment hot spot or a quite place to read and study. The home is compatible with Amazon Alexa voice control. The home is zoned to top rated Cypress-Fairbanks schools. The community boasts pools, splashpads, walking trails, and a club house. With quick access to major highways, shopping, entertainment, and dining - it is a must see!' ,`Acres` = '0.1291' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 MIRAMESA SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POSTMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Miramesa at Canyon Lakes West' ,`TaxAmount` = '8477' ,`TaxRate` = '3.041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642567' WHERE `Matrix_Unique_ID` = '214789437' --> 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','215029595','1669642568','215029595','2022-11-25T21:15:42.703','70696821','Connie Nguyen','Houston Met Group','','','29.703048','-95.691269','16','77407','6','289900.00','Active','Canton','17426','Forest','Richmond','2','0','3','1865','Single-Family','2 Story 3/2/2 single family home with a great floor-plan and a huge back yard. Long extended driveway gives ample spaces for guest parking. This gorgeous home has a spacious floor plan with lots of natural light. Primary bedroom has double sin with shower and tub. Great opportunity to own this gem! Will not last!','0.1805','37','','','','','No Disclosures','','','1','Mission Bend Area','Central Gas','1','WEST OAKS VILLAGE SEC 4, BLOCK 3, LOT 20','Subdivision Lot','7863','Appraisal District','','650','0','','2','','0','','','','','Composition','19 - Fort Bend','JORDAN ELEMENTARY SCHOOL (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Lockbox Front','Appraisal District','1','Traditional','West Oaks Village Sec 4','5556','2.4887','Public Sewer,Public Water','1998','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215090753','1669642568','215090753','2022-11-25T22:46:04.763','52940647','Chris Carpentier','JLA Realty','','','30.710124','-95.097768','38','77351','3','299000.00','Active','Muscovy','398','Trail','Livingston','3','0','3','2104','Single-Family','Welcome to this lovely updated gem! Home contains 2 full bedrooms and 2 full bathrooms with 3rd bedroom and bathroom in efficiency apartment attached to garage. New roof, AC, kitchens , baths, floors and windows make this home ready for immediate move in. The kitchen is open to living area w/ fireplace that has electric insert added. There is a large area that was once a porch enclosed that contains the laundry space and could be great game room or even an additional bedroom if needed. Large fenced in side yard and large front yard for plenty of space for pets and outdoor activities. This garage is very large and has room for multiple cars, RV or Boat and has a huge space above 2 car area (accessed by drop down steps ) that adds lots of room for storage. The efficiency apartment is not included in sq footage. Lot next door can be purchased separately. Schedule your showing today.','0.5','44','','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','Freestanding','1','Lake Livingston Area','Central Electric','1','NUGENT\'S COVE SECTION 2 BLK 6 LOT 53 THRU 56','Cleared,Water View','22150','Appraisal District','','160','0','','3','Electric Oven','0','','','Electric Cooktop','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Ranch','Nugents Cove Sec 2','3040','1.8745','Public Water,Septic Tank','1971','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','215093421','1669642568','215093421','2022-11-25T21:47:37.487','13426356','Kristen Matthies','JLA Realty','','','30.251079','-94.738567','36','77575','9','549750.00','Active','Highway 105','199','','Liberty','2','1','4','2617','Single-Family','You do not want to miss this once in a lifetime chance to own 31 acres majority cleared with your private pond. LOTS of upgrades throughout including, soft close cabinets, countertops, flooring throughout, oversized chiefs\' panty with 2 custom barn doors. Mother-in-Law detached living quarters with kitchenette and half bath. The detached living quarter use is limitless! Perfect for a Craft room, Photography Studio, Small business studio, or even storage for agriculture feed and supplies! He/She Shed with AC and electric, Chicken coop, and detached garage with carport Perfectly accompanying your future 31 ACRES. NO HARVEY FLOODING. Upgrades include New AC HVAC and duct work, New Septic to main house, land cleared and for your farm and ranch dreams! Easy access to Cleveland, Beaumont, and Liberty! \r\n\r\nMOTIVATED SELLERS due to job relocation!!!\r\n\r\nProperty does come with a Wild Life exemption that is transferable!','31.499','52','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure,Special Addendum','1','','','Liberty County East','Central Electric','0','000110 S STRONG, TRACT 11 12 37 74 77 84, ACRES 31.499','Cleared,Other,Water View,Wooded','1372096','Survey','','','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','107 - Hardin','HARDIN ELEMENTARY SCHOOL','HARDIN HIGH SCHOOL','','Accompany','Appraisal District','1','Contemporary/Modern','S Strong','4151','1.8773','Other Water/Sewer,Septic Tank','1969','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','215094244','1669642568','215094244','2022-11-25T22:57:58.723','90554052','Dorothy Wanko','TEXdot Real Estate Services,Inc.','','','30.142660','-95.444447','41','77386','12','525000.00','Active','Basswood','202','Drive','Spring','3','0','3','2818','Single-Family','Lowest tax rate around 2.00! No HOA! Like new construction (all renovations 2022, never lived in since renovated) semi custom single story ranch home (2,518 sqft). Home is situated on a corner lot 16,000+ sqft. There are too many updates and upgrades to list, plesae contact us or your Realtor for details. 3 Bedroom 2 bath home, plus study, all bedrooms have walk in closets. One of the secondary bedrooms has two walk in closets! 2 car garage with a double wide driveway, plus an additional oversized driveway (with a double gate entry into backyard) Park anything you want. Private inground pool recently resurfaced. Plus a Pool House (300 sqft in addition to home) complete with a kitchenette (gas range included) and full bath (bath 3). Beautiful covered front and back porches. Close to The Woodlands easy access to Hwy 45, 99 and Hardy Toll. Lots of restaurants, entertainment, and shopping. Multi-Generational “GenX” Low taxes~ Broker/Owner/Agent','0.3687','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Spring Northeast','Central Gas','0','OAK RIDGE NORTH 03, LOT 303','Corner,Subdivision Lot','16059','Appraisal District','','','0','','2','Gas Oven','1','Gunite,In Ground','','Gas Range','','Composition','11 - Conroe','OAK RIDGE ELEMENTARY SCHOOL (CONROE)','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Seller','1','Ranch','Oak Ridge North 03','4616','2.0087','Public Sewer,Public Water','1970','Appraisal'); --> New record created successfully