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-10-07T06:34:21.423' ,`MLSNumber` = '64409483' ,`ListAgentFullName` = 'Laura Guillory' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765393' ,`Longitude` = '-95.545653' ,`PhotoCount` = '38' ,`PostalCode` = '77024' ,`RoomCount` = '9' ,`ListPrice` = '864900.00' ,`Status` = 'Active' ,`StreetName` = 'Tealwood North' ,`StreetNumber` = '12322' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic value! This well-maintained, spacious 5 bedroom patio home with en-suite baths is located in a private cul-de-sac enclave walking distance to highly regarded Frostwood Elementary and popular Memorial Green shopping/dining. Each bedroom (four up, one down) is very large and contains plentiful walk-in closets. The downstairs rooms with 9\' ceilings are generously sized as well, affording plentiful space for entertaining. AC units replaced 2019. Water heater replaced in 2022. Pella double-paned windows throughout and whole house power save module. 3-car garage. Enjoy a lock-and-leave lifestyle with only a front yard and patio to maintain, located minutes from Memorial City Mall and hospital, City Centre, Memorial Forest Community Club and more. Join this unique, quiet 17 home community in the heart of Memorial. All info per Seller.' ,`Acres` = '0.1626' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 TEALWOOD NORTH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7085' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'FROSTWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Tealwood North' ,`TaxAmount` = '20142' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169340' WHERE `Matrix_Unique_ID` = '208888276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:38:07.067' ,`MLSNumber` = '23250232' ,`ListAgentFullName` = 'Rebecca Thomas' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'LaNelle McKay' ,`SellingOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`Latitude` = '29.863773' ,`Longitude` = '-94.852669' ,`PhotoCount` = '33' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '260000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'River Run' ,`StreetNumber` = '12110' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2222' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER!!!! Seller will consider all reasonable offers. This is a corner lot, recently replaced HVA, new carpet, wood laminate floors & a shed! Whether you are looking to plant your roots in the growing town of Mont Belvieu (in one of the most desired neighborhoods!) or you are looking for an excellent investment proerty - this is the home for you! Zoned to Barbers Hill ISD North, this home has never flooded, has city services available and has plenty of room! Enjoy the great location - near many new shopping and dining attractions with more on the way! Call today to see this well-kept home.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 167 FISHERS LANDING II' ,`LotDesciption` = 'Corner' ,`LotSize` = '11326' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Call Occupant,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fishers Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169340' WHERE `Matrix_Unique_ID` = '209305319' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:56:38.803' ,`MLSNumber` = '11804139' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703037' ,`Longitude` = '-95.120751' ,`PhotoCount` = '25' ,`PostalCode` = '77536' ,`RoomCount` = '7' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Ivy' ,`StreetNumber` = '905' ,`StreetSuffix` = 'Avenue' ,`City` = 'Deer Park' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable Remodeled Home Come see this beautiful update property in the heart of Deer Park. This 4 Bedroom, 1.5 bathroom house with a big backyard has many updated features and upgrades. Walking into the house you will notice the open living room with refinished hardwood floors, breakfast area and kitchen. \r\n\r\n * Recent Updates Include * Roof * Refinished hardwood Flooring * Vinyl Plank in garage conversion/master suite * Granite Countertops * Appliances * Counter tops and Backsplash * Lighting * Ceiling Fans * Garage conversion * Electrical panel * Plumbing * Toilets * Sinks * Blinds * Windows * Additional Mini Split HVAC Unit in Garage Conversion * Fresh Paint In & Out * Faucet* Garage conversion * Private driveway with full 2 car carport * Large Storage Shed with electricity Could Be Workshop * Huge back yard \r\n\r\nContact us for your private tour!!!' ,`Acres` = '0.1722' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 4 5 & 6 BLK 7 DEER PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Park Add' ,`TaxAmount` = '3513' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169340' WHERE `Matrix_Unique_ID` = '209447611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:13:06.330' ,`MLSNumber` = '61119676' ,`ListAgentFullName` = 'Angela Chaney' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.533879' ,`Longitude` = '-95.355777' ,`PhotoCount` = '8' ,`PostalCode` = '77358' ,`RoomCount` = '6' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Prescott' ,`StreetNumber` = '9' ,`StreetSuffix` = '' ,`City` = 'New Waverly' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1993' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fully custom Ranch style home nestled on 1.42 Acres of unrestricted land. Home features three bedrooms with 2.5 baths in a split floor plan giving the owners more privacy in the primary bedroom. The custom kitchen is open to the family room with a beautiful island and plenty of light. Enjoy family time on your covered patio that comes with a new outdoor kitchen. Call us today to customize your selections from flooring, paint, countertops, fixtures and more.' ,`Acres` = '1.42' ,`Area` = '64' ,`BuilderName` = 'Vance Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Prescott Estates, Lot 36A, 1.42 Acres' ,`LotDesciption` = 'Wooded' ,`LotSize` = '61855' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Prescott Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169340' WHERE `Matrix_Unique_ID` = '210421857' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:12:02.027' ,`MLSNumber` = '21698763' ,`ListAgentFullName` = 'Melissa Youngblood' ,`ListOfficeName` = 'The Professional Landlords' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662388' ,`Longitude` = '-95.463452' ,`PhotoCount` = '36' ,`PostalCode` = '77035' ,`RoomCount` = '10' ,`ListPrice` = '499995.00' ,`Status` = 'Active' ,`StreetName` = 'Willowisp' ,`StreetNumber` = '10904' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEST DEAL IN THE AREA! Beautifully Remodeled Home on a HUGE Corner Lot. This Open Concept 2898sf, 4/3/2CP is in the Desirable Willowbend Subdivision. It has a New Roof with Radiant Barrier, Stainless Steel Appliances, Including Double Wall Oven, 36\" Five Burner Cooktop, Dishwasher and Microwave. Kitchen Island with Breakfast Bar, Custom Cabinets, Granite Countertops, Crown Molding, Built-In Entertainment Cabinet, Hardwood Floors, Low-e Double Pane Windows, Recessed LED Lighting, Walk-In Closets, Large Pantry, Double Sinks in Master Bath, Frameless Shower Enclosure, Brushed Nickel Ceiling Fans, Too Many Upgrades to Mention. This House has 3 Extra Rooms for Whatever You Need it for. Perhaps a Study, Hobby or Media Room, Additional Bedrooms. The Backyard is HUGE with Covered Patio, Room for a Pool with Plenty of Room Left Over for all Your Outdoor Activities. Great Schools! Quick access to the 610 Loop, The Galleria, Houston Medical Center and Downtown Houston. SCHEDULE A SHOWING TODAY!' ,`Acres` = '0.2616' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 107 BLK 7 WILLOW BEND R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11394' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowbend 1' ,`TaxAmount` = '9733' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169340' WHERE `Matrix_Unique_ID` = '210562360' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:21:53.293' ,`MLSNumber` = '41123532' ,`ListAgentFullName` = 'Holley Madden' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739443' ,`Longitude` = '-95.566382' ,`PhotoCount` = '20' ,`PostalCode` = '77042' ,`RoomCount` = '7' ,`ListPrice` = '415000.00' ,`Status` = 'Active' ,`StreetName` = 'Overbrook' ,`StreetNumber` = '10726' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2049' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Warm and inviting Walnut Bend home with beautiful curb appeal enhanced by mature trees & lush landscaping. Updates throughout. Custom cabinets in utility room 2020, gutter guards installed 2020, recessed lighting 2021, windows 2021, carpet 2022, roof approximately 4 years old. The large backyard is complete with pergola and sizable deck, green space, & a flagstone patio - plenty of room to enjoy the outdoors! Abundant green space includes a side yard. Tons of storage on the first floor including the custom built-ins in the living room (2019). Enjoy views of the backyard from the updated kitchen (refrigerator included). Easy flow of the first floor is great for entertaining or everyday living. Large breakfast room & home office space flow seamlessly with the formal dining. Huge primary suite (252 Sqft) offers upgraded bath & 2 walk-in closets. Oversized guest bedrooms with custom built-ins, walk-in closets. Breaker box replaced 2016, refrigerator INCLUDED.' ,`Acres` = '0.1977' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Briargrove Park/Walnutbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 28 & 29A BLK 3 WALNUT BEND SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walnut Bend' ,`TaxAmount` = '7822' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169340' WHERE `Matrix_Unique_ID` = '210986875' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:00:24.357' ,`MLSNumber` = '11868464' ,`ListAgentFullName` = 'Dao Vo' ,`ListOfficeName` = 'Intercontinental Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.096627' ,`Longitude` = '-95.498606' ,`PhotoCount` = '14' ,`PostalCode` = '77389' ,`RoomCount` = '5' ,`ListPrice` = '270600.00' ,`Status` = 'Active' ,`StreetName` = 'Sherioaks' ,`StreetNumber` = '22815' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1774' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home 2 stories, all bedrooms in up-floor ; Kitchen open to breakfast area, wide back door go out large back yard with a patio. Down floor tile, and Up-floor carpet; Ceiling lights can change to connect fan /light; New AC unit 2021, Never flooding, neither has storm damages.....A warm home in good neighborhood, good school.' ,`Acres` = '0.1025' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 5 FOXHOLLOW SOUTH SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4463' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '286' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ZWINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'HILDEBRANDT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Foxhollow South Sec 01' ,`TaxAmount` = '4970' ,`TaxRate` = '3.0041' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169341' WHERE `Matrix_Unique_ID` = '211090507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:11:09.643' ,`MLSNumber` = '10002914' ,`ListAgentFullName` = 'Pamela Evans' ,`ListOfficeName` = 'Texas 1st Choice Realty' ,`SellingAgentFullName` = 'Skyler Lowery' ,`SellingOfficeName` = 'Sand N Sea Properties, LLC' ,`Latitude` = '29.388952' ,`Longitude` = '-95.106653' ,`PhotoCount` = '30' ,`PostalCode` = '77510' ,`RoomCount` = '5' ,`ListPrice` = '320000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'PECAN TRAIL' ,`StreetNumber` = '13346' ,`StreetSuffix` = 'Drive' ,`City` = 'Santa Fe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom 3 full bath home in a sweet sub division on a cul-de-sac! Home features an open concept kitchen with granite counter tops, under cabinet lighting & an island without cook top that over looks family area sure to please any bride! Energy star appliances , High efficiency HVAC & Vinyl double pane low E windows that tilt inside for easy cleaning! Tank less water heater too. Attic has batt, blown and radiant attic barrier insulation and a Honeywell thermostat. This home is ready for you to sit back and enjoy entertaining your friends and family. Has a covered patio and completely fenced in back yard just right for hosting those summer BBQ\'s! Come home to where it\'s still safe for your children to ride up and down the neighborhood and not worry about high traffic! Schedule a showing for your buyers today! Don\'t let this one get away! Thanks again for showing our listing!!!!' ,`Acres` = '0.1754' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 12 BLK 1 PECAN TRAILS SUB (2020) ABST 1' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Back,Lockbox Front,No Photos/No Videos,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Trls Sub' ,`TaxAmount` = '5232' ,`TaxRate` = '2.6465' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169341' WHERE `Matrix_Unique_ID` = '211115456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:47:10.843' ,`MLSNumber` = '5631955' ,`ListAgentFullName` = 'Marcus Zepeda' ,`ListOfficeName` = 'Home Topic Realty' ,`SellingAgentFullName` = 'Jennifer Flud' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '29.963384' ,`Longitude` = '-95.639217' ,`PhotoCount` = '49' ,`PostalCode` = '77429' ,`RoomCount` = '6' ,`ListPrice` = '479900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Whispering Valley' ,`StreetNumber` = '14407' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3223' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cypress dream on 1/2 an acre, NEVER FLOODED and gorgeous POOL with waterfall!! New roof, fresh paint and landscaping. Home features: 5 bedrooms, 3.5 bathrooms, home office, gorgeous freshly redone REAL hardwood flooring throughout (up and down stairs. HUGE kitchen with new commercial stainless steel appliances and granite countertops. 2 car garage with additional 2 car carport that includes storage! 2 Family rooms - one up and one down, each has it\'s own fireplace with an entertainment bar! Large backyard with patio is ready for you and your family! Zoned to award winning schools, LOW LOW taxes. Tons of parking on extra long driveway with gate for guests and room in the backyard for all of your family gatherings, get togethers, holidays and crawfish boils/bbqs!' ,`Acres` = '0.4936' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9A BLK 3 ENCHANTED VALLEY ESTATES U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Enchanted Vly Estates' ,`TaxAmount` = '6311' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169341' WHERE `Matrix_Unique_ID` = '211174095' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T06:31:51.683' ,`MLSNumber` = '77000552' ,`ListAgentFullName` = 'Patti Lacy' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.211936' ,`Longitude` = '-95.542195' ,`PhotoCount` = '50' ,`PostalCode` = '77382' ,`RoomCount` = '11' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Redland' ,`StreetNumber` = '39' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Four Bedroom Beauty on a Huge Cul-De-Sac Lot* Gorgeous Wood Floors Downstairs * Master Suite Down with New Carpet * Master Bath with Double Vanities * Garden Tub * Sep. Shower * Walk In Closet * Tile Floors in Study & Dining Room * Great Open Floor Plan * Fantastic Kitchen with Granite Countertops * Breakfast Room * Gas Cooktop * Lots of Cabinets and Loads of Counter Space * Game Room Upstairs * Three Bedrooms Upstairs & Two Full Bathrooms * Tons of Storage in This Home Including the Texas Basement * Quiet Backyard with Wonderful Deck Under Amazing Shade Trees * Buckalew Elementary * McCullough Junior High * The Woodlands High School * You\'ll Love the Neighborhood * Great location * Close to I45, Grand Parkway, Hwy 59. Easy access to Downtown Houston!' ,`Acres` = '0.21' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S971936 - WDLNDS VIL ALDEN BR 36, BLOCK 1, LOT 38' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9147' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 36' ,`TaxAmount` = '9322' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169341' WHERE `Matrix_Unique_ID` = '211179959' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T06:49:42.580' ,`MLSNumber` = '10159159' ,`ListAgentFullName` = 'Heidi Dugan' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.711627' ,`Longitude` = '-95.416447' ,`PhotoCount` = '22' ,`PostalCode` = '77030' ,`RoomCount` = '8' ,`ListPrice` = '1099000.00' ,`Status` = 'Active' ,`StreetName` = 'Addison' ,`StreetNumber` = '2431' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2037' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming brick cottage with refreshing pool on an impressive 8700 sq ft lot (per HCAD). Three bedrooms & three baths in the primary structure + incredible guest house with a full bath & additional loft area. Fresh paint in & out! Fabulous recent kitchen updates including quartz counters, backsplash, new white soft close drawers/cabinets, & stainless appliances. Large laundry room off kitchen. New hardwoods and fixtures throughout. Pretty front porch, gorgeous park like backyard & beautiful landscaping. Approx 525 sqft in guest house (per survey). This is a must to see! Great location near the Medical Center & Rice Village. All per seller.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 & TR 10A BLK 5 WESSEX R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Wessex' ,`TaxAmount` = '22155' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169341' WHERE `Matrix_Unique_ID` = '211299670' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:50:29.260' ,`MLSNumber` = '77275407' ,`ListAgentFullName` = 'Grant Threatt' ,`ListOfficeName` = 'Beebe Real Estate, LLC' ,`SellingAgentFullName` = 'Yadira Caro Sanchez' ,`SellingOfficeName` = 'NetWorth Realty of Houston, LLC' ,`Latitude` = '29.692320' ,`Longitude` = '-95.292185' ,`PhotoCount` = '28' ,`PostalCode` = '77087' ,`RoomCount` = '3' ,`ListPrice` = '179999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Thurow' ,`StreetNumber` = '7535' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Original owner home offered for sale in established, Greenway subdivision. Close to city districts, airports, hospitals, shopping, and more. Situated just outside the 610 Loop, this home is minutes from the Gulfgate Center and the Astrodome. The property has tremendous potential for a new owner and includes a 12x20 workshop with power, water, and sewer. Property boasts a beautiful lawn, thoughtful paths, deck, and landscaping. It is ready for your touches to make this gem uniquely yours. All dimensions should be verified.' ,`Acres` = '0.1599' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 14 GREENWAY SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6966' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GOLFCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenway' ,`TaxAmount` = '2371' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169342' WHERE `Matrix_Unique_ID` = '211379686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T06:58:37.590' ,`MLSNumber` = '78037300' ,`ListAgentFullName` = 'Kathryn Jean' ,`ListOfficeName` = 'TexasLife Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.215241' ,`Longitude` = '-95.661792' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '649990.00' ,`Status` = 'Active' ,`StreetName` = 'Acorn' ,`StreetNumber` = '33302' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2738' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 33302 Acorn Court in the gated community of Thousand Oaks, conveniently located to Tomball, The Woodlands, and the Aggie Expressway. The home is situated on an amazing, private 1.492 acre cul-de-sac lot with exceptional landscaping around the home and pool. The long driveway leads to your 3 car garage and storage building for all of your hobby and equipment storage needs. The home has a beautiful kitchen, dining room, office and primary bedroom downstairs with your game room & 3 bedrooms upstairs for a wonderful layout. The covered back porch overlooks your heated saltwater pool (brand new pump) & fenced backyard space for a serene setting. Primary bath has dual vanities, jacuzzi tub, separate shower, & walk in closet. Home also has - beautiful plantation shutters throughout, lovely ironwork on the stairs, built ins on the side of your limestone fireplace, wood floors, chef\'s kitchen, spacious laundry room. Come see what this home has to offer - it\'s beautiful!' ,`Acres` = '1.492' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THOUSAND OAKS 01, BLOCK 3, LOT 7, ACRES 1.492' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '64992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Thousand Oaks 01' ,`TaxAmount` = '7150' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169342' WHERE `Matrix_Unique_ID` = '211469600' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:37:43.603' ,`MLSNumber` = '8544568' ,`ListAgentFullName` = 'Chris Kamprath' ,`ListOfficeName` = 'Legend Texas Properties' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.157258' ,`Longitude` = '-96.399293' ,`PhotoCount` = '20' ,`PostalCode` = '77833' ,`RoomCount` = '6' ,`ListPrice` = '339900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Day' ,`StreetNumber` = '1202' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2250' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on over 1/3 of an acre in one of Brenham\'s oldest neighborhoods, 1202 S Day St has a lot to offer whether your looking for a second home or wanting to make a full time move.\r\n\r\nThe 3 bedroom 2 bath home sits on a huge corner lot with beautiful trees in front and a gated entrance in back for extra privacy. Going up the walkway to the front door, the attention and care given to this house is immediately noticeable. The touches like the brick accents in the kitchen or the floating sink in the guest bath really make this house pop! There\'s plenty of space for entertaining in the large living room and guests can easily spill onto the huge back porch and into the oversized backyard.\r\n\r\nJackson Street Park is just a 2 block walk away and downtown Brenham is just a little over 1/2 mile, making for an extremely convenient and desirable location. \r\n\r\nIf you are looking to buy a home in Brenham, 1202 S Day needs to be on your short list! Make an appointment to see it today.' ,`Acres` = '0.338' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S6450 - WILKINS, W. G., BLOCK 10, LOT 2A-1, ACRES 0.338, (PL' ,`LotDesciption` = 'Corner' ,`LotSize` = '14723' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilkins W G' ,`TaxAmount` = '5250' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169342' WHERE `Matrix_Unique_ID` = '211543395' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:25:31.427' ,`MLSNumber` = '97290908' ,`ListAgentFullName` = 'Kristina Smitha' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.801360' ,`Longitude` = '-95.065338' ,`PhotoCount` = '44' ,`PostalCode` = '77351' ,`RoomCount` = '6' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Iris' ,`StreetNumber` = '230' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1606' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE IN READY!!!!! Welcome to The Meadows located in Cedar Point Subdivision. 24 hour manned gate. Two story, 3/2-1/2. The first floor opens living room, dining and kitchen. 1/2 bath located on first floor for guests. Second floor offers additional family-game room, Second floor offers three bedrooms. Primary Bedroom with walk-in closet and private bathroom. Two bedrooms with walk in closets and a full bath. Many upgrades recently new - Security lighting, front door security camera, new sink and mirror in half bath, vinyl flooring, kitchen counter tops and backsplash, microwave over the stove, remote controlled ceiling fans in bedrooms, lighting fixtures, enjoy \"working out\" to your favorite music in the 19x19 insulated garage Enjoy the back yard. Sit under the big shade tree and sip your morning coffee. Showing Smart for appointments.' ,`Acres` = '0.1527' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'THE MEADOWS SECTION 1 BLK 39 LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '578' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Meadows' ,`TaxAmount` = '3016' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169342' WHERE `Matrix_Unique_ID` = '211760741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:44:20.370' ,`MLSNumber` = '71526079' ,`ListAgentFullName` = 'Melissa Morales' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.289260' ,`Longitude` = '-94.797727' ,`PhotoCount` = '29' ,`PostalCode` = '77550' ,`RoomCount` = '9' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue P 1/2' ,`StreetNumber` = '3016' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1734' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Washer/Dryer will stay. Seller to contribute $2k towards rate buy down. Great for vacation rental. Will leave partially furnished. Gorgeous French-style home with charming details throughout! Fall in love with the large front porch, a perfect home for rocking chairs and a great place to enjoy morning coffee. Inside, arched doorways and crown molding throughout give warmth and charm. The front living room has a fireplace & the other front room, used as a dining room, would also make a great office! The kitchen has stylish shiplap walls and a spacious island with quartz counters. Vinyl plank floors throughout - NO CARPET! Downstairs utility room and full bath including a walk-in shower and glass bowl sink. All bedrooms upstairs include 3 spacious rooms and a bath with a gorgeous custom-tiled shower! Just minutes to the historic Pleasure Pier, shopping, dining, and, of course, the beach! Home has never flooded.' ,`Acres` = '0.1179' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 11 NW BLK 89 GALVESTON OUTLOTS' ,`LotDesciption` = 'Other' ,`LotSize` = '5136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '5302' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169342' WHERE `Matrix_Unique_ID` = '211771408' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T06:35:11.390' ,`MLSNumber` = '87834029' ,`ListAgentFullName` = 'Monica Foster' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818158' ,`Longitude` = '-94.974259' ,`PhotoCount` = '32' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Cinnamon Lake' ,`StreetNumber` = '5635' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Please read agent remarks****\r\nWelcome to this charming 3 bedroom 2 bath home. Walk into a large living room with beautiful real wood floors. An eat-in kitchen and 3 bedrooms to suit. Perfect starter home or downsize to this cozy home. Refrigerator and washer and dryer to stay with the sale of the home.' ,`Acres` = '0.148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 SPRINGFIELD ESTATES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Springfield Estates Sec 06' ,`TaxAmount` = '5257' ,`TaxRate` = '3.095' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665169342' WHERE `Matrix_Unique_ID` = '211805536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:35:47.197' ,`MLSNumber` = '38110199' ,`ListAgentFullName` = 'Jason Knebel' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075669' ,`Longitude` = '-95.263689' ,`PhotoCount` = '12' ,`PostalCode` = '77365' ,`RoomCount` = '9' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Ramsey Heights' ,`StreetNumber` = '25566' ,`StreetSuffix` = 'Way' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Upgraded single story home on a premium waterfront lot near Kingwood! This 3 bed / 2 bath KB Home was constructed in 2017 with several upgrades. Tile floors extend throughout the entire home – no carpet! The kitchen is wrapped in granite counters, has wood cabinets, accent back splash, and walk-in pantry. Refrigerator included! The kitchen is open to the dining area and large living room. Primary suite has a walk-in closet, and bath has double sinks. The split plan has two secondary bedrooms and full bath at the front of the house. A laundry room provides extra storage and access to the two-car garage. Step outside to a covered back patio with gas hookup for grilling. A gate in the back iron fence leads to a greenspace and neighborhood lake. Home has brick on all four sides. Community includes a playground, pavilion, and splash pad. Quick access to nearby schools, Highway 59 and Grand Parkway. All info per Seller.' ,`Acres` = '0.153' ,`Area` = '40' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S273104 - BROOKWOOD FOREST 04, BLOCK 2, LOT 10' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6664' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '740' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookwood Frst Sec 4' ,`TaxAmount` = '6848' ,`TaxRate` = '3.6131' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169343' WHERE `Matrix_Unique_ID` = '211954327' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:28:44.957' ,`MLSNumber` = '81936936' ,`ListAgentFullName` = 'Linda Hale' ,`ListOfficeName` = 'TX Lake & Land Re Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.711283' ,`Longitude` = '-95.561012' ,`PhotoCount` = '50' ,`PostalCode` = '77340' ,`RoomCount` = '3' ,`ListPrice` = '274900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue S' ,`StreetNumber` = '2101' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1683' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This adorable home has been updated with precious modern farmhouse style renovations. It is bright and airy. The bathrooms, both primary and secondary feature shiplap and modern black and white color palettes. This home is adorable and waiting for the next family to love it.' ,`Acres` = '0.257' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HIGHLAND - SEC 3, BLOCK 12, LOT 8, PT 9, ACRES .257' ,`LotDesciption` = 'Corner' ,`LotSize` = '11195' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland - Sec 3' ,`TaxAmount` = '3398' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169343' WHERE `Matrix_Unique_ID` = '212022197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:26:24.510' ,`MLSNumber` = '43640067' ,`ListAgentFullName` = 'Shantanu Patil' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.540286' ,`Longitude` = '-95.582283' ,`PhotoCount` = '41' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '689000.00' ,`Status` = 'Active' ,`StreetName` = 'Tamara Heights' ,`StreetNumber` = '4526' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This GORGEOUS, Modern 3931 sqft, 5 Bedrooms, 4 Baths, 2 Car Garage with 2 BEDROOM DOWNSTAIRS located in the much sought after Riverstone Master Planned community boasts an Gorgeous 2-Story foyer, and a 2-Story Family room, Open Concept Kitchen giving it that open spacious feel with lots of Natural light. State of the art RECENTLY UPGRADED KITCHEN features Beautiful Expresso Cabinets, Classy Backsplash, a Huge Island w/ Elegant Quartz countertops, Walk In Pantry & offers plenty of Counter and Storage space. Beautiful 8’ doors throughout the home. NEWLY UPGRADED TILE FLOORING & MODERN LIGHT FIXTURES \r\nLarge backyard w/ no back neighbors perfect for that dream pool and plenty of space to entertain friends and family. Second floor has 9ft ceilings giving a spacious feel to all bedrooms. The 5th bedroom upstairs can be converted to a Media Room. Zoned to some excellent Fort Bend Schools DID NOT FLOOD. A MUST SEE!\r\n CALL THE PATIL REAL ESTATE GROUP FOR YOUR PRIVATE TOUR' ,`Acres` = '0.2055' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'AUBURN MANOR AT RIVERSTONE SEC 2, BLOCK 2, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8953' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Auburn Manor At Riverstone Sec 2' ,`TaxAmount` = '10023' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169343' WHERE `Matrix_Unique_ID` = '212062682' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:16:10.033' ,`MLSNumber` = '10996172' ,`ListAgentFullName` = 'Brandy Liss' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = 'Blake Baker' ,`SellingOfficeName` = 'RE/MAX 5 Star Realty' ,`Latitude` = '29.519245' ,`Longitude` = '-94.995886' ,`PhotoCount` = '40' ,`PostalCode` = '77518' ,`RoomCount` = '9' ,`ListPrice` = '400000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Miles' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Road' ,`City` = 'Bacliff' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO YOUR NEW HOME!\r\n\r\nYou\'ll fall in love with this cottage chic home the moment you walk in. From the mid-century modern woodwork to the bead-board coffered ceilings, this home has all of the luxurious finishes you could want. Wait until you see the oversized garage!! \r\n\r\nThe pride of ownership shines through in every detail, from the new roof and fence to the new windows and beautiful finishes. You\'ll love spending time in this home, whether you\'re cooking in the gorgeous kitchen with granite counters and apron front stainless sink or entertaining friends and family in the spacious backyard. \r\n\r\nBest of all, this home is incredibly affordable with low taxes and no HOA fees. So call today for a private tour and start enjoying your new home!' ,`Acres` = '0.3128' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 67 N FULLER SUR LOT 2 & NW 43.3 FT OF LOT 1 & SE 20 FT' ,`LotDesciption` = 'Corner' ,`LotSize` = '13625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Bayview Add' ,`TaxAmount` = '2679' ,`TaxRate` = '1.9548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169343' WHERE `Matrix_Unique_ID` = '212202068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T06:37:13.430' ,`MLSNumber` = '60236239' ,`ListAgentFullName` = 'Jewell Burroughs' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Christina Shyu' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.585856' ,`Longitude` = '-95.602636' ,`PhotoCount` = '21' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '325000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Pineleaf' ,`StreetNumber` = '2831' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2167' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 3 BEDROOM HOME NESTLED IN THE HEART OF FIRST COLONY ON A CORNER LOT IN THE POCKET NEIGHBORHOOD OF COLONT GRANT. GREAT OPEN FLOORPLAN WITH PLANTATION SHUTTERS THROUGHOUT THE HOME! GREAT LOCATION, CLOSE TO MAJOR HIGHWAYS, SHOPPING, RESTAURANTS AND FORT BEND SCHOOLS. THE NEIGHBORHOOD ALSO HAS TWO POOLS, TENNIS COURTS, A LAKE FOR CATCH AND RELEASE FISHING AND A CLUBHOUSE. RECENT UPDATES INCLUDE RANGE, DISHWASHER, MICROWAVE, SINK, KITCHEN FAUCET, CABINETS, BACKSPLASH, PAINT, LUXURY VINYL FLOORING ALL INSTALLED AUGUST \'21. GAS LINE FOR OUTDOOR GRILL JUNE\' 21. NEW CEILING FANS IN BEDROOMS, PAINT IN BOTH BATHROOMSAND CABINETS REFINISHED IN BOTH BATHS AUGUST\'22. OUTDOOR GAS GRILL IS INCLUDED. WASHER, DRYER AND REFRIGERATOR ARE NEGOTIABLE. NEW ROOF INSTALLED AT CLOSING!' ,`Acres` = '0.1849' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY GRANT SEC 1, BLOCK 2, LOT 1' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8056' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Colony Grant' ,`TaxAmount` = '5778' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169343' WHERE `Matrix_Unique_ID` = '212252510' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:25:43.717' ,`MLSNumber` = '20876214' ,`ListAgentFullName` = 'Anisa Hoxha' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801453' ,`Longitude` = '-95.554534' ,`PhotoCount` = '50' ,`PostalCode` = '77043' ,`RoomCount` = '8' ,`ListPrice` = '459000.00' ,`Status` = 'Active' ,`StreetName` = 'Haddington' ,`StreetNumber` = '10410' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2069' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully fully remodeled home located in the sought-after neighborhood of Shadow Oaks features charm, character and many updates! The updates include fresh new exterior paint, custom kitchen cabinetry, updated bathrooms, raised ceilings, tile flooring and so much more. Throughout the home, you will find beautiful wood look tile flooring and well as double pane windows offering sunlight and a gorgeous view to the backyard garden. The garden truly is one of a kind and a must see!! The primary suite is as big as you will find in any home! Only minutes away from I-10, Memorial Mall, Town & Country City Center and the Energy Corridor makes this home a trendy and convenient location. Schedule your appointment today!' ,`Acres` = '0.2009' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 14 SHADOW OAKS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING OAKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Oaks Sec 05' ,`TaxAmount` = '9736' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665169344' WHERE `Matrix_Unique_ID` = '212252940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:30:46.137' ,`MLSNumber` = '59184652' ,`ListAgentFullName` = 'Kimbriana Nzeogu' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467176' ,`Longitude` = '-95.529582' ,`PhotoCount` = '26' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '610000.00' ,`Status` = 'Active' ,`StreetName` = 'Morning Glow' ,`StreetNumber` = '8810' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury living in the highly desired Master Planned Community of Sienna with resort style amenities. This new construction, move-in ready Perry Home has NEVER been lived in. Meticulously crafted open-concept floor plan offers a 2-story family room and dining room with soaring 19\' ceilings, great for entertaining. With 5 bedrooms and 4.5 bathrooms, there is a bathroom for almost every room in the house. Home office with French doors is set at the 2-story entryway, very convenient for remote work. Chef\'s kitchen featuring engineered stone countertops overlooks the family room with a wall of windows. The massive primary suite does not disappoint with ensuite bathroom including 2 walk-in closets, double vanities, stand up shower, separate spa tub and private toilet room. As a bonus, there is a secondary bedroom with a full ensuite bathroom on the first floor. Custom shutters have been newly installed in each bedroom. Extended covered patio and oversized backyard complete this Smart Home.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Sienna - Section 32A, LOT 23, BLK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7490' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169344' WHERE `Matrix_Unique_ID` = '212276654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:19:03.800' ,`MLSNumber` = '61962780' ,`ListAgentFullName` = 'Noreen Arleth' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.211498' ,`Longitude` = '-95.733170' ,`PhotoCount` = '42' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'High Holly' ,`StreetNumber` = '505' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One story home on corner lot in popular subdivision. This is better than new, as everything is done for you. No carpet so there is tile in the wet areas and living and vinyl plank throughout the rest. Study could also be formal dining. Island kitchen is open to den. Split floor plan. Master and one other bath have large walk-in showers. Bathroom three has tub/shower. Covered back porch and privacy fence to keep your pets in your yard. Washer dryer, refrigerator and whole house water softner system will all stay. This is an immaculate home and is ready for new family!' ,`Acres` = '0.1834' ,`Area` = '15' ,`BuilderName` = 'M/I' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S712203 - MAGNOLIA RIDGE FOREST 03, BLOCK 4, LOT 5' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7991' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Magnolia Ridge Forest' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169344' WHERE `Matrix_Unique_ID` = '212299989' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:29:08.527' ,`MLSNumber` = '55942715' ,`ListAgentFullName` = 'Stephen Findley' ,`ListOfficeName` = 'Sky Real Estate Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.182454' ,`Longitude` = '-95.750609' ,`PhotoCount` = '28' ,`PostalCode` = '77355' ,`RoomCount` = '8' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Sapling Oaks' ,`StreetNumber` = '18911' ,`StreetSuffix` = 'Place' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! 4 large bedrooms with a flex room/bedroom on first floor. 3.5 bathrooms at 2326 sq.ft. gives your family all the space you need. Walk in Attic Storage is spacious. New 5 ton Air Conditioner and coil is a huge plus with a whole house water filter and softener. Excellent floor plan with primary bedroom down, formal dining, beautiful kitchen and family game room upstairs with three bedrooms and two baths. You will love the exterior curb appeal, with added concrete in front and back for seating and entertaining. Just behind the privacy fence with gate you have a greenbelt and wooded area. Come make this incredible home yours and enjoy beautiful Magnolia!' ,`Acres` = '0.1449' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S532202 - GLEN OAKS 02, BLOCK 3, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6314' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'NICHOLS SAWMILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Oaks 02' ,`TaxAmount` = '5912' ,`TaxRate` = '2.8087' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169344' WHERE `Matrix_Unique_ID` = '212446686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:41:33.263' ,`MLSNumber` = '39368913' ,`ListAgentFullName` = 'Melyssa Bordelon' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.058421' ,`Longitude` = '-95.723659' ,`PhotoCount` = '41' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '419999.00' ,`Status` = 'Active' ,`StreetName` = 'Percheron Park' ,`StreetNumber` = '20131' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2476' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why wait on a new build when this few month old 4-Bedroom, 3.5-Bath is move in ready??!!! This home is on a HUGE premium lot with a giant backyard, and a covered patio perfect to watch the Texas Sunsets. Featuring an open-concept with high ceilings, tile floors, a fireplace, and a walk-in pantry! Primary suite features a large walk-in closet, oversized walk-in shower, and double sinks! Home also includes upgraded mirrors, oversized utility room, and ceiling fans in all bedrooms! You can take a walk down to one of the community lakes, playgrounds, or the community resort that includes a swimming pool, playgrounds, a dog park, and even a gym! Zoned to Tomball I.S.D, and a quick drive to Highway 249 and Highway 290.' ,`Acres` = '0.2108' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 AMIRA SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '9184' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.4925' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169344' WHERE `Matrix_Unique_ID` = '212463821' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T06:33:39.070' ,`MLSNumber` = '59693582' ,`ListAgentFullName` = 'Patti Lacy' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.686352' ,`Longitude` = '-95.821761' ,`PhotoCount` = '36' ,`PostalCode` = '77406' ,`RoomCount` = '0' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Winford Estate' ,`StreetNumber` = '25638' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful open floor plan in this four bedroom, one story beauty on a big corner lot. Roof replaced in 2019. Split floor plan, which is great for added privacy. Kitchen opens to the den and boasts subway tile, granite countertops, breakfast bar, lights and under / over mount lighting. Gas cooktop is every chef\'s dream. Plenty of counterspace and cabinets for all your dinnerware, kitchen gadgets and cookware. Microwave, oven and stove all replaced in 2018. Large laundry room with room for full size washer, dryer and even room for a refrigerator. Owner\'s suite with tray ceiling, wood floors and wall of windows overlooking the lovely backyard. HUGE den with stunning wood floors. Coat closet has been converted to a backpack cubby. Three spacious secondary bedrooms make the perfect space for guests, office and children\'s rooms. Travertine tile in the entry. Per seller: never flooded. Close to Westpark Tollway, Grand Parkway- easy access to shopping, hospitals, schools and restaurants.' ,`Acres` = '0.1803' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON LAKES AT WESTHEIMER LAKES SEC 2, BLOCK 5, LOT 10' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7853' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Canyon Lakes At Westheimer Lakes' ,`TaxAmount` = '6085' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169344' WHERE `Matrix_Unique_ID` = '212602602' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T06:24:51.377' ,`MLSNumber` = '69680732' ,`ListAgentFullName` = 'Nayereh Tchamanzar' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.214094' ,`Longitude` = '-95.428288' ,`PhotoCount` = '15' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Blackberry Lily' ,`StreetNumber` = '16871' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom home in lovely Montgomery Creek Ranch, close to neighborhood park and also to everything The Woodlands has to offer. Brand new porcelain flooring, brand new carpet, brand new granite, open concept kitchen, brand new Master bath walk-in shower. Updated upstairs bath, updated powder room, large game room, New roof. All measurements are approximate, buyers to measure to their satisfaction.\r\nCall me or Text me directly for private showing and for Low Interest Rate Loan.' ,`Acres` = '0.116' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S720806 - MONTGOMERY CREEK RANCH 06, BLOCK 2, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5055' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 06' ,`TaxAmount` = '5826' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169345' WHERE `Matrix_Unique_ID` = '212712240' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:25:40.987' ,`MLSNumber` = '90342958' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.095148' ,`Longitude` = '-95.189614' ,`PhotoCount` = '7' ,`PostalCode` = '77365' ,`RoomCount` = '6' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Chester Lake' ,`StreetNumber` = '4906' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand New Lennar Avante Collection home in Royal Brook at Kingwood!\r\n\r\nThis single story \'Cupertino D\' home has a comfortable layout that works well. The front door leads into the open concept family room, which flows seamlessly into the kitchen and dining area with a patio in back. Two bedrooms connect to the family room, while the owner’s suite is in the back with a full bathroom.\r\n\r\nPrices and features may vary and are subject to change. Photos are for illustrative purposes only.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0013 BLK 003 LOT 008' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW CANEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Royal Brook' ,`TaxAmount` = '' ,`TaxRate` = '3.2531' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169345' WHERE `Matrix_Unique_ID` = '212730703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T06:55:03.670' ,`MLSNumber` = '97550906' ,`ListAgentFullName` = 'Yvonne Pruneda' ,`ListOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.160299' ,`Longitude` = '-95.629385' ,`PhotoCount` = '50' ,`PostalCode` = '77486' ,`RoomCount` = '11' ,`ListPrice` = '419990.00' ,`Status` = 'Active' ,`StreetName` = 'Shalmar' ,`StreetNumber` = '2238' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2402' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This elegant New Construction single family home sits on a tree-lined street in highly desirable Columbia Lakes, a breathtaking community, surrounded by 2,000 wooded acres, lakes, and lagoons. The sleek front elevation and thoughtfully landscaped grounds invite you into the front yard. Meticulous attention to detail is presented in the kitchen with quartz countertops, customized backsplash, custom fitted cabinets, and brand-name appliances. Adjacent to the living room an oversized primary bedroom with en-suite bathroom featuring double sinks, stand-alone shower, soaking tub, and a walk-in closet. Other features of this home include a study, 3-secondary bedrooms w/full bath, and spacious utility room. The backyard includes a large, covered patio providing plenty space for gardening and entertaining. Upgraded to the max this home is move-in ready; stop in today!' ,`Acres` = '0.2391' ,`Area` = '5' ,`BuilderName` = 'Barrientos Construct' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 2 (A0133 M VARNER) BLK 25 LOT 17' ,`LotDesciption` = 'On Golf Course,Subdivision Lot' ,`LotSize` = '10415' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '911' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169345' WHERE `Matrix_Unique_ID` = '212747665' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:31:56.960' ,`MLSNumber` = '15863322' ,`ListAgentFullName` = 'Vicki Miller' ,`ListOfficeName` = 'RE/MAX Opportunities' ,`SellingAgentFullName` = 'Kimberly Harris' ,`SellingOfficeName` = 'Century 21 Olympian Galleria' ,`Latitude` = '29.399992' ,`Longitude` = '-95.794557' ,`PhotoCount` = '50' ,`PostalCode` = '77461' ,`RoomCount` = '7' ,`ListPrice` = '425000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Aaron' ,`StreetNumber` = '11102' ,`StreetSuffix` = 'Way' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this Awesome opportunity to become the proud owners of 11102 Aaron Way! This home is situated on a spacious 1/2 acre lot and is located just a few minutes from Needville Schools, downtown establishments, and quick access to major freeways. Interior features include: open concept floor plan, formal dining room, combo of beautiful laminate wood and neutral tile flooring, generous sized living room with a cozy fireplace overlooking gorgeous grounds in the backyard. The kitchen has ample counter/cabinet space, Culligian reverse osmosis, breakfast bar and additional breakfast room. The exterior features include: 50x30 METAL framed fully insulated SHOP equipped with concrete floors, 1 ton overhead crane, 240 single phase, boat/RV parking, extended parking for equipment, 25x20 overhang and 30x25 carport/leanto. The privacy fenced backyard is made for entertaining and is complete with an extended deck, covered pavilion, firepit, and plenty of \'elbow\' room between neighbors.' ,`Acres` = '0.587' ,`Area` = '30' ,`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` = '1' ,`Legal` = 'ROSEMEADOW SEC 3, BLOCK 10, LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25570' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosemeadow' ,`TaxAmount` = '4541' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169345' WHERE `Matrix_Unique_ID` = '212766239' --> 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','212778193','1665169345','212778193','2022-10-07T07:55:06.077','58683266','Anna Enriquez','Tentori Properties, LLC','','','29.602230','-95.130640','46','77059','1','435000.00','Active','Cherry Mill','3122','Court','Houston','3','1','5','3086','Single-Family','Welcome to your new home! This spacious home is in a quiet cul-de-sac of Northfork Subdivision Clear Lake City it\'s completely renovated and ready to go for it\'s next owner. This home has tons to offer including a large open concept to the kitchen, fresh paint and flooring throughout the home, granite countertops, new kitchen appliances and all new windows for more natural sunlight to enter the house. The owners suite is located on the 1st floor along with a large walk in closet and a BONUS game room located up stairs,it\'s truly a great setup for entertaining guests. Zoned to Clear Creek ISD schools and located near a local H-E-B and popular restaurants. Come see this home for yourself you do not want to miss out! OPEN HOUSE OCT. 8-9th 11am- 2pm','0.1685','7','','','','','Mud,Sellers Disclosure','1','','1','Clear Lake Area','Central Electric','1','LT 6 BLK 2 NORTHFORK SEC 3','Cul-De-Sac','7339','Appraisal District','','535','0','','1','','0','','','','','Other','9 - Clear Creek','NORTH POINTE ELEMENTARY SCHOOL','CLEAR BROOK HIGH SCHOOL','CLEARLAKE INTERMEDIATE SCHOOL','Accompany,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Northfork Sec 03','9211','2.5769','Water District','1997','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:42:16.337' ,`MLSNumber` = '56172553' ,`ListAgentFullName` = 'Brian Phillips' ,`ListOfficeName` = 'Equity Venture Group Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018820' ,`Longitude` = '-95.508891' ,`PhotoCount` = '44' ,`PostalCode` = '77379' ,`RoomCount` = '8' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Wimbledon Forest Court' ,`StreetNumber` = '6607' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous home is perfectly etched on an oversized cul-de-sac lot in the prestigious Wimbledon Forest Estate Subdivision. Newly remodeled pool with color changing LED lighting. Stone and Concrete landscape with french drain system throughout the backyard. Artfully renovated home where great attention has been paid to details, color scheme, and craftmanship. Open concept island kitchen features 5 gas burners with double oven on quartz countertops, and beautiful cabinetry. The coveted butler\'s pantry flows from the kitchen with quartz counters and beautiful cabinets. The cozy family room features high ceilings, a gas log fireplace, and a wall of windows overlooking the pool with led lighting throughout the house. . 2nd floor is loft style living with a full bathroom and walk in closet space. Thus house has a 3 air units and 2 water heaters for efficiency also a stunning 2 car garage with ample storage with a porte-cochere.' ,`Acres` = '0.3457' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 WIMBLEDON FOREST SEC 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15058' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'MITTELSTADT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Colonial,Traditional' ,`Subdivision` = 'Wimbledon Forest' ,`TaxAmount` = '9302' ,`TaxRate` = '2.1875' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169345' WHERE `Matrix_Unique_ID` = '212782616' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:41:18.867' ,`MLSNumber` = '21494189' ,`ListAgentFullName` = 'Diane Nicolas' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560318' ,`Longitude` = '-95.231786' ,`PhotoCount` = '45' ,`PostalCode` = '77581' ,`RoomCount` = '7' ,`ListPrice` = '347750.00' ,`Status` = 'Active' ,`StreetName` = 'Berlino' ,`StreetNumber` = '1612' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1974' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, gated 55+ active adult community. This lovely home features 2 bedrooms, 2 full baths, a study with private outdoor space, a formal dining area as well as an eat-in kitchen with lots of natural light. \r\nThe kitchen has granite countertops, stainless steel appliances, lots of storage, nice pantry and breakfast bar. Home is an open style floor plan with high ceilings. Split bedroom plan assures privacy. All of the above plus it has covered back patio with wonderful unobstructed views of nature reserve. Washer, Dryer, Refrigerator and hurricane window protection fabric stay with the home. Many homeowner upgrades including recent A/C, water heater and new roof 2022. See attached upgrade and feature sheet. \r\nHOA fee includes access to beautiful clubhouse featuring heated pool/hot tub, gym, ballroom, game rooms and numerous community functions. Ask your agent to show you homeowner feature sheet and the September calendar of events.' ,`Acres` = '0.1309' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 5 BELLAVITA AT GREEN TEE SEC 5 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '262' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEBER ELEMENTARY' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bellavita at Green Tee' ,`TaxAmount` = '7821' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169346' WHERE `Matrix_Unique_ID` = '212921042' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:00:34.607' ,`MLSNumber` = '90719057' ,`ListAgentFullName` = 'Ashley Parker' ,`ListOfficeName` = 'Coldwell Banker Apex, REALTORS LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.331076' ,`Longitude` = '-96.648678' ,`PhotoCount` = '25' ,`PostalCode` = '77879' ,`RoomCount` = '3' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Deer Circle' ,`StreetNumber` = '104' ,`StreetSuffix` = '' ,`City` = 'Somerville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this 3/2 manufactured home located in the Wilderness Sounds subdivision! The opportunities for this slice of heaven are endless! Situated on 1.5 acres, and approximately 5 minutes from Lake Somerville, this is the one you\'ve been waiting for. Manufactured in 2019, and like new, this home boasts 3 bedrooms, 2 full baths, a garden tub in the master, kitchen island that is great for entertaining, laminate flooring in all main areas and a newly added covered deck to the back of the home! There is a community water system in place provided by HDU Services and electric is onsite. If you are searching for unrestricted, Wilderness Sounds has no HOA and welcomes all structures including tiny homes, RV\'s, Manufactured Homes, Cabins and barndos too! Schedule your showing today!' ,`Acres` = '1.53' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S2519 WILDERNESS SOUNDS BLK 2 LOT 93-95, 1.5299 ACRES SN# CL' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '66643' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wilderness Sounds' ,`TaxAmount` = '1945' ,`TaxRate` = '1.78437' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169346' WHERE `Matrix_Unique_ID` = '212999046' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:36:43.577' ,`MLSNumber` = '83354851' ,`ListAgentFullName` = 'Stacy Wood' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.801677' ,`Longitude` = '-95.404549' ,`PhotoCount` = '37' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '1675000.00' ,`Status` = 'Active' ,`StreetName` = '18th' ,`StreetNumber` = '430' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful \"New Orleans\" Style home with porches up and down, on a tree lined street in the HEART of the HEIGHTS. This home is 3352 sq. ft. with 3 Bedrooms PLUS an Office/Flex Room, 2 full baths and 1 half bath; and sits on a fully fenced, 6600 sq. ft lot with SWIMMING POOL and SPA. Kitchen has been completely remodeled from top to bottom with commercial line, Thermador appliances, marble counters, along with brass hardware and fixtures. In addition to the kitchen, all 3 bathrooms have been extensively remodeled as well. This home will not disappoint! In addition, to cosmetic updates, Roof replaced in 2021, HVAC system replaced 2022, Tankless Water Heater installed 2022, Pool Heater replaced in 2021 to list just a few of the major improvements made to this home. This home is the perfect home for entertaining. Located between Ashland and Nicholson just South of 19th! Easy access to the Nicholson Hike and Bike Trail, Heights Theater and all the shops and dining along 19th Street.' ,`Acres` = '0.1515' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 121 HOUSTON HEIGHTS 4TH AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HELMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights 04 Amd' ,`TaxAmount` = '19619' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169346' WHERE `Matrix_Unique_ID` = '212999477' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:53:51.853' ,`MLSNumber` = '79786262' ,`ListAgentFullName` = 'Cody Scurlock' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.406080' ,`Longitude` = '-95.061469' ,`PhotoCount` = '50' ,`PostalCode` = '77568' ,`RoomCount` = '10' ,`ListPrice` = '424999.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Egret' ,`StreetNumber` = '13404' ,`StreetSuffix` = 'Lane' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A home like no other built by Tricoast Homes is situated in the luxurious sought-after subdivision of Lago Mar! Lush landscaping sprinkles the community as you drive through and make your way to the stunning home offering the 1 story Nantucket floor plan with a coastal feel. As you walk in you are greeted with vaulted ceilings and light grey walls that complement the soft grey floors. Make your way further into the home to see the spacious living area that is open to the beautiful kitchen that offers white cabinets, white quartz countertops, an enormous kitchen island with a breakfast bar, stainless steel appliances, and a dining area. Take a peek at the roomy bedrooms and Primary Bedroom or Extra Living/TV area. In the backyard, you\'ll find a wonderful, enclosed covered patio with an industrial ceiling fan and custom landscaping! The community offers vast amenities and events. 2 community pools, 2 clubhouses, and 2 gyms, a splash pad, and all the Lago Mar living!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = 'Tricoast Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6 BLK 2 LAGO MAR POD 3 SEC 2 (2022) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169346' WHERE `Matrix_Unique_ID` = '213015847' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:47:54.600' ,`MLSNumber` = '77763947' ,`ListAgentFullName` = 'Jacalyn Henthorne' ,`ListOfficeName` = 'Integrity Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.962122' ,`Longitude` = '-95.177709' ,`PhotoCount` = '37' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'Caney Mountain' ,`StreetNumber` = '16826' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3091' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom, 3.5 bathroom with brick and stone elevation located on a reserve. Hard to find, well maintained single story home. Grand foyer with high ceilings make great for first impressions. Perfect for entertaining for every occasion, enjoy a spacious Great room, kitchen and dining area. After a dinner party, gather in the Great room to either visit or enjoy the game. Retreat to a Owner\'s suite with great windows. This suite also includes a relaxing garden tub with dual sinks, separate show with dual shower heads and a spacious walk-in closet. Picture yourself escaping to the back covered patio or playing games with loved ones in the bonus den room. This plan house plenty of options formal dining/ flex room/ music room etc. The over-sized 3.5-car garage offers convenience for storage and parking your cars. Beautiful landscaping and auto sprinkler system. This home is one you’re sure to love! Impeccable!!!!' ,`Acres` = '0.2316' ,`Area` = '1' ,`BuilderName` = 'trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 GROVES SEC 7' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '10088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '272' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Groves Sec 7' ,`TaxAmount` = '14547' ,`TaxRate` = '3.5373' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169346' WHERE `Matrix_Unique_ID` = '213015897' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:37:01.187' ,`MLSNumber` = '55748046' ,`ListAgentFullName` = 'Fernando Chavira' ,`ListOfficeName` = 'Sprout Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.367072' ,`Longitude` = '-95.094361' ,`PhotoCount` = '48' ,`PostalCode` = '77510' ,`RoomCount` = '4' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue O' ,`StreetNumber` = '5302' ,`StreetSuffix` = '' ,`City` = 'Santa Fe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3210' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you’re looking for your piece of heaven on earth, look no further. Welcome to Santa Fe, TX. Whether you enjoy hosting loved ones or peace and quiet, the only limitation is your imagination. Cool off from this Texas heat or enjoy an evening sunset in your own private oasis. If the heat is too much to handle, enjoy your favorite movies from the second floor where you’ll find the media room and it’s own bathroom. The primary bedroom and primary bath, which include a separate shower and a jetted tub, are on the first floor. The office/study along with the addition bedrooms are located on the first floor as well. The mother in law suite is attached to the garage. If the pool and media room don’t check off all the boxes, the cleared acre can bring your dreams to a reality. The possibilities are endless. Oh, did I mention no HOA or restrictions? Also, Haaks Vineyards & Winery are a short golf cart ride away.' ,`Acres` = '2' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'FRANCO\'S ADDN (2008) ABST 47, BLOCK 1, LOT 1, ACRES 1.0135' ,`LotDesciption` = 'Cleared' ,`LotSize` = '88296' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'DAN J KUBACAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Francos Add 2008' ,`TaxAmount` = '10335' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169347' WHERE `Matrix_Unique_ID` = '213025725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:19:03.830' ,`MLSNumber` = '84154297' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434015' ,`Longitude` = '-95.450717' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '332990.00' ,`Status` = 'Active' ,`StreetName` = 'Greenhorn' ,`StreetNumber` = '10318' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Study with French Doors, Dual Rectangle Vanities with Granite Tops in Primary Bath, Separate Garden Tub and Recessed Tile Shower, Rigid Core Floors in Entry/Foyer, Study, Dining, Utility, Kitchen/Breakfast, Family Room, Hall to Bedrooms and all Baths, Quartz Kitchen Countertops with Island, 4”x6” Tile Kitchen Backsplash, Upgraded Carpet and Pad, Stainless Steel Appliances, Brushed Nickel Lighting and Plumbing Trim Packages, 42” Upper Kitchen Cabinets, Rocker Switches, 2” Window Blinds, Satin Nickel Door Levers, Full Gutters, Covered Patio, Brick Back, Full Sod and Irrigation System, Garage Door Opener, Stone Accented Elevation, Tech Shield Roof, Environments for Living Home, plus more…AVAILABLE JANUARY.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 18 BLK 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6336' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169347' WHERE `Matrix_Unique_ID` = '213042281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:18:13.630' ,`MLSNumber` = '81243219' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.431982' ,`Longitude` = '-95.453313' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '16' ,`ListPrice` = '411990.00' ,`Status` = 'Active' ,`StreetName` = 'Darwin Cedar' ,`StreetNumber` = '1605' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2883' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cul-De-Sac Home Site, 2 Story, 5 Bedroom, 3 ½ Bath, Study with French Doors, Formal Dining Room, Game Room Up, Primary Bedroom Down, Dual Rectangle Vanities with Granite Tops in Primary Bath, Separate Garden Tub and Recessed Tile Shower, Rigid Core Floors in Entry/Foyer, Utility, Study, Dining, Kitchen/Breakfast, Family Room and all Baths, Silestone Kitchen Countertops with Island, Marble Kitchen Backsplash, 42” Upper Kitchen Cabinets, Upgraded Carpet and Pad, Stainless Steel Appliances, Wrought Iron Stair Parts, Raised Panel Interior Doors, Rocker Switches, 2” Window Blinds, Satin Nickel Interior Door Levers, Extended Covered Patio with Gas Line Stub, Full Sod and Irrigation System, Full Gutters, Brick Back on First Floor, Stone Accented Elevation, Tech Shield Roof, Environments for Living Home, plus more…AVAILBLE FEBRUARY.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 11 BLK 2 SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8402' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169347' WHERE `Matrix_Unique_ID` = '213042343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:17:00.407' ,`MLSNumber` = '70980842' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.433910' ,`Longitude` = '-95.450616' ,`PhotoCount` = '6' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '379990.00' ,`Status` = 'Active' ,`StreetName` = 'Greenhorn' ,`StreetNumber` = '10322' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 2 ½ Bath, Study with French Doors, Formal Dining Room, Game Room and Primary Bedroom Up, Dual Rectangle Vanities with Granite Tops in Primary Bath, Separate Garden Tub and Shower, Rigid Core Floors in Entry/Foyer, Utility, Study, Dining, Kitchen/Breakfast, Family Room and all Baths, Granite Kitchen Countertops with Island, Tile Kitchen Backsplash, Upgraded Carpet and Pad, 42” Upper Kitchen Cabinets, Stainless Steel Appliances, Wrought Iron Stair Parts, Raised Panel Interior Doors, Rocker Switches, 2” Window Blinds, Satin Nickel Door Levers, Extended Covered Patio, Full Sod and Irrigation System, Garage Door Opener, Full Gutters, Brick Back on First Floor, Tech Shield Roof, Environments for Living Home, plus more…AVAILABLE FEBRUARY.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 17 BLK 1 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6351' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169347' WHERE `Matrix_Unique_ID` = '213042603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:49:54.720' ,`MLSNumber` = '35364125' ,`ListAgentFullName` = 'Sandra McDuffie' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480115' ,`Longitude` = '-95.190037' ,`PhotoCount` = '33' ,`PostalCode` = '77546' ,`RoomCount` = '10' ,`ListPrice` = '634900.00' ,`Status` = 'Active' ,`StreetName` = 'Longwood Glen' ,`StreetNumber` = '1653' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3169' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Gorgeous Brentwood Plan by Village Builders located in the heart of the desirable West Ranch. This fabulous Home\'s inviting open floor plan is filled with tons of natural light throughout, soaring ceilings as well as many upgrades. The entryway foyer is graced by two lighted art niches for your most treasured artwork, the Study is enhanced by a gorgeous true brick wall and elegant French doors. Charcoal Oak wood flooring, formal dining , beautiful gourmet Kitchen, walk in pantry and huge Island is open to the 2 story Family Room with stunning custom crafted built in book shelves . Primary Bedroom with sitting area, 5 piece primary bath and Walk in-closet. Covered back patio and a good size yard. Second floor has a balcony looking over the Family Room, Game Room , 3 bedrooms and 2 full bathrooms. Zoned to the Friendswood exemplary FISD School District and walk in distance to the soon to be k-5 Cline . Many walking trails, 2 lakes , fishing , playground Pool & splash pad!!' ,`Acres` = '0.1664' ,`Area` = '33' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA AT WEST RANCH SEC 3 (2017) ABST 9, BLOCK 2, LOT 4, AC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'CLINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra/West Ranch Sec 3' ,`TaxAmount` = '13953' ,`TaxRate` = '2.6132' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169347' WHERE `Matrix_Unique_ID` = '213084292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T06:55:13.513' ,`MLSNumber` = '29981526' ,`ListAgentFullName` = 'Aurora Pisana' ,`ListOfficeName` = 'Steel Door Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796694' ,`Longitude` = '-95.738021' ,`PhotoCount` = '31' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Rock Harbor' ,`StreetNumber` = '20703' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2711' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous home sits on an oversized corner lot with an extra long driveway, a finished garage and a big backyard ideal for a fun day of Barbecuing. The home features an open floor plan in the living areas that joins the living room, kitchen and dinning room seamlessly, perfect for entertaining! The kitchen boasts granite counter tops and provides plenty of counter space, ideal for making dinner every night or for meal prepping on the weekend. The primary retreat is luxurious and spacious to relax in after a long day at work, the en-suite bathroom offers plenty of counter space, separate tub and shower and a large walk-in closet that make morning routines fast and easy. Upstairs you will find 3 bedrooms, along with a big game room for the whole family to enjoy, and a bathroom which features double sinks. On a gorgeous day you can walk to the pool and the park! This home has a lot of space for all your dreams to come true!' ,`Acres` = '0.17' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 60 BLK 1 CASTLE ROCK SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7386' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'FRANZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castle Rock' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169348' WHERE `Matrix_Unique_ID` = '213125659' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T06:37:01.010' ,`MLSNumber` = '33663025' ,`ListAgentFullName` = 'Amanda Corral' ,`ListOfficeName` = 'Amada Agency Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.578734' ,`Longitude` = '-95.254643' ,`PhotoCount` = '50' ,`PostalCode` = '77089' ,`RoomCount` = '11' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Pepper Landing' ,`StreetNumber` = '2711' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4/5 bedroom home situated on a corner lot in peaceful Preserve at Highland Glen subdivision.Perfect for entertaining with plenty of open floor plan design, large back yard and expansive den upstairs. Gorgeous wood floors and ceramic tile flooring throughout all common areas. Living room offers an abundance of natural lighting and a cozy fireplace. Oversized island in the kitchen, butlers pantry, granite counter, tile backsplash and under cabinet lighting. First floor primary suite is your retreat complete with trey ceiling, framed mirrors, jacuzzi tub, tile shower with bench seat, dual vanities and a walk in closet. Upstairs features a large game room and media room along with 2 generously sized bedrooms. Automatic sprinkler system in front yard make landscaping a breeze! Whole home powered by Generac generator tied to gas lines. This home has all the bells and whistles!' ,`Acres` = '0.2209' ,`Area` = '3' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 2 PRESERVE AT HIGHLAND GLEN SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9623' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Preserve/Hlnd Glen Sec 1' ,`TaxAmount` = '13239' ,`TaxRate` = '3.6569' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169348' WHERE `Matrix_Unique_ID` = '213152893' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:56:30.643' ,`MLSNumber` = '56713055' ,`ListAgentFullName` = 'Matthew Bradley' ,`ListOfficeName` = '1st Texas, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405527' ,`Longitude` = '-94.997629' ,`PhotoCount` = '34' ,`PostalCode` = '77591' ,`RoomCount` = '9' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Moonstone' ,`StreetNumber` = '2305' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***MAKE SURE TO TAKE THE FULL VIRTUAL TOUR OF THIS HOME ONLINE***Looking for an OASIS? This home sits on a huge cul-de-sac with a huge lot!!! New in-ground gunite pool installed last summer by Anthony Sylvan pools! Water feature and sun basking area to sit while family and friends enjoy the crystal water and sounds of the summer! Pool fence surrounds entire pool so that the younger crew can\'t get in without adult supervision. The fully enclosed 400+ square foot deck is a great place to relax and man the grill or nap! When everybody is done with the pool, there is still a HUGE backyard for yard games, a trampoline, a playset; anything you can imagine! Moving inside, the living area boasts high ceilings and a centerpiece custom designed fireplace that goes all the way to ceiling; huge TV comes with home!!!! Check out virtual tour to get true scale! The upstairs gameroom area is visible from the living room and kitchen to keep tabs on all going on! Come and see this amazing home today!!!' ,`Acres` = '0.218' ,`Area` = '33' ,`BuilderName` = 'Castlerock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PEARLBROOK SEC 1 (2013) ABST 180, BLOCK 1, LOT 29, ACRES 0.2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '9498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pearlbrook Sec 1 2013' ,`TaxAmount` = '8645' ,`TaxRate` = '3.4928' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169348' WHERE `Matrix_Unique_ID` = '213174558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:29:27.903' ,`MLSNumber` = '68039261' ,`ListAgentFullName` = 'Rosa Gonzalez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.035244' ,`Longitude` = '-95.408234' ,`PhotoCount` = '16' ,`PostalCode` = '77373' ,`RoomCount` = '9' ,`ListPrice` = '279999.00' ,`Status` = 'Active' ,`StreetName` = 'High Park' ,`StreetNumber` = '1414' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LARGE BACK YARD with No back neighbors. MOVE-IN-READY. MAJOR UPGRADES including granite counters through out the home, soft close cabinets, tile flooring, and impressive back splash in kitchen. Open and spacious floorplan. Designer tile accent wall in half bath. Gas Fireplace with designer tile accent. Spacious walk-in double shower in primary bathroom. Solar Screen panels on windows for efficiency. NEW ROOF 2019. Trails in area. QUICK access to Hardy Toll & 45 N for commute.' ,`Acres` = '0.1767' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 48 BLK 1 HIGHLAND GLEN SEC 1 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '7696' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GINGER MCNABB ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Glen Sec 01' ,`TaxAmount` = '5723' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169348' WHERE `Matrix_Unique_ID` = '213212312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:35:13.750' ,`MLSNumber` = '38093214' ,`ListAgentFullName` = 'Kandice Fogle' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531490' ,`Longitude` = '-95.738885' ,`PhotoCount` = '35' ,`PostalCode` = '77469' ,`RoomCount` = '9' ,`ListPrice` = '448500.00' ,`Status` = 'Active' ,`StreetName` = 'Quade' ,`StreetNumber` = '7915' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2893' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two-story Westin home in Rivers Run featuring abundant, custom upgrades & design elements throughout! Four BRs, 3.5 BAs with an extended backyard living space for your added enjoyment. Upon entering, you\'ll be greated by an amazing, two-story foyer & rotunda that leads to a family room with soaring window views of the backyard retreat. Upgraded Kitchen cabinets & hardware, designer paint & light fixtures, custom built bookshelf niches anchoring the cast stone fireplace, shiplap enhanced powder bath & surround sound in the main living areas & back patio. The amazing backyard retreat features a custom, extended patio with slate pavers that lead a second, large patio with stone fire pit with gas connection. Located on a cul-de-sac and backing to a restricted reserve, this fabulous property is one-of-a-kind!' ,`Acres` = '0.1693' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERS MIST SEC 3, BLOCK 2, LOT 43' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ARREDONDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RANDLE HIGH SCHOOL' ,`SchoolMiddle` = 'WRIGHT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rivers Mist Sec 3' ,`TaxAmount` = '8711' ,`TaxRate` = '2.7148' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169348' WHERE `Matrix_Unique_ID` = '213226080' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:41:09.880' ,`MLSNumber` = '81669175' ,`ListAgentFullName` = 'Ebony Royal' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.894538' ,`Longitude` = '-95.435522' ,`PhotoCount` = '5' ,`PostalCode` = '77047' ,`RoomCount` = '3' ,`ListPrice` = '294990.00' ,`Status` = 'Active' ,`StreetName` = 'Barnsbury' ,`StreetNumber` = '12808' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1288' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D.R. Horton is America\'s #1 Builder since 2002! Want to live the suburban life close Downtown Houston, The Medical Center, and NRG Stadium? You have found a highly sought after neighborhood that offers you modern designs at affordable pricing. Come out an see this NEW CONSTRUCTION Amber plan with elevation N. \r\n\r\nThe OPEN CONCEPT design features 3 bedrooms, 2 baths, a beautiful kitchen that includes quartz countertops, 42\" inch cabinets, large bar area, and stainless steal appliances including gas stove, built-in microwave, and dishwasher. Enjoy the oversized shower in the Primary Bath, along with a large walk-in closet. Water resistant vinyl flooring, 2\" blinds, and tankless water heater also included. Don\'t pass up this opportunity, this is one of the last opportunities left in this section of the subdivision.\r\n*PHOTOS ARE NOT PICTURES OF THE ACTUAL HOME BUT ARE A REPRESENTATION*' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1 Section 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'HILL ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'City Gate' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169348' WHERE `Matrix_Unique_ID` = '213227760' --> 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','213248176','1665169349','213248176','2022-10-07T06:12:05.940','7466898','Dee Mayo','Cross Capital Realty','','','30.005626','-95.760586','37','77433','9','438000.00','Active','Aster Petal','15010','Court','Cypress','2','0','4','2842','Single-Family','Beautiful house in the desirable community of Fairfield, This one story is located in a Cul-de-sac with an oversized yard. Features and extended Garage, beautiful tile floor in the foyer thru the living room. Formal dining has wood floors with crown modeling. Open kitchen with gorgeous 42\" cabinets, with breakfast bar area. Another feature in this home is the 2nd bath has 36\" door for easy access. The Primary bedroom has plantation shutters that open to view the spacious backyard. This home has been very well maintained by the owner, Solar screens along the back windows help save on energy cost. Come see this home to appreciate all it has to offer or contact listing agent for information.','0.269','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Cypress North','Central Gas','1','LT 17 BLK 3 FAIRFIELD VILLAGE SOUTH SEC 3','Cul-De-Sac','11716','Appraisal District','','1000','0','','2','Electric Oven,Single Oven','0','','','Electric Cooktop,Electric Range','','Composition','13 - Cypress-Fairbanks','SWENKE ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Fairfield Village South Sec 03','8376','2.746','Water District','2007','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:29:51.303' ,`MLSNumber` = '16431628' ,`ListAgentFullName` = 'Marie Davis' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049518' ,`Longitude` = '-95.344243' ,`PhotoCount` = '46' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Pennsgrove' ,`StreetNumber` = '23123' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful move in ready home located in the established neighborhood of Postwood. This house features an attached 2-car garage, 3 bedrooms, and 2 baths! Additional features include a large living room, formal dining, kitchen, fireplace, tile, and beautiful laminate wood flooring. Enjoy entertaining in your spacious backyard which is perfect for the kids and pets to play. Refrigerator stays with the house! \r\nRoof 2015, Double Pane Windows, Water Heater 2019, Ceiling fans in every room. No flooding!\r\nQuick access to shopping, dining, IAH, Mercer Arboretum, I45, Hardy Toll Rd, & Cypresswood Golf Course. \r\nSchedule your private showing today! This house won\'t last long!' ,`Acres` = '0.1695' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 6 POST WOOD SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7384' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '425' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Post Wood Sec 01 R/P' ,`TaxAmount` = '3062' ,`TaxRate` = '2.5868' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169349' WHERE `Matrix_Unique_ID` = '213263316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:38:12.713' ,`MLSNumber` = '77185657' ,`ListAgentFullName` = 'Shane Light' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.559855' ,`Longitude` = '-95.665923' ,`PhotoCount` = '37' ,`PostalCode` = '77479' ,`RoomCount` = '7' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'River' ,`StreetNumber` = '1826' ,`StreetSuffix` = 'Trail' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2-story home in Greatwood Terrace! This 4 bedroom, 2.1 bath home features the primary bedroom downstairs, 3 bedrooms and a game room on the second floor. Updated kitchen including linen white cabinets, granite countertops, custom backsplash and stainless appliances. Vaulted 20 foot ceilings in the entry with glass lead mahogany front door, dramatic arched staircase with laminate wood flooring. No carpet in the home, all tile and laminate wood flooring first and second floor. new interior paint, oversized covered patio with plenty of green space in the back yard! Don\'t miss this one!' ,`Acres` = '0.1725' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD TERRACE SEC 2, BLOCK 1, LOT 6' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '7513' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '910' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Georgian' ,`Subdivision` = 'Greatwood Terrace Sec 2' ,`TaxAmount` = '6023' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169349' WHERE `Matrix_Unique_ID` = '213272316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:28:53.460' ,`MLSNumber` = '92914618' ,`ListAgentFullName` = 'Jacob Fitzgerald' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.179747' ,`Longitude` = '-95.421992' ,`PhotoCount` = '26' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Southampton' ,`StreetNumber` = '921' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2007' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This completely remodeled home in the heart of Angleton is sure to win you over! Original wood floors sanded and stained sealed to its natural color , new paint with a completely remodeled master bath and kitchen . This home has 2 living rooms 4 bedrooms in the MAIN HOUSE and in the brand NEW Mother -n- law suite has its own full kitchen and full Bath. Keep it a mother in law suite or an income producing unit!' ,`Acres` = '0.1848' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CHEVY CHASE #3 (ANGLETON) BLK 1 LOT 23' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Chevy Chase #3 Angleton' ,`TaxAmount` = '2921' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169349' WHERE `Matrix_Unique_ID` = '213278184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:14:20.507' ,`MLSNumber` = '76050875' ,`ListAgentFullName` = 'Darnell Fuller' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.565869' ,`Longitude` = '-95.733314' ,`PhotoCount` = '32' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '735000.00' ,`Status` = 'Active' ,`StreetName` = 'Saxon Bend' ,`StreetNumber` = '1819' ,`StreetSuffix` = 'Trail' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3794' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a very elegant stucco and brick single story home with amazing curb appeal. You enter into a masterfully thought out, dramatic entry boasting high ceilings that flow into an elegant dining room and a spacious family room open to the gourmet kitchen. This kitchen is a chef’s dream with an oversized island, a plethora of cabinetry, granite tops and stainless steel appliances. Entertainment possibilities are endless with a large Texas-sized covered patio and a media room to enjoy movie nights. The comfort continues on to the luxurious Master suite, where you will discover the ideal place to relax after a long day. Located on a green belt, this is great place to call home! With something for everyone, this home will not last long! Come see this house today!' ,`Acres` = '0.3297' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VERANDA SEC 9, BLOCK 2, LOT 22' ,`LotDesciption` = 'Greenbelt,Water View' ,`LotSize` = '14362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Veranda Sec 9' ,`TaxAmount` = '15804' ,`TaxRate` = '3.1798' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169349' WHERE `Matrix_Unique_ID` = '213280094' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:08:52.240' ,`MLSNumber` = '46793591' ,`ListAgentFullName` = 'Shelby Kennedy' ,`ListOfficeName` = 'Greater Houston REP, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.721980' ,`Longitude` = '-95.880091' ,`PhotoCount` = '26' ,`PostalCode` = '77441' ,`RoomCount` = '7' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple Glen' ,`StreetNumber` = '4223' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2357' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A home should be a dream; a home should be an escape. This home might just be that for you. The extended entry with 12 foot coffered ceiling welcomes your guest into the open floor plan featuring an abundant amount of natural lighting and endless opportunity. The spacious kitchen is a home chef’s dream and features great storage, endless countertop space, large gas range, and an oversized granite island for meal prep and built-in seating. Retreat to the large primary suite, offering great natural lighting, double doors leading to the primary bath complete with dual vanities, garden tub,separate glass enclosed shower and two walk-in closets. All secondary bedrooms feature walk in closets. The home office features french doors and provides the ideal privacy needed for work/study. Zoned to excellent schools and with access to world-class neighborhood amenities, this home offers a lifestyle dreams are made of.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Creek Trace At Cross Creek Ranch Sec 3, Blk 4, Lt 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '1168' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665169349' WHERE `Matrix_Unique_ID` = '213291718' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:44:19.450' ,`MLSNumber` = '76163144' ,`ListAgentFullName` = 'Somer Padilla' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.097727' ,`Longitude` = '-95.368218' ,`PhotoCount` = '24' ,`PostalCode` = '77386' ,`RoomCount` = '8' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Supremes' ,`StreetNumber` = '3815' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Showings Start Sat. 10/8. Immaculate, beautiful, and recently built in the desirable neighborhood of Harmony. Home offers an open and versatile floor plan, high ceilings with 8 ft grand doors, open kitchen with sparkling quartz counter tops, 42\' cabinets, stainless steels appliances, and refrigerator included. Gorgeous plank flooring throughout the living areas and entry. Primary bedroom suite equipped with double vanities, walk in shower and large walk in closet that connects to your laundry room. This home also has a generous size flex room that can be a study, gym, or extra bedroom. Backyard features an oversized covered patio, sprinklers, with plenty of space to play. Close proximity to dining, shopping, hospitals, and just a 2 minute bike ride to Harmony\'s amazing recreation center, The Thicket, which has an awesome splash pad, shady playground, open lawn, and a 5,100-square-foot recreation center with exercise room, meeting room, and great room for events.' ,`Acres` = '0.1475' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S213202 - ALLEGRO AT HARMONY 02, BLOCK 1, LOT 73' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Allegro At Harmony 02' ,`TaxAmount` = '8767' ,`TaxRate` = '2.9587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169350' WHERE `Matrix_Unique_ID` = '213300907' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:41:37.367' ,`MLSNumber` = '85692166' ,`ListAgentFullName` = 'Jessica Lusk' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016504' ,`Longitude` = '-95.190474' ,`PhotoCount` = '21' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '253000.00' ,`Status` = 'Active' ,`StreetName` = 'Dawn Mist' ,`StreetNumber` = '20210' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect family home on a cul-de-sac with huge, private backyard and covered patio! This 4 bed 2.5 bath home is larger than others in the neighborhood and ready for Move-In! Large Living Room with a formal Dining Room. Kitchen has stainless appliances with a Pantry and Breakfast nook. Short walk by sidewalk to a Wonderful Park with Amenities. 2022 Fresh Paint, New vinyl wood flooring installed in 2021. Backyard includes Mandarin, Peach, and Orange trees! Garage has large workshop area. Home backs up to gated community.' ,`Acres` = '0.2213' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 9 ATASCOCITA NORTH SEC 3 R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9638' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '240' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Atascocita North Sec 03' ,`TaxAmount` = '4417' ,`TaxRate` = '2.613' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169350' WHERE `Matrix_Unique_ID` = '213350425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:41:32.360' ,`MLSNumber` = '78162642' ,`ListAgentFullName` = 'Shane Krantz' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043657' ,`Longitude` = '-95.613541' ,`PhotoCount` = '44' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '359500.00' ,`Status` = 'Active' ,`StreetName` = 'Papago' ,`StreetNumber` = '19407' ,`StreetSuffix` = 'Court' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***Open House Sunday 10/9*** Come see this one-of-a-kind property in Canyon Gate at Northpointe. This is the largest lot in the neighborhood at 17,500 sq ft. That\'s right almost half of an acre and did I mention it\'s also in a cul-de-sac with easy access to 249 and Grand Parkway? Enjoy your morning coffee in your backyard retreat with the peaceful sounds of the custom water feature on your large covered back porch. Beautiful 2-story brick elevation with lush landscaping. This home is being sold by the original owner and had been meticulously maintained since 1999. The subdivision, Canyon Gate at Northpointe, is just minutes away from Vintage Park, a great area for shopping and fine dining. Community amenities include a clubhouse, pool, fitness room, covered sports court, tennis courts, children’s parks, and walking trail. Zoned to acclaimed Tomball Memorial High School in Tomball ISD. Schedule a showing today!' ,`Acres` = '0.402' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 2 CANYON GATE AT NORTHPOINTE SEC 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '17511' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CANYON POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At Northpointe' ,`TaxAmount` = '7165' ,`TaxRate` = '2.9165' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169350' WHERE `Matrix_Unique_ID` = '213351035' --> 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','213367741','1665169350','213367741','2022-10-07T07:42:17.317','22865182','Mohammed Jaber','eXp Realty, LLC','','','30.199414','-95.773954','26','77355','7','449000.00','Active','Fm 1488 Road','20215','Road','Magnolia','2','1','4','1676','Single-Family','Looking for a Corner Lot? Unrestricted Property at an Amazing Location. Only 1.3 Miles West of Magnolia with 302\' of Street Frontage. This Attractive location has Two Separate Homes Adjacent to each other. Great location for a business or for a Rental income/Investment. \r\nThe Primary spacious Brick home has 3B/2.5bath with 1,676 Sqft of living space. This Spacious home has a great layout with a huge garage that can be converted into a workshop as it sits on a solid slab. The Second home, A Newly built, the second home has 850 Sqft and it can be used for an office or to lease. A Corner lot of 25,700 Sqft on a busy road of FM-1488 has an average traffic count of 51,757 vehicles per day. Fully fenced with Two automatic gates installed on both sides of the street(1488 & Abney St), This is a Must see Home. Don\'t miss this opportunity to own this great location. Call us and Come visit today.','0.587','15','','','Washer Connections','','Sellers Disclosure','1','','1','Magnolia/1488 West','Central Electric','0','A0512 - SCOTT JOHN, TRACT 3, ACRES 0.587','Cleared','25570','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','36 - Magnolia','WILLIE E. WILLIAMS ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','No','2357','1.8587','Public Sewer,Septic Tank','1978','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:48:44.927' ,`MLSNumber` = '2523063' ,`ListAgentFullName` = 'Kay Harnden' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794070' ,`Longitude` = '-95.400312' ,`PhotoCount` = '36' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = '13th' ,`StreetNumber` = '302' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2209' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Victorian home, recently expanded to include 4 bedrooms, 3 baths, plus a garage apartment. Special features include high ceilings, original wood floors, glass front kitchen cabinets, marble counters in baths. Additional spaces include mudroom/laundry, office nook off of dining room, upstairs home office, and den off of kitchen. Situated on a corner lot on a great block - walking distance to parks and restaurants. The Heights bike trail is just a few blocks away.' ,`Acres` = '0.101' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 1B & 2B BLK 184 HOUSTON HEIGHTS' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Houston Heights' ,`TaxAmount` = '15144' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1910' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169350' WHERE `Matrix_Unique_ID` = '213373655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-07T07:31:43.497' ,`MLSNumber` = '20493332' ,`ListAgentFullName` = 'Cole Lumley' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733574' ,`Longitude` = '-95.407973' ,`PhotoCount` = '49' ,`PostalCode` = '77098' ,`RoomCount` = '10' ,`ListPrice` = '899900.00' ,`Status` = 'Active' ,`StreetName` = 'Portsmouth' ,`StreetNumber` = '1946' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'For a well-built, meticulously maintained home in a great location with all the luxuries, modern conveniences & finishes one desires, look no further. Features include an elevator, wood flooring, two outdoor living spaces, and much more. The kitchen includes a commercial range, leathered soapstone counters, ample cabinet space, and open to the living room. The airy primary bedroom consists of a wine/coffee bar w/sink, sitting area, tray ceilings, a large walk-in closet, and abundant natural light. The primary bath has his/her sinks, jetted tub, a separate shower, and ample storage cabinets. The capacious living area offers beautiful wooden ceiling beams, a gas log fireplace, built-in shelving, & views of the backyard. All spacious guest rooms have en-suite baths & walk-in closets. The study & game room are located up. Enjoy relaxing on 1 of 2 private patio spaces, w/ one located on the ground level & the other on the third floor, with an outdoor fireplace & excellent views of downtown.' ,`Acres` = '0.0709' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 LANDING ON PORTSMOUTH' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '3088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'French,Traditional' ,`Subdivision` = 'Landing on Portsmouth' ,`TaxAmount` = '18445' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665169350' WHERE `Matrix_Unique_ID` = '213383190' --> 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','213393676','1665169351','213393676','2022-10-07T07:20:29.880','74242532','Joseph Lucco','Frank J. Lucco & Associates','','','29.626279','-95.734680','38','77406','12','437500.00','Active','Plantation','1806','Drive','Richmond','2','1','4','3237','Single-Family','WOW!! PER OWNER: ~$50K RECENTLY INVESTED INTO HOME UPGRADES IN THE PAST 2 YEARS INCLUDING:PELLA WINDOWS, CEILING FAN UPGRADES IN ALL BEDROOMS,TOP-OF-THE-LINE AC UNITS (22 SEER TRANE/ 16 SEER CARRIER), WATER HEATER, FURNACE, NEW RETURN AND DUCTWORK, FENCE EXTENSION. GOLF COURSE (HOLE #2 TEE BOX PLANTATION COURSE) WITH POOL/HEATED SPA, EXTENSIVE FLAGSTONE DECKING AND CUSTOM WATERFALL. HOME UPDATED WITH GRANITE COUNTER TOPS, PLANTATION SHUTTERS AND SPARKLING WD AND TILE FLOORING. FEATURES CAST STONE GAS LOG FIREPLACE AND HIDDEN TV ENCLOSURE IN LIVING ROOM WITH A WALL OF WINDOWS FOR ENJOYING VIEWS OF POOL/WATERFALL AND GOLF COURSE. CONCRETE TILE ROOFING, CIRCULAR DRIVE, CARPORT, COMPUTER NICHE IN UPSTAIRS BEDROOM -PERFECT FOR STUDY. MASTER BATH FEATURES FRAMELESS GLASS, LARGE WALK-IN CLOSETS WITH LOADS OF STORAGE. A REMARKABLE HOME IN AN ESTABLISHED NEIGHBORHOOD. FBISD (K-12)SCHOOLS ALL WITHIN MINUTES.LOW TAX AND HOA.. TOO MUCH TO SAY- RUNNING OUT OF SPACE.A MUST SEE PROPERTY','0.2626','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Gaslog Fireplace','1','Fort Bend County North/Richmond','Central Gas,Zoned','1','PECAN GROVE PLANTATION SEC 3, BLOCK 30, LOT 1','Corner,In Golf Course Community,On Golf Course,Subdivision Lot','11441','Appraisal District','','209','0','','2','Electric Oven','1','Gunite,In Ground','','Electric Cooktop','','Other','19 - Fort Bend','PECAN GROVE ELEMENTARY SCHOOL','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','Appointment Required,Leave Business Card','Appraisal District','2','Traditional','Pecan Grove Plantation Sec 3','8323','2.2979','Water District','1982','Appraisal District'); --> New record created successfully