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` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '48770177' ,`ListAgentFullName` = 'Patricia Savage' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668248' ,`Longitude` = '-94.997554' ,`PhotoCount` = '50' ,`PostalCode` = '77571' ,`RoomCount` = '29' ,`ListPrice` = '2400000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayridge' ,`StreetNumber` = '703' ,`StreetSuffix` = 'Road' ,`City` = 'Morgan\'s Point' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4198' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Listed on the National Register of Historic Places, the City of Morgan\'s Point and this remarkable homesite rest on a peninsula of Galveston Bay. Begun in the early 1900\'s, the community built on the \"Bayridge\" with 20-foot elevations for ultimate breezes and magnificent water views. Rebuilt in recent years in keeping with historic restrictions, this wonderful property is the product of a master with knowledge of superior building materials and access to outstanding architects and engineering firms. The home became a masterpiece. The main house reaching 3 levels has open living, 6 bedrooms, en-suite baths, a media room, terraces at 2 levels, and quarters with an elevator and 2 additional bedrooms. More than 100 linear feet of porches with water views make relaxing easy. An enormous pool and spa accompany a fully equipped summer kitchen. The two retaining walls (bulkheads), a 600-foot lighted fishing pier with oyster reef and a boat lift provide ready access to the bay. Must see!' ,`Acres` = '1.0656' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 & TR 1A BAY RIDGE PARK' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '46418' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Point' ,`TaxAmount` = '17416' ,`TaxRate` = '2.9924' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217362' WHERE `Matrix_Unique_ID` = '200504816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '90102381' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743319' ,`Longitude` = '-95.617538' ,`PhotoCount` = '32' ,`PostalCode` = '77077' ,`RoomCount` = '5' ,`ListPrice` = '439990.00' ,`Status` = 'Active' ,`StreetName` = 'Pueblo Nuevo' ,`StreetNumber` = '1931' ,`StreetSuffix` = 'Path' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live at Park & Lake Villas! Our 2298 plan has it all! Featuring 3 bedrooms and 3.5 bathrooms in an open and bright floor plan. This designer kitchen boasts 42\" linen cabinets and upgraded granite counters! The Owner\'s Suite has a garden tub, separate shower, separate double vanities and a massive closet! Beautiful Rockport grey vinyl plank flooring throughout the common areas, classic silver carpet in the bedrooms, and white ash tile in the bathrooms and utility room. This home boasts 10 ft. ceilings, staircase with wood treads, metal balusters & covered patio! Located within the bustling city of Houston, Park & Lake Villas is an oasis, just steps away from an abundance of conveniences. This private, gated community is nestled between established neighborhoods & a host of choices for dining, shopping & entertainment. Take advantage of this unique opportunity to own a new construction home offering quick access to SH 6, Westpark Tollway, I-10 and the Sam Houston Tollway.' ,`Acres` = '' ,`Area` = '31' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2298' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2160' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Park & Lake Villas' ,`TaxAmount` = '' ,`TaxRate` = '2.39' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217363' WHERE `Matrix_Unique_ID` = '201631067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '60753065' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132205' ,`Longitude` = '-95.316914' ,`PhotoCount` = '50' ,`PostalCode` = '77365' ,`RoomCount` = '8' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Great Falls' ,`StreetNumber` = '7514' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is under construction, built by Empire Communities...located in the desired master-planned community of The Highlands! You will fall in love with Empires gorgeous open concept Eastland floorplan with designer features such as high-end granite countertops, luxury vinyl plank flooring and 42\" cabinets! The open kitchen and living space offers tons of natural light and plenty of room for entertaining! 3 car tandem garage and each bedroom having its own bathroom! No backyard neighbors, spend your time relaxing on the outdoor, oversized covered patio! The Highlands offers something for everyone with amenities that include: an event lawn, fitness center, playgrounds, tennis and pickle ball courts, water-park, lazy river and recreational lakes! All with over thirty miles of walking and biking trails and an 18-hole semi-private golf course on site! The Highlands is where the beauty of nature melds seamlessly with the fulfillment of an exceptionally built Empire home!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15, Block 1, Section 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6955' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217363' WHERE `Matrix_Unique_ID` = '201987990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '36898835' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Ryan Guerrant' ,`SellingOfficeName` = 'Keller Williams Hou Preferred' ,`Latitude` = '29.659793' ,`Longitude` = '-95.056390' ,`PhotoCount` = '13' ,`PostalCode` = '77571' ,`RoomCount` = '10' ,`ListPrice` = '399965.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Clements Shore' ,`StreetNumber` = '2202' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.**Find total comfort in this charming Beazer home in Morgan’s Landing, boasting a brick façade, sloped ceilings, luxury vinyl plank flooring, a study with French doors, an open great room, and an extended covered patio. Prepare incredible feasts in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, 30” cooktop, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. Unwind in the serene primary suite, featuring dual vanities, a tub, and a separate shower. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Schools are zoned to La Porte ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.543251' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217363' WHERE `Matrix_Unique_ID` = '206447263' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '86693612' ,`ListAgentFullName` = 'Elena Garcia' ,`ListOfficeName` = 'Penny Salter Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.345232' ,`Longitude` = '-95.441137' ,`PhotoCount` = '39' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Northampton' ,`StreetNumber` = '1801' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic home on corner lot! This spacious home has a formal dining room overlooking the front yard, Large gameroom for family game nights, covered back patio for entertainment and much more. The Family room has windows that overlook the backyard. New stove and microwave. Home has zoned A/C. Home is ready for move-in. So much home for the price.' ,`Acres` = '0.1805' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S215802 - ARBOR PLACE 02, BLOCK 1, LOT 109' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7863' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Arbor Place 02' ,`TaxAmount` = '5427' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217363' WHERE `Matrix_Unique_ID` = '207160743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '72828844' ,`ListAgentFullName` = 'Donna Mitchell' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.964349' ,`Longitude` = '-95.270646' ,`PhotoCount` = '24' ,`PostalCode` = '77541' ,`RoomCount` = '6' ,`ListPrice` = '790000.00' ,`Status` = 'Active' ,`StreetName` = 'Spoonbill Place' ,`StreetNumber` = '103' ,`StreetSuffix` = '' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Turn-key ready beachside home in the heart of Surfside Beach with amazing ocean and bay views, beach access just steps away by community walkover and much more. This house has it all, from large custom cabinetry and built-ins throughout, stainless LG appliances, quartz countertops, vinyl plank floors, louvered surround garage for golf cart and beach gear, downstairs shower and expansive decks/balconies on first and second levels to enjoy the sun rising and setting. Open living/dining/kitchen concept, large utility room and full bath on first level with three bedrooms and full bath on second level. This house comes fully furnished with a lovely beach vibe. Let the sound of the waves carry the stress of the day away as you enjoy the wrap around deck off the bedrooms. Come take a look today … It is ready and waiting for YOU!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'RM Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SUNNY BEACH (A0009 B T ARCHER DIV 1 (B C I C)) (SURFSIDE)' ,`LotDesciption` = 'Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'SUNNY BEACH' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217363' WHERE `Matrix_Unique_ID` = '207433958' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '68485430' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.492608' ,`Longitude` = '-95.386226' ,`PhotoCount` = '50' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '644990.00' ,`Status` = 'Active' ,`StreetName` = 'Limestone Terrace' ,`StreetNumber` = '4222' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 5049 Plan. Beautiful 2-story stucco exterior, 3-car garage, with 5 bedrooms, 4 baths! 2 Bedrooms down. 19\' Ceiling at Dining and Great Room. Luxury vinyl plank flooring downstairs, with plush carpet only in bedrooms and tile in the laundry room and bathrooms. The kitchen boasts a built-in oven and microwave tower, a 5-burner gas cooktop and an oversized island with granite countertop. Master suite has a bay window, a huge walk-in closet, double sinks, separate glass framed shower and a drop-in garden tub. Study enclosed with French doors. And, saving the best for last, a stacking sliding door faces the lake and opens up your Dining and Great Room to the oversized outdoor living area that wraps around the home, with an entertainment bar featuring a pass through window! Upstairs has unbelievable, generously-sized bedrooms, 2 baths and a game room. Come live the difference!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 1, Section 6' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '8100' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.638696' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217364' WHERE `Matrix_Unique_ID` = '207723768' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '94641711' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.494364' ,`Longitude` = '-95.389260' ,`PhotoCount` = '46' ,`PostalCode` = '77578' ,`RoomCount` = '11' ,`ListPrice` = '464990.00' ,`Status` = 'Active' ,`StreetName` = 'Whitney Crest' ,`StreetNumber` = '4338' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shea Homes 4059 Plan. Beautiful 2-story brick, with 4 bedrooms, 3 baths. High ceilings at the entry and Great Room. Luxury vinyl plank flooring throughout first floor, with plush carpet only in bedrooms, game room and tile in the laundry room and bathrooms. The kitchen boasts a 5-burner gas cooktop and nice island with beautiful quartz countertops in the kitchen, granite in the primary bath. Primary suite has a bay window, a generous walk-in closet, double sinks, separate glass framed shower and a drop-in garden tub. Come live the difference!' ,`Acres` = '0.1959' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23, Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6253' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'E C MASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Bello Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.638696' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217364' WHERE `Matrix_Unique_ID` = '208730479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '89603084' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Brandell Flores' ,`SellingOfficeName` = 'Equity First Realty Partners, LLC' ,`Latitude` = '29.756115' ,`Longitude` = '-95.899731' ,`PhotoCount` = '34' ,`PostalCode` = '77423' ,`RoomCount` = '17' ,`ListPrice` = '669572.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sonora Ridge' ,`StreetNumber` = '30731' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY!! Westin Homes NEW Construction (Asher V, Elevation A) Two story. 5 bedrooms. 4.5 baths. Elegant double front door entry, family room, informal dining room and study. Spacious island kitchen open to family room. Primary suite with large double walk-in closets and secondary bedroom on first floor. Three additional bedrooms, spacious game room and media room on second floor. Attached 3-car tandem garage. Small Town. Big Amenities. At Jordan Ranch they are giving good old-fashioned fun a stylish upgrade! Whether you’re making new friends at The Hub or floating the day away in the Lazy River- there’s something for everyone. The Director of Fun has a wide range of activities on the calendar all year long, so you’re free to “live it up” to your heart’s content. Stop by the Westin Homes model home to find out more about Jordan Ranch.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5 BLK 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9096' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.27' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217364' WHERE `Matrix_Unique_ID` = '208731012' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '32897189' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.659537' ,`Longitude` = '-95.056372' ,`PhotoCount` = '17' ,`PostalCode` = '77571' ,`RoomCount` = '13' ,`ListPrice` = '433522.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Clements Shore' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Enjoy working from home in this beautiful Beazer Home in Morgan’s Landing, boasting a brick façade, tile flooring, wrought iron spindles, a fireplace, a study with French doors, an open great room, and an extended covered patio. Entertain your guests in the kitchen, equipped with quartz countertops, mosaic backsplash, 30” cooktop, stainless steel appliances, pendant lighting, and under-counter lighting. Seek comfort in the tranquil primary suite, featuring dual vanities and a mud set shower. Located in La Porte, this community gives residents easy access to Kemah, the Houston Ship Channel, and Bay Area. Clear Lake and the Johnson Space Center are just minutes away! Morgan’s Landing’s amenities include a dog park, resort-style pool, pocket parks, lakes, and walking trails. Schools are zoned to La Porte ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 37 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgan\'s Landing' ,`TaxAmount` = '' ,`TaxRate` = '3.76904' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217364' WHERE `Matrix_Unique_ID` = '208980333' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '32286404' ,`ListAgentFullName` = 'Erica O\'Quin' ,`ListOfficeName` = 'Synmark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.511568' ,`Longitude` = '-95.822961' ,`PhotoCount` = '32' ,`PostalCode` = '77471' ,`RoomCount` = '4' ,`ListPrice` = '339900.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Floor Court' ,`StreetNumber` = '2214' ,`StreetSuffix` = '' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2463' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on the Market and price adjusted to market!! Welcome to the perfect home! Great location right off of US 59 close to restaurants, shopping, and much more. New Schools in expanding school districts with competitive salaries for individuals in education and nearby hospitals for medical field workers! This beautifully well-maintained home is a rare find in this current market. Built on a corner lot of a cul-de-sac. Brand new roof, covered patio, and large front and back yard space. This home is spacious as it has formal dining and a great kitchen open to the living room with views of the front and backyard. First floor master with on suite that has a separate tub/ shower, dual vanity, and large walk-in closet space. There are 3 bedrooms upstairs as well as a spacious game room, laundry room, and linen closet. This home is move-in ready with stainless steel appliances including a refrigerator, washer, and dryer!!!! Enjoy the neighborhood park, walking trails, and community lake.' ,`Acres` = '0.1606' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FAIRPARK VILLAGE SEC 7, BLOCK 3, LOT 24' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '6995' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'CULVER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Fairpark Village Sec 7' ,`TaxAmount` = '7250' ,`TaxRate` = '3.2048' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217365' WHERE `Matrix_Unique_ID` = '208981092' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '93785952' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743319' ,`Longitude` = '-95.617538' ,`PhotoCount` = '35' ,`PostalCode` = '77077' ,`RoomCount` = '5' ,`ListPrice` = '479990.00' ,`Status` = 'Active' ,`StreetName` = 'Pueblo Nuevo' ,`StreetNumber` = '1943' ,`StreetSuffix` = 'Path' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your Modern New Home is only minutes away from anywhere you want to be at Park & Lake Villas. The first level has an impressively spacious third bedroom or optional study with powder. The second level opens up to a magnificent family room coupled with the kitchen and dining area. The natural light coming from the balcony shines a light on the latest fashion of hardwood flooring. Your amazing new kitchen is decorated with 42” Charleston Beech Square Espresso cabinets, coastal white granite countertops with arctic white backsplash. Secluded away on the 3rd level is your grand owner’s suite and secondary bedroom with full bath. Your new Owner’s Bath flaunts large Modern Hearth Tiles across the floor and separate beautiful vanities with a large walk-in shower or grand tub. The private walk-in closet is amazing! You will love the convenience of this quaint new Houston community surrounded by a variety of recreational activities. You’ll love this home!' ,`Acres` = '' ,`Area` = '31' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2330' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2160' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Park & Lake Villas' ,`TaxAmount` = '' ,`TaxRate` = '2.39' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217365' WHERE `Matrix_Unique_ID` = '209023499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '7238015' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132511' ,`Longitude` = '-95.316501' ,`PhotoCount` = '40' ,`PostalCode` = '77365' ,`RoomCount` = '11' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Great Falls' ,`StreetNumber` = '21821' ,`StreetSuffix` = 'Court' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2388' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Our popular Archer one-story is a must-see! This home features three bedrooms, a study and a private owner’s retreat. A cast stone fireplace is the perfect centerpiece for your open living and dining space. Designer selections throughout including modern 42’ cabinetry, quartz countertops and 8’ interior doors! The owner’s retreat is Pinterest worthy featuring high vaulted ceilings complimented with wood accent beams and tons of natural light! The owner’s bath includes trendy 12x24 tile, oversized his and hers walk-in-closets, a garden tub and mud set shower. The Highlands caters to all lifestyles with an array of nature-inspired amenities including an 18-hole golf course, resort pool, water park and lazy river, fishing and kayaking lakes, recreation field, 30 miles of hiking and biking trails, fitness center and more. The Highlands is where the beauty of nature melds seamlessly with the fulfillment of an exceptionally built Empire home!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217365' WHERE `Matrix_Unique_ID` = '209631788' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '8750912' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Newmark Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.722444' ,`Longitude` = '-95.874943' ,`PhotoCount` = '23' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '460760.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Terrace' ,`StreetNumber` = '29022' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2022' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FRANKLIN PLAN - This one story plan offers 4 bedrooms and 3 full baths, an open floor plan featuring, a fantastic chef\'s kitchen with built-in stainless steel appliances, harbor gray cabinets, matte black hardware and elegant porcelain countertops. The vaulted family room ceiling adds a wall of windows and French doors that lead out to an extended covered patio. The main bathroom has double sinks, gorgeous porcelain countertops, harbor gray cabinets, with separate tub and shower. This fabulous one story plan also includes, tankless water heater, spray foam insulation, full gutter and more!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Newmark Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 04, Block 01' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6799' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric 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` = 'Leave Business Card,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217365' WHERE `Matrix_Unique_ID` = '209901496' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '20480917' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.231111' ,`Longitude` = '-95.671444' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '589990.00' ,`Status` = 'Active' ,`StreetName` = 'Mauser' ,`StreetNumber` = '40908' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3397' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Dartmouth Floor Plan! This NEW Construction 2-Story 3397 Sq Ft Floor Plan offers 4 Bedrooms, 3.5 Baths, Study, Formal Dining Room, Upstairs Game Room, 3-Car Garage! The Kitchen features Olympus Kitchen Backsplash, Granite Countertops, Oversized Kitchen Island With Post Legs & 42\" Truffle Cabinets. The Primary Suite offers Oversized Walk-in Closet, Drop-in Tub, Walk-in Shower with Shower Seat & Double Sinks. The Home is Complete with Extended Covered Patio & Sprinkler System, Classic Silver Carpet in Bedrooms, Tile in Wet Areas, Iron Wood Flooring in Main Areas. Will be Ready for a November Move-in!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18, Block 3, Section 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16955' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Manor Reserve' ,`TaxAmount` = '' ,`TaxRate` = '1.86' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217365' WHERE `Matrix_Unique_ID` = '210710071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '4635316' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Ricardo Gonzalez' ,`SellingOfficeName` = 'RE/MAX The Woodlands & Spring' ,`Latitude` = '30.235733' ,`Longitude` = '-95.709144' ,`PhotoCount` = '39' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '287815.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'BLACKBRUSH MANOR' ,`StreetNumber` = '14731' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exceptional Open Concept 1 story home with 4 Bedrooms!! Features Include Open Concept living w/large dining room open to family room & kitchen! Primary bathroom suite offers huge walk in closet! Features include 30\" Flat panel maple cabinets w/crown molding, exotic granite, 4 burner gas cooktop w/SS appliances, tile wall surrounds in bathrooms, smart home system, full sprinklers, front & back sod, fully front landscape, tankless water heater, LED lighting and more! Large covered patio overlooks the PRIVATE backyard with so much room for a pool! Mill Creek Offers 50\' wide lots! Call us today to schedule your showing!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'DR Horton/ EXPRESS' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '28/1/2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217366' WHERE `Matrix_Unique_ID` = '210763734' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T02:18:32.210' ,`MLSNumber` = '784879' ,`ListAgentFullName` = 'Obed Romero' ,`ListOfficeName` = '2M Realty Advisors, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080643' ,`Longitude` = '-95.457575' ,`PhotoCount` = '35' ,`PostalCode` = '77388' ,`RoomCount` = '4' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Hannover Valley' ,`StreetNumber` = '2415' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home on Hannover Village Subdivision close to The Gran Parkway and I-45 Zoned to Klein ISD and close to plenty shopping, dining and entertainment\r\nThis home offer open concept living room-upgraded kitchen with Granite countertops and stainless-Steel appliances\r\n perfect for entertaining, formal dining and office.\r\nUpstairs you will find a large game room with four bedroom and two full bathrooms. The inviting backyard offer covered patio and full landscaping with sprinkler system. Home never flooded.' ,`Acres` = '0.1452' ,`Area` = '14' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 2 HANNOVER VILLAGE SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '6325' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KREINHOP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Hannover Village Sec 03' ,`TaxAmount` = '6736' ,`TaxRate` = '2.804' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217366' WHERE `Matrix_Unique_ID` = '210816096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '11791951' ,`ListAgentFullName` = 'Chunlou Li' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.052773' ,`Longitude` = '-95.560753' ,`PhotoCount` = '26' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '323400.00' ,`Status` = 'Active' ,`StreetName` = 'Ringwald' ,`StreetNumber` = '19710' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'First owner & Well maintained; 4-bed/2.5-bath; master planned Gleannloch Farms community; Zoned to recognized schools. Easy access to highway 249 & highway 99. Neighborhood offers lots of community facilities for you to fully enjoy your life, walking trails, community pools, tennis courts, and fitness center. \r\n~Brand new carpet; ~cul de sac lot with room for a pool; ~Light and bright; ~Crown molding in family and dining rooms; ~Plenty of storage with separate closets in master; ~Side entry door in garage leading to backyard; ~Washer/Dryer & refrigerator included' ,`Acres` = '0.1567' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 3 GLEANNLOCH FARMS SEC 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FRANK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Gleannloch Farms Sec 23' ,`TaxAmount` = '6062' ,`TaxRate` = '2.7315' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217366' WHERE `Matrix_Unique_ID` = '211075583' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '19058164' ,`ListAgentFullName` = 'Shadrick Bogany' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.532041' ,`Longitude` = '-95.409082' ,`PhotoCount` = '35' ,`PostalCode` = '77578' ,`RoomCount` = '9' ,`ListPrice` = '459900.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Crest' ,`StreetNumber` = '4329' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2589' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Awesome Perry home in Pomona is 2589 Plan is only 6 months and barely lived in. The seller has had a sudden job transfer. It has a formal foyer with a high ceiling and a very open floorplan and 8-foot doors throughout the home. A nice guest split from the rest of the Bedrooms. Stunning kitchen and everything seems to flow. Large Master with a large walk-in closet and 6-foot tub. This home just has class throughout. With a large covered 24x9 Patio and no neighbors behind you. Stunning elevation and sprinkler system. Why wait to build a home, You can enjoy Ponoma now.' ,`Acres` = '0.1451' ,`Area` = '5' ,`BuilderName` = 'Perry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 12 (A0298 HT&BRR) BLK 3 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6321' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pomona Sec 12' ,`TaxAmount` = '2313' ,`TaxRate` = '3.7194' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675217366' WHERE `Matrix_Unique_ID` = '211197506' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '15386953' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = 'Leo Ako-Mbo' ,`SellingOfficeName` = 'Keller Williams Signature' ,`Latitude` = '29.749591' ,`Longitude` = '-95.883662' ,`PhotoCount` = '35' ,`PostalCode` = '77423' ,`RoomCount` = '18' ,`ListPrice` = '669937.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cherry Vine' ,`StreetNumber` = '29822' ,`StreetSuffix` = 'Road' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in Ready! Westin Homes NEW Construction (Carter VI, Elevation KP) Two Story. 5 bedrooms, 4.5 baths. Private Primary Suite with spacious double walk-in closets downstairs. Formal Dining Room and Study with Spacious Kitchen and breakfast area open to Family Room. Spacious Game Room upstairs with private Media Room. Extended covered patio and attached 2 car garage. Small Town. Big Amenities. At Jordan Ranch they are giving good old-fashioned fun a stylish upgrade! Whether you’re making new friends at The Hub or floating the day away in the Lazy River- there’s something for everyone. The Director of Fun has a wide range of activities on the calendar all year long, so you’re free to “live it up” to your heart’s content. Stop by the Westin Homes model home to find out more about Jordan Ranch.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8366' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.27' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217367' WHERE `Matrix_Unique_ID` = '211210377' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '76833629' ,`ListAgentFullName` = 'Debora Donaldson' ,`ListOfficeName` = 'Keller Williams Realty Austin' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.020495' ,`Longitude` = '-98.048628' ,`PhotoCount` = '39' ,`PostalCode` = '78676' ,`RoomCount` = '3' ,`ListPrice` = '800000.00' ,`Status` = 'Active' ,`StreetName` = 'Rancho Grande' ,`StreetNumber` = '501' ,`StreetSuffix` = 'Drive' ,`City` = 'Wimberley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Have you been looking for a unique spot tucked away from it all. Come tour 501 Rancho Grande. This home is built among the trees just outside Wimberley. This home includes a Art Studio, Greenhouse, raised bed garden, Workshop, RV port and carport all situated on 2.6 acres. There was a lot of thought and care put into the building and maintaining of this property. Features include 2 masonry fireplaces, Cedar wood railings from Camp wood, cedar mantels from the property, wrap around deck with hot tub and fire pit, covered porch and don\'t miss the safe room in Art Studio. HVAC in house and primary bath were replaced in 2017. This open concept plan includes an island kitchen, propane range, custom cabinets and granite counters. Laundry room includes sink and extra storage. Primary bedroom suite boasts a wood burning fireplace with propane, 2 walk-in closets, walk-in shower and double vanity. Property has some views off the deck.' ,`Acres` = '2.6' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Propane,Wall Heater' ,`HOAMandatory` = '1' ,`Legal` = 'RANCHO GRANDE LOT 32 2.60 AC GEO#90620912' ,`LotDesciption` = 'Wooded' ,`LotSize` = '113256' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '264 - Wimberley' ,`SchoolElementary` = 'JACOB\'S WELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WIMBERLEY HIGH SCHOOL' ,`SchoolMiddle` = 'DANFORTH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Rancho Grande' ,`TaxAmount` = '5069' ,`TaxRate` = '1.6909' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217367' WHERE `Matrix_Unique_ID` = '211313075' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '21355357' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.223206' ,`Longitude` = '-95.779433' ,`PhotoCount` = '39' ,`PostalCode` = '77354' ,`RoomCount` = '8' ,`ListPrice` = '349948.00' ,`Status` = 'Active' ,`StreetName` = 'Wandering Brook' ,`StreetNumber` = '1109' ,`StreetSuffix` = 'Street' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1712' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located in the newly developed community of Escondido, this beautiful 4 bedroom, 2 bathroom, 1-story home features an amazing open floor plan! Beautiful ceramic tile flooring paves your way throughout the home and the gourmet kitchen boasts 42\" cabinets, granite countertops and stainless-steel appliances which are perfect for any family. The large primary suite features a garden tub, separate shower and a large walk-in closet. The Texas-sized covered patio overlooking the spacious yard is perfect for entertaining and enjoying Texas sunsets.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Escondido' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217367' WHERE `Matrix_Unique_ID` = '211472418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '10286313' ,`ListAgentFullName` = 'Eric Gage' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.300005' ,`Longitude` = '-94.785427' ,`PhotoCount` = '29' ,`PostalCode` = '77550' ,`RoomCount` = '9' ,`ListPrice` = '689000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue L' ,`StreetNumber` = '1726' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1684' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Schedule your showing today on this beautiful and rare find on the Galveston East End. Located blocks from the Beach, UTMB and The Historic Strand. This Victorian style home that blends with the neighborhood but the newest constructed home on the block. The 3 bedroom, 2.5 bathroom with high-end finishes that will surely please the new owner. The garage is tandem allowing multiple use and plenty of storage. Home is perfect for that buyer who enjoys entertaining. Kitchen/Dining combo that offers a large island/breakfast bar, with an option to open the room to the back-covered area. Living area offers a beautiful dry bar for living room entertaining. The home utilizes a tankless water heater and smart temperature controlled AC. Beautifully restored hardwood floors throughout the home that gives you the historical feel. Third floor is where you will find the bedroom suites, full bathrooms and stackable washer/dryer closet. The Seller is looking forward to welcoming you home!' ,`Acres` = '0.0515' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOTS 13 & 14 (14-2) BLK 77 GAL' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2244' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '6752' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217367' WHERE `Matrix_Unique_ID` = '211483117' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '13434597' ,`ListAgentFullName` = 'Wendy Oxman' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.800218' ,`Longitude` = '-95.463022' ,`PhotoCount` = '48' ,`PostalCode` = '77055' ,`RoomCount` = '10' ,`ListPrice` = '984000.00' ,`Status` = 'Active' ,`StreetName` = 'Teluco' ,`StreetNumber` = '6405' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3698' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction!2022 Luxurious, Modern Farmhouse sophisticated simplicity by Avenue Drive Homes. Amazing home offers chic,contemporary design with high ceilings and a spacious entry. Open concept home that focuses on luxury and comfort. Impressive Gourmet Kitchen w designer fixtures & custom cabinetry. Long white quartz island. Stainless steel Gas Range w pot filler and Wine/ Beverage Refrigerator adorn the Great Room. So much Storage! Oversized utility Room with designer refrigerator and multiple Overflow Pantries and closet for storage. Enjoy every evening in a Stylish Primary Bedroom that displays wood beams mounted in High Ceilings. Primary Bathroom features long glass walled Double Shower & Freestanding, White Tub. Enormous! Walk-In His and Her Closets. All Bedrooms have private attached Bathrooms. Upstairs,l find a 2nd Living Area w a corner granite built-in Homework Bar. Bonus Bedroom#3 has 2 huge Walk-In Closets, Covered outdoor patio.Yard has plenty of room for a pool!' ,`Acres` = '0.1865' ,`Area` = '24' ,`BuilderName` = 'Avenue Drive Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 23 WESTVIEW TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3698' ,`Style` = 'Other Style' ,`Subdivision` = 'Westview Terrace Sec 02' ,`TaxAmount` = '8122' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217368' WHERE `Matrix_Unique_ID` = '211854569' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '9744600' ,`ListAgentFullName` = 'Tiffany Wells' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.337117' ,`Longitude` = '-95.057962' ,`PhotoCount` = '39' ,`PostalCode` = '77327' ,`RoomCount` = '4' ,`ListPrice` = '363880.00' ,`Status` = 'Active' ,`StreetName` = 'Alpine Aster' ,`StreetNumber` = '30103' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2325' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The 2 story \"Allenbrook\" designed home offers 3 bedrooms with option of fourth and 2.5 baths. Grand kitchen with large island, opening up to dining and living area. Samsung Stainless steel appliance, 36\" designer cabinets with crown molding. Under counter lighting. Granite countertops throughout. Oil rubbed hardware. Raised panel interior doors. 5\" baseboards. Landscape package offers sod in front, side & backyard. Covered back patio. Finished out painted garage with Wayne Dalton garage door . 16 Steer TRANE HVAC. Low-e windows. Programable thermostat. PEX plumbing. All homes come with 1 year craftsmanship, 2 year mechanical and 10 year structural warranty. Sleek finishes with modern touches. GRAND OAKS RESERVE! A brand new 600+ ACRE MASTER-PLANNED COMMUNITY. State-of-the-art Community Center that will include a Grand Ball Room, Conference Room, Pro Golf Shop, and bistro-style restaurant which will wonderfully compliment the GOLF COURSE, POOL, DOG PARK, and WALKING TRAIL amenities.' ,`Acres` = '0.1864' ,`Area` = '52' ,`BuilderName` = 'Mckinley' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND OAKS RESERVE, SEC 2, BLOCK 1, LOT 13, ACRES .1864' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '8120' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Oaks Reserve' ,`TaxAmount` = '623' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217368' WHERE `Matrix_Unique_ID` = '211867466' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '36254689' ,`ListAgentFullName` = 'Christopher Case' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827697' ,`Longitude` = '-95.451502' ,`PhotoCount` = '36' ,`PostalCode` = '77018' ,`RoomCount` = '4' ,`ListPrice` = '639900.00' ,`Status` = 'Active' ,`StreetName` = 'Saxon' ,`StreetNumber` = '2206' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2151' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'No Flooding- Welcome home to this absolute show stopper in the sought after subdivision of Oak Forest! Not a dollar was spared on this floor-to-ceiling renovation. This 4 Bedroom/2 Full Bath home features high end finishes & tasteful designs throughout. The home was stripped to the studs & transformed into a modern marvel. The upgrades include, but not limited to; Stucco exterior, new flooring throughout, all new kitchen, bathrooms, HVAC, plumbing, modern double front doors, wet bar, energy efficient windows & much more. As you enter the home you will notice the vaulted ceilings, w/custom tray designs & contemporary light fixtures. Floating vanities, w/ modern gold accents in master bath, along w/ a free standing soaking tub and separate shower with custom panel. Secondary bath features two large shower heads & custom back lit mirror. There is a private \"man cave/she shed\" in the back, which works as a perfect flex space for privacy. Don\'t miss this one- schedule your showing today!' ,`Acres` = '0.1619' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 18 & 19A BLK 11 OAK FOREST SEC 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7053' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 14' ,`TaxAmount` = '11337' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217368' WHERE `Matrix_Unique_ID` = '212081861' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '72596084' ,`ListAgentFullName` = 'Carolina Purnell' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.743124' ,`Longitude` = '-95.601756' ,`PhotoCount` = '37' ,`PostalCode` = '77077' ,`RoomCount` = '11' ,`ListPrice` = '474000.00' ,`Status` = 'Active' ,`StreetName` = 'Round Lake' ,`StreetNumber` = '1834' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3584' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICED TO SELL! Wonderful well maintained and NEVER FLOODED home in the Energy Corridor. This spacious home was built with entertaining in mind. You will love the open concept. First floor have a private study/office room with French doors. A owner’s retreat with a luxurious bath. The kitchen open to the family room boasts a beautiful fireplace as a focal point. The family room is also connected to a huge game room with a wet bar and a pool table perfect to entertain family and friends. The upstairs features two nice sized guest bedrooms with a Jack-and-Jill bathroom , a family room and a huge flex room that could be used as a media room or a 4th bedroom. Enjoy the neighborhood pool, playground and tennis court just a short walk from the home. The sellers have just updated this house with NEW FLOORING on the first floor. This is definitely a move in ready with fabulous location.' ,`Acres` = '' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lt 9 BLK 4 Ashford Hollow Sec 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Hollow' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217368' WHERE `Matrix_Unique_ID` = '212244293' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '95349852' ,`ListAgentFullName` = 'Walter Bering' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764621' ,`Longitude` = '-95.422688' ,`PhotoCount` = '49' ,`PostalCode` = '77007' ,`RoomCount` = '25' ,`ListPrice` = '3950000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenwood' ,`StreetNumber` = '305' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '7180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on a .5+ acre lot in Glen Cove addition, this Mediterranean style home boasts the resort lifestyle within walking distance of Memorial Park. Constructed by Croix Custom Homes in 2013 with an array of amenities, including: soaring ceilings, premium finishes, downstairs primary suite, built-in elevator shaft, generator installed, Crestron smart system and infinity edge pool. Enter the gated front courtyard into a spacious foyer which flows seamlessly to living and dining areas. The open entertaining areas are complimented by a wet bar and wine grotto. Spacious kitchen with huge island and state of the art appliances. First floor luxurious primary bedroom suite with spectacular views to the back yard pool and garden. Option for a downstairs guest suite, or second office. Outdoor kitchen with grill and covered patio. 3-Car garage with motor court and additional parking in front. Located in the \"sweet spot\" of the Inner Loop within minutes of downtown and the Galleria area. Lovely!' ,`Acres` = '0.5983' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Memorial Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 2 (OMITTED LND*0690420020042 YRS 2012-13) GLEN COV' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '26060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Heated' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Glen Cove' ,`TaxAmount` = '80245' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217369' WHERE `Matrix_Unique_ID` = '212343540' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '84504652' ,`ListAgentFullName` = 'Caroline Schlemmer' ,`ListOfficeName` = 'Compass RE Texas, LLC Heights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730017' ,`Longitude` = '-95.782702' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '1089000.00' ,`Status` = 'Active' ,`StreetName` = 'Colonial Park' ,`StreetNumber` = '5202' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Resort style living at it’s finest in this 55+ Cinco Ranch\r\ncommunity. Located on a 15,000+ sf lot complete with everything you\r\ncould imagine for outdoor entertaining- heated pool with slide, rock boulders with\r\nwater features, spa, outdoor kitchen with bar and fireplace plus an additional\r\nbeautifully landscaped fenced yard space for pets & gardening. Inside is\r\nequally impressive where no expense was sparred in transforming this home\r\nduring the 2018 renovation into a dream home with hill country vibes and custom\r\nfinishes throughout. Some other noteworthy updates include: reclaimed white\r\npine hardwood floors, pex plumbing, re-designed kitchen with an amazing center\r\nisland, beamed & vaulted ceiling, limestone fireplace, built-in audio system,\r\ncustom built bar, primary suite with a jaw-dropping spa-like bath. Three\r\nbedrooms (including private casita) plus a study. This one-of-a-kind home truly\r\nmust be seen to appreciate the incredible attention to detail and custom finishes.' ,`Acres` = '0.2792' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 1 + Reserve B, Cinco Ranch West Sec 30' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,In Golf Course Community,Subdivision Lot' ,`LotSize` = '15291' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '289' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GRIFFIN ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cinco Ranch West' ,`TaxAmount` = '11350' ,`TaxRate` = '2.6245' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217369' WHERE `Matrix_Unique_ID` = '212358707' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '17605890' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.917602' ,`Longitude` = '-95.102040' ,`PhotoCount` = '18' ,`PostalCode` = '77532' ,`RoomCount` = '9' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Topside' ,`StreetNumber` = '1903' ,`StreetSuffix` = 'Court' ,`City` = 'Newport' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! The Rio Grande by CastleRock Communities is an open concept plan with a dramatic 2-story ceiling in the family room, 4 bedrooms, 2 1/2 baths, private study, game room, and 3 car garage! The huge eat-in kitchen features upgraded quartz counter tops, under mount stainless sink, upgraded 42\" cabinets, and stainless GE appliances! The main living areas boast Rigid Core flooring that is beautiful and durable! High-end upgraded black iron rails on the staircase! The primary bedroom is located on the first floor with a separate soaker tub & shower and a walk-in closet! Enjoy nature and family time in Newport with boat access to Lake Houston, beach area on San Jacinto River, swimming pool, splash pad, hike and bike trails, tennis courts, golf course, and multiple pocket parks spread throughout the community! CastleRock Communities has builder backed 2/10 year warranty on all homes!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric,Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1, Block 5, Section 4' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '9775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Newport' ,`TaxAmount` = '' ,`TaxRate` = '3.44' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217369' WHERE `Matrix_Unique_ID` = '212365560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '91097932' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.937240' ,`Longitude` = '-95.077611' ,`PhotoCount` = '17' ,`PostalCode` = '77532' ,`RoomCount` = '9' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Wake' ,`StreetNumber` = '17703' ,`StreetSuffix` = 'Court' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! The Rio Grande by CastleRock Communities is an open concept plan with a dramatic 2-story ceiling in the family room, 4 bedrooms, 2 1/2 baths, private study, game room, and 3 car garage! The huge eat-in kitchen features upgraded quartz counter tops, under mount stainless sink, upgraded 42\" cabinets, and stainless GE appliances! The main living areas boast Rigid Core flooring that is beautiful and durable! High-end upgraded black iron rails on the staircase! The primary bedroom is located on the first floor with upgraded modern tile in the master bath, including a separate soaker tub & shower, as well as a walk-in closet! Extended covered patio! Enjoy nature and family time in Newport with boat access to Lake Houston, beach area on San Jacinto River, swimming pool, splash pad, hike and bike trails, tennis courts, golf course, and multiple pocket parks spread throughout the community! CastleRock Communities has builder backed 2/10 year warranty on all homes!' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric,Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13, Block 3, Section 6' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '9450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Newport' ,`TaxAmount` = '' ,`TaxRate` = '3.44' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217369' WHERE `Matrix_Unique_ID` = '212366355' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '64805780' ,`ListAgentFullName` = 'Alma Puerto' ,`ListOfficeName` = 'Texas Fast Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361604' ,`Longitude` = '-95.623868' ,`PhotoCount` = '10' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '193000.00' ,`Status` = 'Active' ,`StreetName` = 'W Juneau' ,`StreetNumber` = '16976' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '999' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a great corner lot, 2-story home. Currently under construction, approximate Completion 15-NOV-2022. Perfect time to choose/add your finishing touches. * Pictures are from similar floor plan. Actual house may vary' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = 'Rolu Construction LL' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE CONROE VILLAGE, BLOCK 16, LOT 65' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Village' ,`TaxAmount` = '146' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217370' WHERE `Matrix_Unique_ID` = '212410048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '34990158' ,`ListAgentFullName` = 'Alma Puerto' ,`ListOfficeName` = 'Texas Fast Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.361585' ,`Longitude` = '-95.623958' ,`PhotoCount` = '8' ,`PostalCode` = '77316' ,`RoomCount` = '3' ,`ListPrice` = '193000.00' ,`Status` = 'Active' ,`StreetName` = 'Juneau' ,`StreetNumber` = '16980' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '999' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Be the first one to live in this great new home. Almost completed. Still time to bring your final touches. Come and make this your Home. * Pictures are from similar floor plan. Actual model may vary.' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = 'Rolu Construction LL' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S660300 - LAKE CONROE VILLAGE, BLOCK 16, LOT 66' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Conroe Village' ,`TaxAmount` = '146' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217370' WHERE `Matrix_Unique_ID` = '212410386' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '89352784' ,`ListAgentFullName` = 'Grace Harris' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.401502' ,`Longitude` = '-95.553040' ,`PhotoCount` = '23' ,`PostalCode` = '77318' ,`RoomCount` = '9' ,`ListPrice` = '339990.00' ,`Status` = 'Active' ,`StreetName` = 'Laura Lake' ,`StreetNumber` = '13018' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2084' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lakeside living community! Gorgeous 3-2-2 one story. From the moment you walk in you will be captivated with the entry and the dining room! Leading you into the lavish kitchen with 36\" White cabinets, gorgeous granite, designer kitchen backsplash, and center island w/hanging pendant lights overlooking the extra large family room! Master suite has high ceilings with a big master bath offering separate tub & shower, along with his & her vanities! Large secondary bedrooms for the kiddos with a spacious 2nd bath w/2 sinks! 2 car garage with space for SHOP AREA! Ladies bring your hubby, because he will love it! This home is equipped with faux wood blinds, garage door opener, structured wiring panel, USB outlet, Media outlets & so much more!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'KENDALL HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Clear View Estates Sec 1, Blk 1, Lt 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clear View Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.5178' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217370' WHERE `Matrix_Unique_ID` = '212551836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '16692328' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.132511' ,`Longitude` = '-95.316501' ,`PhotoCount` = '39' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '465000.00' ,`Status` = 'Active' ,`StreetName` = 'Great Falls' ,`StreetNumber` = '7517' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2543' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Victoria Plan is open of movement throughout the common\r\nareas with the privacy of the bedrooms. Featuring 4 bedrooms\r\nand 3 bathrooms, the Victoria has a spacious kitchen with a\r\nlarge island and generous dining area, a great room with\r\nfireplace and quick backyard access, and a large study. The\r\nowner’s retreat offers ample privacy and features a spa-like bath\r\nwith dual sinks and an oversized walk-in closet. With four-sided\r\nbrick and covered patio, this southern facing home is on a\r\nexclusive wooded lot that will provide afternoon and evening\r\nfiltered shade in the back. The lot will require minimal\r\nmaintenance, so that you can spend time grilling and/or\r\nrelaxing.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 31, Blk 1, Section 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6325' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.38' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217370' WHERE `Matrix_Unique_ID` = '212573442' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '43905619' ,`ListAgentFullName` = 'Paul Bice' ,`ListOfficeName` = 'BICE & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763545' ,`Longitude` = '-95.422705' ,`PhotoCount` = '46' ,`PostalCode` = '77007' ,`RoomCount` = '15' ,`ListPrice` = '3000000.00' ,`Status` = 'Active' ,`StreetName` = 'Glenwood' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '7263' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Walk to Memorial Park from your own private paradise! Luxurious California casual home situated on a stunning 21,000+/-SF wooded ravine lot. Exquisite vistas thru impressive window walls bring the outdoors in. Open floor plan makes entertaining indoor/outdoor a delight. Impressive 2 sty entry, study/library, formal dining w/stone surround fireplace. Stunning views from 2 window walls in the private 1st floor Owners Suite which also has a sitting area w/pool access & luxurious bath. Spectacular kitchen, wine room, 2nd study/exercise/flex room, theater & game room w/a balcony the width of the home. Sparkling infinity pool w/sunning areas as well as well equipped summer kitchen & peaceful relaxation areas. Immaculate organized 3 car garage w/granite topped workspace. Painstakingly upgraded - list available. Recent Savant whole home automation system, theater screen & projector & new speakers thru out. Installed Generator. An amazing property on an incredible lot. Must see to appreciate.' ,`Acres` = '0.48' ,`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` = 'Memorial Park' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 2 GLEN COVE SEC 2' ,`LotDesciption` = 'In Golf Course Community,Ravine,Subdivision Lot,Wooded' ,`LotSize` = '20908' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Glen Cove' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217371' WHERE `Matrix_Unique_ID` = '212831514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '13665585' ,`ListAgentFullName` = 'Michele Alexander' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = 'Kristi Neal' ,`SellingOfficeName` = 'C & K Properties' ,`Latitude` = '29.696114' ,`Longitude` = '-95.434623' ,`PhotoCount` = '50' ,`PostalCode` = '77025' ,`RoomCount` = '13' ,`ListPrice` = '1399000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Drummond' ,`StreetNumber` = '3715' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Meticulously maintained & tastefully decorated this stately home features a downstairs Primary en-suite, sun porch, premium Jenn-air appliances, marble counters, 2 pantries, 5 bedrooms all w/en-suite baths, huge gameroom with additional flex room, spacious patios with little yard for low-maintenance living. Large open spaces & over-sized bedrooms allow for possible multi-generational living. Centrally located in Braes Heights, this property offers an abundance of entertainment living space as well as high end finishes & details throughout. See attached features sheet for details. First floor is equipped with a grand entry, formal living & dining separated by a dual fireplace, wine/dry bar, bright kitchen open to the family room. Upstairs is a spacious gameroom with outdoor private patio, office/flex room & remaining 4 bedrooms. The entire house features wide hallways, high ceilings, 8 ft doors, & whole house generator. Close to schools, parks, YMCA and Medical Center. NEVER FLOODED!' ,`Acres` = '0.1853' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Braeswood Place' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 12A & 13 BLK 28 BRAES HEIGHTS SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Braes Heights' ,`TaxAmount` = '22861' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217371' WHERE `Matrix_Unique_ID` = '213046035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '2662204' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.231090' ,`Longitude` = '-95.671590' ,`PhotoCount` = '24' ,`PostalCode` = '77354' ,`RoomCount` = '7' ,`ListPrice` = '594990.00' ,`Status` = 'Active' ,`StreetName` = 'Westley' ,`StreetNumber` = '40967' ,`StreetSuffix` = 'Lane' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Award Winning Villanova Floor Plan! This NEW Construction 1-Story Floor Plan offers 4 Bedrooms, 3 Baths, Game Room with 3-Car Garage! The Kitchen features Santorini Arabesque Kitchen Backsplash, Aura Granite Countertops & Truffle Cabinets. The Primary Suite offers Oversized Walk-in Closet, Drop-in Tub, Frameless Shower & Double Sinks. The Home is Complete with Sprinkler System & Iron Wood Flooring in Main Areas! Will be Ready for a February/March Move-in!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20, Block 2, Section 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20290' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Manor Reserve' ,`TaxAmount` = '' ,`TaxRate` = '1.86' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217371' WHERE `Matrix_Unique_ID` = '213048882' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '50169451' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.231090' ,`Longitude` = '-95.671590' ,`PhotoCount` = '21' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '559990.00' ,`Status` = 'Active' ,`StreetName` = 'Enfield' ,`StreetNumber` = '12703' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Award Winning Yale Floor Plan! This NEW Construction 1-Story Floor Plan offers 4 Bedrooms and 3 Baths. The Kitchen features Light Moss Kitchen Backsplash, Black San Marcos Granite Countertops & 42\" Linen Cabinets. The Primary Suite offers Oversized Walk-in Closet, Drop-in Tub, Walk-in Shower with Tile Pan & Dual Shower Heads. The Home is Complete with Extended Covered Patio & Sprinkler System & Butternut Wood Flooring in Main Areas! Will be Ready for a February/March Move-in!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4, Block 5, Section 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '20760' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Manor Reserve' ,`TaxAmount` = '' ,`TaxRate` = '1.86' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217371' WHERE `Matrix_Unique_ID` = '213051302' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '38767016' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082714' ,`Longitude` = '-95.543434' ,`PhotoCount` = '16' ,`PostalCode` = '77379' ,`RoomCount` = '10' ,`ListPrice` = '369503.00' ,`Status` = 'Active' ,`StreetName` = 'Indigo Ruth' ,`StreetNumber` = '21411' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful brick 4 Bedroom, 2 1/2 Bath, Kempton floorplan with 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Dining Room, and the Master Bedroom downstairs. Upstairs you will find a Game Room, 3 Bedrooms with a full Bath. Vinyl and carpet flooring. You will love the Kitchen with lots of cabinets, recessed lighting, stainless steel appliances, and even a USB outlet. Covered Patio and Fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem Gas Tankless Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Shopping, Entertainment, and Dining are just minutes away with the Grand Parkway providing quick commutes to Tomball, Houston and The Woodlands. Easy access to TX 249 and I45. Klein ISD!' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '626' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'SCHULTZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Trace' ,`TaxAmount` = '' ,`TaxRate` = '2.87' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217371' WHERE `Matrix_Unique_ID` = '213056784' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '21258811' ,`ListAgentFullName` = 'Catherine York' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.666728' ,`Longitude` = '-95.476970' ,`PhotoCount` = '16' ,`PostalCode` = '77096' ,`RoomCount` = '10' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Willowbend' ,`StreetNumber` = '5402' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mid-Century home that has been updated. This property is a 1-story, all brick, ranch-style home with contemporary flair throughout the open and bright interior. A spacious 3/2 Westbury home with a huge backyard. The property was renovated in 2016 and is absolutely move-in ready! This home offers an open floor plan with an inviting kitchen with granite countertops. Superb floor plan for entertaining or everyday living. All rooms have been recently painted for the next buyer of this fantastic property. All info per seller' ,`Acres` = '0.2975' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 34 WESTBURY SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '12960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Westbury' ,`TaxAmount` = '8630' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217372' WHERE `Matrix_Unique_ID` = '213061915' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '52089541' ,`ListAgentFullName` = 'Gabriel Torre' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780429' ,`Longitude` = '-95.421004' ,`PhotoCount` = '33' ,`PostalCode` = '77007' ,`RoomCount` = '3' ,`ListPrice` = '570000.00' ,`Status` = 'Active' ,`StreetName` = 'Petty' ,`StreetNumber` = '5525' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2707' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A luxurious and large home full of charm & character with everything you could want including double master bedrooms with huge walk-in closets, two separate balconies, & it’s very own elevator. Perfect for anyone who has hip, knee, or back issues, or an older loved one to get up all four floors with ease & absolutely no stress. Property has just had brand new powder white granite countertops with grey vein streaks installed. Luxurious options include gorgeous, gleaming hardwood floors sprawling throughout this massive living space. Zoned Ac for separate control of multiple floors. Also comes complete with a projector & a screen that comes down from the ceiling. Has lots of large windows throughout, allowing tons of soft lights giving it a very cozy home feel. The location is impossible to beat, being less than five minutes to the Heights, Memorial Park, or Washington Avenue with all of its restaurants, bars, & lively nightlife. Only minutes from Downtown or the Galleria area.' ,`Acres` = '0.0445' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 HOMES AT PETTY STREET' ,`LotDesciption` = 'Other' ,`LotSize` = '1938' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Homes/Petty Street' ,`TaxAmount` = '10243' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217372' WHERE `Matrix_Unique_ID` = '213186517' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '12420063' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.616384' ,`Longitude` = '-95.231182' ,`PhotoCount` = '43' ,`PostalCode` = '77089' ,`RoomCount` = '5' ,`ListPrice` = '205700.00' ,`Status` = 'Active' ,`StreetName` = 'Thornlea' ,`StreetNumber` = '10514' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A fantastic find! This charming single-story home in the established Beverly Hills subdivision features 3 bedrooms, 1 full bath, & attached car garage! Inside you will find neutral paint, ceiling fans, and carpet, tile, & laminate flooring! The living room leads to a modest kitchen & breakfast room! The spacious backyard is great for entertaining and includes a deck! Zoned to Pasadena ISD, this home is near numerous parks, restaurants & shopping! Within proximity to I-45 & Beltway 8!' ,`Acres` = '0.1653' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 20 BEVERLY HILLS SEC 7 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beverly Hills Sec 07 R/P' ,`TaxAmount` = '3413' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217372' WHERE `Matrix_Unique_ID` = '213246067' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '84723539' ,`ListAgentFullName` = 'Corey Hunt' ,`ListOfficeName` = '1st Class Real Estate Elevate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.389462' ,`Longitude` = '-95.619956' ,`PhotoCount` = '41' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '642000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Island' ,`StreetNumber` = '3130' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury living on Lake Conroe in the immaculate Walden golf course community is just a few steps away! This stunning 6 bedroom, 3.5 bath updated, modern home will not last long. Walk right out your back door onto the golf course or step out of the upstairs master suite onto your private balcony to catch the sun rise with your coffee. Gorgeous custom granite counter tops in the kitchen with a smart refrigerator, built in bookshelves in the office/study., spacious master walk in shower and so much more! Walden is a pristine golf course community with so much to offer, including, pools, live music, dining and shopping, parks, tennis courts, dog parks, recreation center, marina and so much more just steps from your new home!' ,`Acres` = '0.2231' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 09, BLOCK 50, LOT 60' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '9720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Walden' ,`TaxAmount` = '8316' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217372' WHERE `Matrix_Unique_ID` = '213416247' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '76313963' ,`ListAgentFullName` = 'Barbara Camacho' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877015' ,`Longitude` = '-95.448780' ,`PhotoCount` = '37' ,`PostalCode` = '77088' ,`RoomCount` = '6' ,`ListPrice` = '307000.00' ,`Status` = 'Active' ,`StreetName` = 'Observatory' ,`StreetNumber` = '8407' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1511' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly Constructed Home Located in the Harvest Heights Subdivision. Modern Contemporary Home consist of 3/2/2, MB RR has glass in-closed shower with Designer tile, double sinks, walk in closet, 2nd RR is standard size tub and shower, Granite Tops in the home, Ceiling fans and Recess lights through out entire home. Wood Style Tiled Flooring, Double Pane Low E windows, GE Stainless Steel Appliances, Crown Molding in the Kitchen Area, Living area has open area concept that will make for entertaining a joy, Utility Room with W/D connections located in the home. Spacious Back Yard has a Covered Patio with Brick Flooring, Cedar Fence in the back for privacy, and a 36\" Mahogany Speak Easy front door, front yard has Iron Security gate, with a Double car parking driveway. 15 Min. From Downtown/25 min From IAH Airport and 20 Min from the Galleria. Many great developments and improvements in the area that makes this home a great investment for years to come.' ,`Acres` = '0.1676' ,`Area` = '11' ,`BuilderName` = 'VQZ Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 2 HARVEST HEIGHTS ANNEX SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Harvest Heights Annex Sec 01' ,`TaxAmount` = '727' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217373' WHERE `Matrix_Unique_ID` = '213511563' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '40015050' ,`ListAgentFullName` = 'Ramsey Thompson' ,`ListOfficeName` = 'IndyQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.540057' ,`Longitude` = '-95.052383' ,`PhotoCount` = '49' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '512000.00' ,`Status` = 'Active' ,`StreetName` = 'Charter Pointe' ,`StreetNumber` = '2006' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*** Update- new paint and carpet throughout the second story! Come see this grand 5 bedroom, 2-Story cul-de-sac home located in the renowned Marina Bay Park! Entering the home, you are greeted with an opulent staircase leading to the 2nd floor which boasts the 2 secondary bedrooms, 2 full bathrooms, & 2 game rooms. Downstairs, the spacious formal dining room & office/study are on either sides of the front entry. Kitchen has granite countertops, under-mount lighting, breakfast bar & large eating area. The primary bedroom is a dream with a beautiful en-suite bathroom boasting a large separate shower, jetted tub, & dual sinks. Outdoors you will find the covered patio with an exquisite pool & large hot tub. New pool heater & LED lights installed this year as well as epoxy flooring in the garage. South Shore Harbour is golf-cart friendly & boasts multiple neighborhood parks & pools, all within walking distance. Zoned to highly rated CCISD schools!' ,`Acres` = '0.2013' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 LOT 39 BLK 1 MARINA BAY PARK SEC 3' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8768' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marina Bay Park Sec 3 96' ,`TaxAmount` = '9522' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217373' WHERE `Matrix_Unique_ID` = '213521884' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '32344178' ,`ListAgentFullName` = 'Grace Carrera' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226403' ,`Longitude` = '-95.638602' ,`PhotoCount` = '50' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple Leaf' ,`StreetNumber` = '323' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW FACTOR! From the moment you drive up, you have that cozy home feeling with 2.7 acres providing plenty of privacy! This Gorgeous 1.5 story home was built 2022! Enjoy your morning coffee on the covered back porch with this stunning view. Custom Built w architectural delights in every room. The chef in your family will LOVE this kitchen open to family room boasts an enormous island great for entertaining, lots of storage, stainless appliances. Primary retreat w enough room for a sitting area, completed with en-suite bath, includes soaking tub, oversized shower w/rain head and huge closet! The open living space downstairs features beautiful cabinetry, timbered ceiling accents. Formal Dining, 4 Bedrooms down along with Formal Living/Office or flex room. Upstairs Media/Flex Room with 1 large bedroom, bathroom & closet with an island. 3 car garage w epoxy flooring, Home is in *LOW TAX RATE*NO MUD TAXES* Close to all the conveniences, yet tucked away in your own private country setting.' ,`Acres` = '2.72' ,`Area` = '15' ,`BuilderName` = 'Custom Builder' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRY FOREST 01, LOT 4, ACRES 2.720' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Greenbelt,Ravine,Subdivision Lot,Wooded' ,`LotSize` = '118483' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Forest' ,`TaxAmount` = '1719' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675217373' WHERE `Matrix_Unique_ID` = '213542321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '12788715' ,`ListAgentFullName` = 'Jean Murray' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.949061' ,`Longitude` = '-95.478603' ,`PhotoCount` = '9' ,`PostalCode` = '77066' ,`RoomCount` = '8' ,`ListPrice` = '232000.00' ,`Status` = 'Active' ,`StreetName` = 'Gracechurch' ,`StreetNumber` = '11439' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2055' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful family home with both formals (living and dining). In addition, there is a spacious family room with a fireplace. The kitchen has lots of cabinets space and includes a sunny breakfast nook. Beautiful hardwood flooring in formal living/dining rooms. Large primary bedroom with sitting area and closets. New carpet and fresh paint. Close to Beltway 8 and Interstate 45.' ,`Acres` = '0.1446' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 1 GREENFIELD VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '270' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CONLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'PLUMMER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Greenfield Village Sec 02' ,`TaxAmount` = '4813' ,`TaxRate` = '2.7553' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217373' WHERE `Matrix_Unique_ID` = '213552990' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '23594175' ,`ListAgentFullName` = 'Susana Villicana' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.721672' ,`Longitude` = '-95.588663' ,`PhotoCount` = '33' ,`PostalCode` = '77082' ,`RoomCount` = '7' ,`ListPrice` = '990000.00' ,`Status` = 'Active' ,`StreetName` = 'Louvre' ,`StreetNumber` = '3415' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious Royal Oaks Country Club Location! just remodeled, new flooring, carpet, and painted one-story home on a golf course and pool. Contemporary 4- 5 bedrooms and 4 full baths. The home has a formal dining, study, and very spacious floor plan: Granite Counters, Stainless Appliances, Luxury Home Great for corporate.' ,`Acres` = '0.2107' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 12' ,`LotDesciption` = 'Other' ,`LotSize` = '9180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Royal Oaks Country Club' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217374' WHERE `Matrix_Unique_ID` = '213558467' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T01:22:34.483' ,`MLSNumber` = '15987340' ,`ListAgentFullName` = 'Whitney Pugh' ,`ListOfficeName` = 'Legacy South Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.448949' ,`Longitude` = '-95.280073' ,`PhotoCount` = '41' ,`PostalCode` = '77511' ,`RoomCount` = '8' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 147' ,`StreetNumber` = '1263' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` =