Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:19:31.423' ,`MLSNumber` = '78309061' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886031' ,`Longitude` = '-95.058675' ,`PhotoCount` = '28' ,`PostalCode` = '77532' ,`RoomCount` = '6' ,`ListPrice` = '350990.00' ,`Status` = 'Active' ,`StreetName` = 'Sun Bear' ,`StreetNumber` = '13710' ,`StreetSuffix` = 'Court' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3045' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 6 Bedroom, 3 ½ Bath, Game Room Up, Primary Suite Down, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Luxury Vinyl Plank Flooring in Extended Entries, Dining, and Family, Tile in Restrooms, Granite Kitchen Countertops, 42” White Upper Kitchen Cabinets, Stainless Steel Appliances, Kitchen Island, Mosaic Accented Tile Backsplash, Recessed Can Lighting, Wrought Iron Stair Parts, Upgraded Lighting Package, Front Gutters, Sprinklers in Front, Dual Zone A/C, Tech Shield Radiant Barrier, Environments for Living Home, Cul de Sac Home Site, plus more…AVAILABLE JULY.' ,`Acres` = '0.1031' ,`Area` = '1' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 1 KODIAK CROSSING SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '4493' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '403' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kodiak Crossing' ,`TaxAmount` = '695' ,`TaxRate` = '3.0343' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493795' WHERE `Matrix_Unique_ID` = '207155317' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:48:05.750' ,`MLSNumber` = '24252737' ,`ListAgentFullName` = 'Jeanne Eschenfelder' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.097777' ,`Longitude` = '-95.390395' ,`PhotoCount` = '36' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Cade Hills' ,`StreetNumber` = '28122' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming one story home on large lot in gated section of Spring Trails! This is a rare find, gated section, one story, 4 bedrooms plus study and formal dining, large backyard, big covered patio with outdoor kitchen AND 3 car garage!!! This home features high ceilings, open floor plan, study with French doors, and outdoor kitchen w/ large covered patio. The kitchen is the heart of this home with open sight lines to the formal dining room, family room, breakfast nook and outdoor patio. The kitchen features soaring ceilings, SS appliances, gas cooktop and double islands. Enormous second island is perfect for serving and entertaining. Family room is full of natural light, large windows and stone fireplace. Wine Bar/Wet Bar area off of kitchen/family room.Huge utility room. Primary bedroom is spacious, plantation shutters throughout home. Recent paint and carpet (July 2022).' ,`Acres` = '0.2601' ,`Area` = '40' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S901416 - SPRING TRAILS 16, BLOCK 1, LOT 40' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11328' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Trails 16' ,`TaxAmount` = '9776' ,`TaxRate` = '2.6137' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493795' WHERE `Matrix_Unique_ID` = '208697933' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:21:44.673' ,`MLSNumber` = '17875961' ,`ListAgentFullName` = 'Susan Brock' ,`ListOfficeName` = 'Brock & Foster Real Estate' ,`SellingAgentFullName` = 'Ashley Crank' ,`SellingOfficeName` = 'Keller Williams Platinum' ,`Latitude` = '29.652566' ,`Longitude` = '-95.493470' ,`PhotoCount` = '31' ,`PostalCode` = '77035' ,`RoomCount` = '9' ,`ListPrice` = '359000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Dunlap' ,`StreetNumber` = '11606' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why rent when you can own! Entertain and live comfortably in this dream home on 10,000+ sf lot with gated drive, backyard can fit pool! Owners spared no expense on high end finishes! Phenomenal kitchen with custom cabs, Italian Marble counters, Samsung appls + wine fridge. Enjoy summer meals at breakfast bar w/views of picturesque lawn which is great for parties. Den w/vaulted ceiling & brick FP. Giant media rm ideal for movie nights or gamerm. Primary bedrm w/ oversized walk-in closet & room for huge dresser, dual sinks and spa-like shower. Features: great storage, plank tile flooring, solid wood doors, recent paint, HVAC, ducts, tankless wtr htr, elec panel, epoxied sewer lines, foundation repaired w/ lifetime warranty. Smart Home features, sprinkler sys, driveway gate & covered carport/patio. Low tax rate! Excellent location near Med Center, Downtown & Galleria. Walk through the 3D Matterport tour now!' ,`Acres` = '0.2465' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 86 PARKWEST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10736' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ANDERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwest' ,`TaxAmount` = '5048' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493796' WHERE `Matrix_Unique_ID` = '209449662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:55:04.873' ,`MLSNumber` = '60395256' ,`ListAgentFullName` = 'Toni Knis' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Christina Brewster' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.568014' ,`Longitude` = '-95.042735' ,`PhotoCount` = '26' ,`PostalCode` = '77586' ,`RoomCount` = '9' ,`ListPrice` = '310000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bayou View' ,`StreetNumber` = '434' ,`StreetSuffix` = 'Drive' ,`City` = 'El Lago' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEVER FLOODED PER SELLER. THIS TRADITIONAL HOME SITS ON A HUGE CORNER LOT IN THE HIGHLY DESIRABLE NEIGHBORHOOD OF EL LAGO, WHICH HAS PARKS, PLAYGROUNDS, TENNIS COURTS AND EASY ACCESS TO THE LAKE. ZONED TO THE PRESTIGIOUS ED WHITE E-STEM ELEMENTARY SCHOOL IN AWARD WINNING CCISD. FEATURING A SPARKLING POOL, 4 BEDROOMS, 2 1/2 BATHS, GAME ROOM WITH BAR AND FAMILY ROOM WITH GAS LOG FIREPLACE. THE KITCHEN IS OPEN TO THE BREAKFAST ROOM WITH A BUILT IN BUFFET THAT WOULD MAKE THE PERFECT COFFEE BAR. HUGE MASTER SUITE UPSTAIRS WITH 2 CLOSETS AND SEPARATE VANITY. 3 ADDITIONAL BEDROOMS AND FULL BATH UPSTAIRS AS WELL. THERE IS NO SHORTAGE OF CLOSET/STORAGE SPACE EITHER. MANY RECENT IMPROVEMENTS INCLUDE: ROOF 2019, HVAC REPLACEMENT 2020, DUCTWORK 2021, POOL PLUMBING AND REFURBISHED EQUIPMENT 2021, UNDERGROUND PLUMBING TO LAUNDRY AND HALF BATH 2021. PER SELLER TRANSFERABLE FOUNDATION WARRANTY THROUGH DU-WEST. MAKE THIS HOUSE A HOME WITH YOUR PERSONAL TOUCHES AND IDEAS!' ,`Acres` = '0.261' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 4 EL LAGO SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '11370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ED H WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'El Lago Sec 03' ,`TaxAmount` = '6672' ,`TaxRate` = '2.6666' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493796' WHERE `Matrix_Unique_ID` = '209594926' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:53:54.520' ,`MLSNumber` = '36465640' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.520568' ,`Longitude` = '-95.400792' ,`PhotoCount` = '50' ,`PostalCode` = '77578' ,`RoomCount` = '4' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Walnut Grove' ,`StreetNumber` = '5115' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 36465640 - Built by Highland Homes - January completion! ~ Kitchen great for entertaining w-large island, 2 tone white & navy cabinets & white quartz countertops. The hutch makes a great coffee/wine bar with glass upper cabinets and lights. Towering 10\' Sliding glass doors that open to outdoor patio. 8ft interior doors & soaring 11ft ceilings bring tons of natural light and tranquility. Two dressing vanities in prima' ,`Acres` = '0.1468' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 21 (A0417 ACH&B & A0563 HT&BRR) BLK 3 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6395' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Georgian' ,`Subdivision` = 'Pomona 50s' ,`TaxAmount` = '' ,`TaxRate` = '3.65' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493796' WHERE `Matrix_Unique_ID` = '209664848' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:13:49.070' ,`MLSNumber` = '29769796' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.476540' ,`Longitude` = '-95.506271' ,`PhotoCount` = '43' ,`PostalCode` = '77459' ,`RoomCount` = '7' ,`ListPrice` = '475370.00' ,`Status` = 'Active' ,`StreetName` = 'Pleasant View' ,`StreetNumber` = '10715' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the combination of function and luxury that makes each day superb in The Thomasville luxury home plan. Your open-concept living spaces allows gentle sunlight to shine on your interior design style from energy-efficient windows. The dining space is distinguished by a ceiling that opens to the second floor. The kitchen island faces the dining space, making it an ideal staging area for gourmet dinners and relaxed family breakfasts. Each upstairs bedroom offers unique appeal and an abundance of closet space. The upstairs retreat makes a great game room or family movie theater. The glamourous Owner’s Retreat includes a deluxe en suite bathroom and walk-in closet. Start Creating Your Dream Home with this new floor plan from David Weekley Homes.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1254' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493796' WHERE `Matrix_Unique_ID` = '209837083' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:30:23.120' ,`MLSNumber` = '57110525' ,`ListAgentFullName` = 'Leslie Delcampo' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755490' ,`Longitude` = '-95.863374' ,`PhotoCount` = '49' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '749999.00' ,`Status` = 'Active' ,`StreetName` = 'Hayden Park' ,`StreetNumber` = '28602' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Texas-sized corner-lot homesite is located in desirable Firethorne community zoned to KATY ISD. Low TAX rate. Close to I-10 for easy commuting. Oasis backyard featuring heated pool/spa, outdoor kitchen, covered patio with easy access to an extra restroom in the garage. 3-car garage with TESLA charger. Walking distance to Elementary school. Home includes water softener, mega Theater room on the 2nd floor away from the secondary bedrooms ready with projector, theater lighting and large screen, a separate grand-size game room, schedule a showing today. Refrigerator is included.\r\nThis community offers many amenities such as a Recreational pool with water slides and a toddler-friendly area, a lap pool, Tennis courts, pickle ball, one large playground at the community center and others throughout the neighborhood, a sand volley court, lakes for fishing, walking and biking trails.' ,`Acres` = '0.3024' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'FIRETHORNE SEC 12, BLOCK 3, LOT 13' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '13174' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Firethorne' ,`TaxAmount` = '13266' ,`TaxRate` = '2.6945' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493796' WHERE `Matrix_Unique_ID` = '210014152' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:40:42.280' ,`MLSNumber` = '20495179' ,`ListAgentFullName` = 'Monique Burks' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Shonna King' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.651353' ,`Longitude` = '-95.671106' ,`PhotoCount` = '24' ,`PostalCode` = '77498' ,`RoomCount` = '4' ,`ListPrice` = '318900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Ginger Run' ,`StreetNumber` = '16315' ,`StreetSuffix` = 'Way' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2373' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 4 bedroom. All bedrooms up have plenty of room with a large upstairs master and bath. Home has large kitchen with eat in breakfast. Plenty of cabinets for storage in kitchen and granite counter tops. Kitchen has a large window seat. Kichen is open to family room that has a fireplace. There is a full bath with shower only and a laundry area that is by garage door. Outlets for washer and dryer were turned to be in garage can be modified back to indoor laundry space, presently used as closet. Home has formal living and dining with high ceilings. Back has a large, covered patio and a shed. Plenty of space in backyard for gardening. Home is located on a cul-de-sac and is near Oyster Creek Elementary, Austin High School, Aliana, shops, restaurants and so much more. Easy access to Hwy 6, 59, I-10. This Sugar Land home is great for a family and ready to be yours.' ,`Acres` = '0.1462' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAGE OF OAK LAKE R/P, BLOCK 3, LOT 51' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '462' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OYSTER CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Of Oak Lake R/P' ,`TaxAmount` = '4885' ,`TaxRate` = '2.2529' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493796' WHERE `Matrix_Unique_ID` = '210080589' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:51:51.840' ,`MLSNumber` = '47551938' ,`ListAgentFullName` = 'Tiffanie Purvis' ,`ListOfficeName` = 'Texas Real Estate & Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.732376' ,`Longitude` = '-95.393808' ,`PhotoCount` = '34' ,`PostalCode` = '77006' ,`RoomCount` = '11' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Mount Vernon' ,`StreetNumber` = '4506' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Contemporary, SF home sits on a quiet street in popular Montrose Area. Investment income producer on short-term lease platforms, Airbnb & VRBO, & successful at attracting long-term Tenants if preferred. Perfect homestead if you are looking for a Vanguard program for children & is walking distance to Lanier Middle School. Roof deck w/ view of downtown. Roomy 1st-floor bedroom can work well as an office w/ full bath. Spacious kitchen/dining/living open concept has wood flooring & opens to a balcony. Kitchen w quartz counters, stainless appliances, & a wine cooler. Primary BR features an abundance of natural light, large glass-encased shower, soaking tub, & walk-in closet w/ built-ins. Walk to cafés, restaurants, bars, shopping, parks, & public transit. Close to multiple dog parks, jogging trails, stadiums, museums & nightlife in Midtown, Washington Corridor, Downtown, & The Heights. Minutes from Allen Parkway, 610, 45, 59, & 288. Ask about purchasing Turnkey with furnishing, linens etc.' ,`Acres` = '0.0376' ,`Area` = '16' ,`BuilderName` = 'Neoteric' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 MOUNT VERNON STREET LANDING' ,`LotDesciption` = 'Other' ,`LotSize` = '1594' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Traditional' ,`Subdivision` = 'Mount Vernon Street Lndg' ,`TaxAmount` = '11610' ,`TaxRate` = '2.4216' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493797' WHERE `Matrix_Unique_ID` = '210165381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:54:39.850' ,`MLSNumber` = '41971118' ,`ListAgentFullName` = 'Bret Richards' ,`ListOfficeName` = 'Coleman & Patterson, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.633545' ,`Longitude` = '-96.137298' ,`PhotoCount` = '15' ,`PostalCode` = '77861' ,`RoomCount` = '8' ,`ListPrice` = '634900.00' ,`Status` = 'Active' ,`StreetName` = 'Scarborough' ,`StreetNumber` = '9097' ,`StreetSuffix` = 'Drive' ,`City` = 'Iola' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to Country Living! Welcome Home to New Construction! Located in highly sought-after King Oaks, an acreage lot and lifestyle neighborhood located just 4 miles from all the convenience of south College Station, TX, this 4 Bed/2.5 Bath upcoming Manley Home will be ready for you soon! An open floor plan offers over 3,000 Sq.Ft of pure bliss with relaxing wood-burning fireplace in the living room opening to kitchen/dining, where you will find built-in appliances and spacious pantry. An additional flex space/ office downstairs plus 2nd floor bonus room with storage, your new home will provide the perfect indoor retreat to match all the exterior amenities of your tremendous neighborhood. Community amenities including the 60-acre nature preserve and trails, the stocked fishing pond and park, the community pool and summer kitchen as well as an outdoor fireplace.' ,`Acres` = '1.61' ,`Area` = '60' ,`BuilderName` = 'Manley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bedias/Roans Prairie Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KING OAKS SECTION 3, LOT 464, ACRES 1.61, (RE-PLAT 1646/278)' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '70132' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '171 - Iola' ,`SchoolElementary` = 'IOLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOLA HIGH SCHOOL' ,`SchoolMiddle` = 'IOLA HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'King Oaks Sec 3' ,`TaxAmount` = '544' ,`TaxRate` = '1.5955' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '202' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493797' WHERE `Matrix_Unique_ID` = '210385861' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:23:39.477' ,`MLSNumber` = '50473417' ,`ListAgentFullName` = 'Nina Davenport' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765933' ,`Longitude` = '-95.411954' ,`PhotoCount` = '45' ,`PostalCode` = '77007' ,`RoomCount` = '7' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Feagan' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MC2 ARCHITECT PROJECT: It\'s finally on the market! Located in the Memorial Park/Rice Military area, this stunning well maintained modern townhome offers a sophisticated open floor plan carefully planned views of Downtown Houston\'s impressive skyline. Soaring ceilings, rooms are bright and open with lots of natural light. Freshly painted (in and out), functional floor plan and a GREAT place for entertaining!! Spacious center island, gourmet kitchen with lots of cabinet/counter space and hardwood floors. Beautiful 3rd floor Master Retreat w/3 closets and Balcony. The Master bathroom has double sinks, an oversized jacuzzi tub and a separate shower. also, 3rd floor includes a separate Huge loft/office/study area. It\'s central location provides the convenience of urban living with access to one of the country\'s largest urban parks complete with a PGA golf course. Walking and biking trails, tennis courts, and playing fields. Downtown, Memorial Park, Galleria and fine Dinning near the area.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = 'MC2 ARCHITECT PROJEC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 8 BLK 6 (001* TH 11) BRUNNER' ,`LotDesciption` = 'Other' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'ONE HUNDRED ROY ST TH' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493797' WHERE `Matrix_Unique_ID` = '210536717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:05:26.913' ,`MLSNumber` = '25837724' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470012' ,`Longitude` = '-95.463956' ,`PhotoCount` = '12' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '281990.00' ,`Status` = 'Active' ,`StreetName` = 'Suffolk Valley' ,`StreetNumber` = '7718' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1501' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Camden Plan with Elevation N, features a modern design and offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today! Listing photos are of a similar floor plan. Finishes may vary and are subject to change. Kali Dearbonne: 281-850-3091' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. HORTON, INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493797' WHERE `Matrix_Unique_ID` = '210871396' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:55:39.890' ,`MLSNumber` = '23905318' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.469909' ,`Longitude` = '-95.463892' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Hearth Manor' ,`StreetNumber` = '806' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Cali Plan with Elevation L, features a modern design and offers 4 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!\r\n\r\nListing photos are of a similar floor plan. Finishes may vary and are subject to change.\r\n\r\nCalvin Sowa: 713-446-8686' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. HORTON, INC.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493797' WHERE `Matrix_Unique_ID` = '210879336' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:13:21.723' ,`MLSNumber` = '84166914' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = 'Vaibhav Sharma' ,`SellingOfficeName` = 'All City Real Estate, Ltd. Co.' ,`Latitude` = '29.469909' ,`Longitude` = '-95.463892' ,`PhotoCount` = '28' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '331365.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Serena Park' ,`StreetNumber` = '322' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Cali Plan with Elevation N, features a modern design and offers 4 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today!\r\n\r\nListing photos are of a similar floor plan. Finishes may vary and are subject to change.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. HORTON, INC.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493797' WHERE `Matrix_Unique_ID` = '210879459' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:42:04.833' ,`MLSNumber` = '9490645' ,`ListAgentFullName` = 'Anton Houston' ,`ListOfficeName` = 'Houston Properties & Associate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.556722' ,`Longitude` = '-95.551102' ,`PhotoCount` = '32' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Palmer Plantation' ,`StreetNumber` = '4375' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready! Great location! Fabulous 1 story home in a cul-de-sac, unique location with no back neighbor or side neighbor, very quiet. Open floor plan with vaulted ceilings. Primary bathroom suite includes a tub & shower with two closets. Kitchen opens up to the living room and has granite counters with stainless steel appliances. Nice oversized backyard for family gatherings. Great neighborhood that includes access to two swimming pools, parks, playgrounds and a lake!' ,`Acres` = '0.2052' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PALMER PLNT-LAKE OLYMPIA SEC 1, BLOCK 1, LOT 60' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8938' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '874' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Palmer Plnt-Lake Olympia' ,`TaxAmount` = '5604' ,`TaxRate` = '2.81' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493798' WHERE `Matrix_Unique_ID` = '211046548' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:45:35.147' ,`MLSNumber` = '51301025' ,`ListAgentFullName` = 'Fabiola Duenas' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875886' ,`Longitude` = '-95.933964' ,`PhotoCount` = '50' ,`PostalCode` = '77423' ,`RoomCount` = '12' ,`ListPrice` = '675000.00' ,`Status` = 'Active' ,`StreetName` = 'Mallard' ,`StreetNumber` = '32636' ,`StreetSuffix` = 'Street' ,`City` = 'Brookshire' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom home on 1.2 acres, country life near suburbs/city! Minimal HOA restricts commercial cattle+18whlrs for clean country blend. Enjoy personal farm animals, horses & sprawling land fenced w iron automatic gate. Stone+brick facade welcome into soaring foyer, flows to dining room w matching chandeliers ready to host. Living room opens to chefs kitchen w real wood 42\' cabinets, under lights, thick granite in entire hm, SS appl, ample counter space & brkfst area. 2 majestic primary bedrooms, 1 down & larger 1 up, both have seating areas, separate his/her vanities+separate tub/showers & walk-in closets. 3 addntl bedrooms & extended game room complete energy efficient main hm. Garage has bed+bath, flex for post work/guests/pool. 6 beds+4 1/2 bath property & oversized 3 car garage. Texas-sized porch, beautiful maple trees & chicken coup that can stay. The land offers so much for you to enjoy! FM 529 make it super accessible:Target, Sunterra Lagoon, I10&99. Only 8 years old, priced to sell!' ,`Acres` = '1.17' ,`Area` = '26' ,`BuilderName` = 'Custom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brookshire' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S669100 PEREGRINE ESTATES 2 LOT TR 193 ACRES 1.17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '50965' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '44 - Royal' ,`SchoolElementary` = 'ROYAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROYAL HIGH SCHOOL' ,`SchoolMiddle` = 'ROYAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Peregrine Estates' ,`TaxAmount` = '8557' ,`TaxRate` = '2.0967' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493798' WHERE `Matrix_Unique_ID` = '211098048' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:34:37.743' ,`MLSNumber` = '39086220' ,`ListAgentFullName` = 'Ruby Goings' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.519496' ,`Longitude` = '-95.063045' ,`PhotoCount` = '34' ,`PostalCode` = '77573' ,`RoomCount` = '17' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Torrey' ,`StreetNumber` = '320' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4223' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLERS! NEVER FLOODED! NEW FLOORS 8/1/2022! This beautiful home in the highly desirable Meadows has much space for you to entertain or relax. Maximum flexibility amongst 7 bedrooms combined with the detached garage apartment and the main house with 2 en-suites. No MUD taxes. New interior paint throughout. Spacious kitchen, solid countertops, island, breakfast bar and a walk-in pantry. Large Cul-de-sac lot with space for a pool in its large backyard. Concrete patio has hot/cold water, power, drain and gas pre-plumbed for an outdoor kitchen. Finished air conditioned garage. Two-story apartment has an elevator, full kitchen, bathroom, laundry, 2 living areas, bedroom and is pre-plumbed for 2nd (6th) bath. Endless possibilities! The 1 year old full 9 zoned AC with whole home dehumidifiers and beautiful NEW floors makes this spacious home move-in ready! It\'s also walking distance from schools. This beauty won\'t last long!' ,`Acres` = '0.2494' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas,Heat Pump,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'THE MEADOWS SEC 6 (2007) ABST 18, BLOCK 2, LOT 6, ACRES 0.24' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10865' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GOFORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Meadows Sec 6 2007' ,`TaxAmount` = '7974' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493798' WHERE `Matrix_Unique_ID` = '211147336' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:03:07.670' ,`MLSNumber` = '89841220' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471467' ,`Longitude` = '-95.471390' ,`PhotoCount` = '23' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '281990.00' ,`Status` = 'Active' ,`StreetName` = 'Caldwell Creek' ,`StreetNumber` = '7718' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Bellvue Plan with Elevation N, features a modern design and offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\"\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today! Brittney Cotter: 832-767-8017' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'DR HORTON, INC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493798' WHERE `Matrix_Unique_ID` = '211172427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:56:23.433' ,`MLSNumber` = '28380715' ,`ListAgentFullName` = 'Jill Smith' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.927708' ,`Longitude` = '-95.689421' ,`PhotoCount` = '34' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan Bayou' ,`StreetNumber` = '17931' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WATERFRONT! Gorgeous one-story home in the master-planned community of Towne Lake. Gated section. 3 spacious bedrooms, 3 full bathrooms plus a study. Well-appointed kitchen features granite countertops, stainless steel appliances and gas cooktop. Stunning fireplace with stone surround in the family room. Outdoor kitchen under a covered back patio with great views of the canal that connects to the main lake. Have a boat? No problem! This wonderful home comes with its own private slip. No boat? No problem! Call the water taxi and boat to dinner! Community amenities include a clubhouse, tennis courts, multiple swimming pools, lazy river and parks, splash pad, fishing, boating and miles of trails. Zoned to highly acclaimed CFISD schools. Don\'t miss this opportunity to call Towne Lake home!' ,`Acres` = '0.1326' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 87 BLK 1 TOWNE LAKE SEC 17' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '5777' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2155' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'RENNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Towne Lake' ,`TaxAmount` = '13600' ,`TaxRate` = '3.091' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493798' WHERE `Matrix_Unique_ID` = '211465298' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:49:12.270' ,`MLSNumber` = '5386025' ,`ListAgentFullName` = 'Kelley Jacquinot' ,`ListOfficeName` = 'JAX Realty Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.334036' ,`Longitude` = '-95.085765' ,`PhotoCount` = '32' ,`PostalCode` = '77327' ,`RoomCount` = '10' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Grove-FM 1010' ,`StreetNumber` = '712' ,`StreetSuffix` = 'Road' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this renovated home situated on a large lot with mature trees. The interior is simply stunning with tasteful updates. The original hardwood floors were preserved and refinished. Open layout with a huge family room, dining room, expansive kitchen with a butcher-block island. Large secondary bedrooms and a private, primary en-suite. Classic design with old-soul character not found in cookie-cutter new construction. One of the bedrooms could make a great home office. Wait until you see the almost 800-square foot, concrete-covered patio, and extension. Personalize your outdoor living space and plan your outdoor kitchen. Home is located within the city limits, convenient to restaurants, grocery stores and medical services. NO HOA. Personalize the exterior of this home with some landscaping and make this home your forever home. New AC/Heat, Roof, Windows, PEX Plumbing, Plumbing & Lighting Fixtures, Rewired Electric, Granite Counters, SS Appliances, Residential / Commercial' ,`Acres` = '0.4' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '000441Joseph Fenner,Tr46,Ac .30 & 000394TJWilliams Tr40,.10' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '17424' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Joseph Fenner' ,`TaxAmount` = '' ,`TaxRate` = '2.55' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1665493799' WHERE `Matrix_Unique_ID` = '211483190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:21:46.753' ,`MLSNumber` = '85864984' ,`ListAgentFullName` = 'Alexandra McCauley' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675027' ,`Longitude` = '-95.471867' ,`PhotoCount` = '20' ,`PostalCode` = '77096' ,`RoomCount` = '3' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Braesheather' ,`StreetNumber` = '5207' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '4952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors, builders or those looking for a passion project, 5207 Braesheather is the property for you! This stunning home sits on an oversized corner lot just shy of 13,000 sq ft. Tucked away in the highly desired community of Meyerland, this 3 bedroom/4.5 bath has endless potential for someone looking to take on their next project. Brick exterior makes the home easy to power wash & paint. The layout is a dream w/a stunning curved staircase as your focal point as you enter & a grand foyer that will impress. The architecture is stunning w/grand arched doorways giving this home a classic yet inviting feel. The chefs kitchen has endless potential w/ample room to design a waterfall island, upgraded countertops, sleek cabinetry, chefs appliances & elegant under cabinet lighting. The living room is made for entertaining w/the focal point being the brick fireplace & floor to ceiling windows. Zoned to Kolter Elem & Bellaire HS, this is not an opportunity you want to miss!' ,`Acres` = '0.29614325' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 26 MEYERLAND SEC 8 R/P I' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '12900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KOLTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Meyerland' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493799' WHERE `Matrix_Unique_ID` = '211710271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:30:52.560' ,`MLSNumber` = '74493015' ,`ListAgentFullName` = 'Jennifer Pye Cox' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746547' ,`Longitude` = '-95.419368' ,`PhotoCount` = '37' ,`PostalCode` = '77019' ,`RoomCount` = '12' ,`ListPrice` = '2249000.00' ,`Status` = 'Active' ,`StreetName` = 'Avalon' ,`StreetNumber` = '2911' ,`StreetSuffix` = 'Place' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful River Oaks area home steps away from the award winning River Oaks Elementary School. This\r\ngreat traditional floor plan allows for wonderful family living with a gracious formal Dining room, Handsome wood paneled Study and a cooks kitchen that opens up to the den and breakfast area. Light filled and freshly painted interiors provide great entertaining spaces on first level with the primary suite and ancillary ensuite bedrooms on the second floor and a third floor that is perfect for a game room or teen bedroom suite. Special features include a newly installed ELEVATOR, freshly painted interiors, Guest Suite over the Garage, Porte-cochere, refinished\r\nhardwoods, beautiful landscape and so much more. Showings Begin at Open. House on September 6 from 12-2pm!' ,`Acres` = '0.194' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 AVALON ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '945' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Avalon Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493799' WHERE `Matrix_Unique_ID` = '211927515' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:28:12.580' ,`MLSNumber` = '71751204' ,`ListAgentFullName` = 'Jeffrey Lutz' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796082' ,`Longitude` = '-95.683004' ,`PhotoCount` = '50' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '297900.00' ,`Status` = 'Active' ,`StreetName` = 'Pepperwood' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION LOCATION LOCATION! Wonderfully updated and nice home, in a small pocket size community with excellent access to IH 10. This lovely three bedroom home features beautiful wood look tile in the family, dining, kitchen and hallways. There is modern nice tile in the baths, with carpet in the bedrooms only. This spacious home offers lots of natural light, huge family room with cozy wood burning fireplace, vaulted ceilings, big kitchen with connecting dining area on one side and breakfast on the other other. The kitchen is well appointed with wonderful granite tops, stainless appliances, painted real wood cabinets, big and spacious with sink window to driveway and side door. The primary bedroom is tucked away in the back with nicely redone en-suite, featuring double sinks, modern shower, granite lavatory, and two closets. The secondary bedrooms are both spacious and offer a nice hall bath with double sinks, and separate toilet and tub room. There is also an indoor utility closet.' ,`Acres` = '0.1641' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 69 BLK 3 MAYDE CREEK FARMS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mayde Creek Farms Sec 01' ,`TaxAmount` = '5290' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493799' WHERE `Matrix_Unique_ID` = '212080495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:56:03.290' ,`MLSNumber` = '25494536' ,`ListAgentFullName` = 'Michelle Marek' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152584' ,`Longitude` = '-95.676620' ,`PhotoCount` = '13' ,`PostalCode` = '77362' ,`RoomCount` = '10' ,`ListPrice` = '899990.00' ,`Status` = 'Active' ,`StreetName` = 'Village Shores' ,`StreetNumber` = '1018' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4078' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy resort-style living in the master planned community of Woodtrace. A stunning feature includes the 23-acre Lake and recreation center with pool, clubhouse and five miles of wooded greenbelt trails. The Reagan plan by J. Patrick Homes includes a contemporary style, 5 bedrooms, 4.5 bathrooms and a 3-car garage. Chef\'s kitchen has Quartz countertops, SS upgraded appliances and custom cabinetry. It is the perfect home for entertaining with an open concept floor plan and covered patio with outdoor kitchen. Primary suite has a spa-like bath with dual sinks, freestanding bathtub, and award-winning walk-through shower. Highly sought-after game room down with additional bedroom off main entrance. Working from home made simple with private office/study. Upstairs includes remainder 3 bedrooms and media. Beautiful finishes and selections throughout the home. J. Patrick Homes recently awarded the GHBA Prism Awards - Volume Builder of the Year Grand Award.' ,`Acres` = '0.2869' ,`Area` = '15' ,`BuilderName` = 'J. Patrick Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S959405 - WOODTRACE 05-A, BLOCK 1, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12494' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '1601' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493799' WHERE `Matrix_Unique_ID` = '212084490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:44:08.883' ,`MLSNumber` = '28322364' ,`ListAgentFullName` = 'Jojo Tharayil' ,`ListOfficeName` = 'Excel Realty Co' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.560348' ,`Longitude` = '-95.548730' ,`PhotoCount` = '17' ,`PostalCode` = '77459' ,`RoomCount` = '8' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'King Cotton' ,`StreetNumber` = '4106' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT BIG KITCHEN WITH ISLAND AND BREAKFAST AREA, FAMILY ROOM, FORMAL LIVING AND DINING ROOMS, FIREPLACE, HUGE BACKYARD. MASTER DOWNSTAIRS AND ALL OTHER BEDROOMS UP. GREAT COMMUNITY. YOU WILL WANT TO COME HOME!' ,`Acres` = '0.1736' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PALMER PLNT-LAKE OLYMPIA SEC 1, BLOCK 4, LOT 14, R/P' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7561' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Olympia Sec 1' ,`TaxAmount` = '6252' ,`TaxRate` = '2.81' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493800' WHERE `Matrix_Unique_ID` = '212170778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:56:42.133' ,`MLSNumber` = '95975133' ,`ListAgentFullName` = 'Johnathan Callery' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.303529' ,`Longitude` = '-94.777107' ,`PhotoCount` = '24' ,`PostalCode` = '77550' ,`RoomCount` = '26' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '1013' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '4110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property was designed with a Beautiful split floor plan design and is located in an upcoming neighborhood, \"Palms Of Galveston\". 1013 10th St. is perfectly designed to accommodate the entire family PLUS additional friends. Located in a prime location on Galveston Island, this home has a total of 6 bedrooms, 6.5 bathrooms, 2 open kitchen concepts, Luxury Finishes,  multiple Balconies with views of the Gulf of Mexico, and an abundance of parking to accommodate family and friends. The property is located minutes from the UTMB Medical District, The Beach, Strand District, and Highly Desired restaurants. Furthermore, situated off the garage is a private patio space that was designed to be easily converted into a one bedroom, one bathroom additional living unit. Please take the time to view the virtual tour link attached to the listing.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Al Hoda Enterprises' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOTS 8 & 9 (8-100) BLK 130 GALVESTON' ,`LotDesciption` = 'Other,Water View' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '8368' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493800' WHERE `Matrix_Unique_ID` = '212186090' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:17:59.090' ,`MLSNumber` = '57770209' ,`ListAgentFullName` = 'Peggy West' ,`ListOfficeName` = 'Peggy West Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775398' ,`Longitude` = '-95.533181' ,`PhotoCount` = '48' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '5395000.00' ,`Status` = 'Active' ,`StreetName` = 'Gage' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '8304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You are just in time for our NEW lower PRICE! Beautiful Mid-Century Modern home! #7 GAGE COURT! Rare, sought-after ONE-STORY. Located in Bunker Hill Gardens. Heart of Memorial! Under construction. This Modern /Contemporary features hi ceilings, spacious rooms, and natural light everywhere. This house has it all! West Wing has Primary Bdrm w/cathedral ceilings & FP. Heavenly 14’walk-through shower highlights Primary Bath. Also, in the West Wing: is a Jaw-Dropping Study (38’x20’ w/18’ ceilings), ideal as an art gallery, trophy room, or true working office. You\"ll love the Family area: includes wine room, butler’s pantry & wet bar. Kitchen is filled w/custom cabinetry, a hidden Catering Kit. Amazing utility rm/hm office looks out on the front lawn. Rare 4-car garage w/adjacent hobby/sport/wkout rm. Large pavilion, w/outdoor kit & bathrm. Plenty back yard for putting green, garden, or whatever pleases you. There are simply too many features to list in this amazing custom-designed home.' ,`Acres` = '0.8639' ,`Area` = '23' ,`BuilderName` = 'AG Russo Homes Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 1 BUNKER HILL GARDENS' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '37632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'BUNKER HILL GARDENS' ,`TaxAmount` = '31374' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493800' WHERE `Matrix_Unique_ID` = '212195335' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:59:39.600' ,`MLSNumber` = '91685490' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.897854' ,`Longitude` = '-95.739542' ,`PhotoCount` = '40' ,`PostalCode` = '77433' ,`RoomCount` = '12' ,`ListPrice` = '465990.00' ,`Status` = 'Active' ,`StreetName` = 'Costalinda' ,`StreetNumber` = '21322' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cherish unforgettable moments in this stunning Briarwood home in Marvida. This 4-sided brick home boasts a premium elevation, tile flooring, wrought iron spindles, faux wood blinds, a natural stone fireplace, and a covered patio. Spend quality time in the island kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Unwind in the serene primary suite features dual vanities, a drop-in tub, and a separate shower. Community comforts of Marvida include clubhouses, pools, splash pads, tennis courts, sports courts, parks, playgrounds, and a dog park. Commuters enjoy the ease of access to Katy, the Energy Corridor, and Downtown Houston via the Grand Parkway and Highway 290. Nearby schools are zoned to the Cypress-Fairbanks ISD. Don’t miss this home – call now to learn more!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493800' WHERE `Matrix_Unique_ID` = '212262729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:43:10.963' ,`MLSNumber` = '36545651' ,`ListAgentFullName` = 'Erwin Nicholas' ,`ListOfficeName` = 'Mr. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767651' ,`Longitude` = '-95.412284' ,`PhotoCount` = '30' ,`PostalCode` = '77007' ,`RoomCount` = '9' ,`ListPrice` = '969999.00' ,`Status` = 'Active' ,`StreetName` = 'Roy' ,`StreetNumber` = '606' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2940' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Take a look at this beautiful 4 story single family master piece! This home is unique with commercial floor to ceiling windows and sliding doors. High ceilings and very open floor plan make this home perfect for entertaining guest! Stainless steel Jenn-Air commercial grade appliances compliment the kitchen with a very large seating area. The seller has also upgraded the lighting fixtures and added custom improvements through out the home. One of the most exciting additions to the home is the first in Houston container pool and private side yard! This is a must see home!' ,`Acres` = '0.0373' ,`Area` = '16' ,`BuilderName` = 'Eppers & Wakefield' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 CHATEAUS ON ROY STREET' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Enclosed,Fiberglass' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Chateaus/Roy Street' ,`TaxAmount` = '13072' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665493800' WHERE `Matrix_Unique_ID` = '212271826' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:58:51.570' ,`MLSNumber` = '88280776' ,`ListAgentFullName` = 'Dawn Lanclos' ,`ListOfficeName` = '2 Gen Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.176323' ,`Longitude` = '-95.424312' ,`PhotoCount` = '32' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '184700.00' ,`Status` = 'Active' ,`StreetName` = 'Lorraine' ,`StreetNumber` = '740' ,`StreetSuffix` = 'Street' ,`City` = 'Angleton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1799' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see your new home only 25 minutes from the beach! This home has a large primary bedroom with an extra large primary closet! Retreat to your screened in porch for outdoor living without the mosquitos! Large fenced in backyard for your kids and pets to play!' ,`Acres` = '0.1702' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'K & S PLAZA (ANGLETON) BLK 2 LOT 25 (E/54.5\'), UNDIVIDED INT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7414' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'K & S Plaza Angleton' ,`TaxAmount` = '1760' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493800' WHERE `Matrix_Unique_ID` = '212310791' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:40:05.447' ,`MLSNumber` = '73677537' ,`ListAgentFullName` = 'Estelle Senion' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = 'Jarrett Glass' ,`SellingOfficeName` = 'Jarrett Glass' ,`Latitude` = '29.813988' ,`Longitude` = '-94.836813' ,`PhotoCount` = '22' ,`PostalCode` = '77523' ,`RoomCount` = '8' ,`ListPrice` = '240000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Snapping Turtle' ,`StreetNumber` = '5706' ,`StreetSuffix` = 'Road' ,`City` = 'Mont Belvieu' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1414' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Less time commuting, more time to enjoy home! This 3-bedroom, 2-bathroom traditional style home is found in the Joseph\'s Cove community of Mont Belvieu. Minutes from East Houston: located in Liberty and Chambers County, Mont Belview provides a low-travel commute to Baytown, San Jacinto Monument, Fred Hartman Bridge, San Jacinto River, and Battleship Texas Historic Site. This home’s floor plan offers nice touches with neutral decor. The serene primary bedroom includes a walk-in closet. The other two bedrooms are ready for your decorative flare. Attached one-car garage. Developing market, located away from the traffic of the city.' ,`Acres` = '0.169' ,`Area` = '53' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 8 BK 5 JOSEPHS COVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Josephs Cove' ,`TaxAmount` = '2952' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493801' WHERE `Matrix_Unique_ID` = '212348188' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:17:05.390' ,`MLSNumber` = '95209973' ,`ListAgentFullName` = 'Richard Richards' ,`ListOfficeName` = 'Richard Richards Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.028157' ,`Longitude` = '-95.307617' ,`PhotoCount` = '32' ,`PostalCode` = '77338' ,`RoomCount` = '6' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Hagilbert' ,`StreetNumber` = '21606' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Clean & affordable 3 BDRM & 2 BATH home, great condition on over a 1/2 acre+ in the well sought after Oak Hill Estates. Home has nice sized open family room, kitchen & dinning area, to include a fire place in the family room. Beautifully wooded lot, mature trees & plenty of shade. Home has 60K plus in updates & upgrades: water proof vinyl plank floor, new AC & Heater, granite countertops in the kitchen & bath, updated tiled walk-in shower, insulation updated, leveled, handicapped access to home for visitors or occupants in need. Nice wood deck, metal building in the back for storage, work shed or tool room. Covered front porch. Seller may be negotiable on washer/dryer/fridge w/an accepted offer. Hard to find a yard this big (1/2 acre +) in the Humble area, close to 1960/Hardy/Hwy 59/ IAH Airport minutes away. Homes in community in high demand, hurry, won\'t last. Don\'t miss this opportunity to have a taste of the country life without leaving the city. Showings begin Sun 9-18-22' ,`Acres` = '0.5358' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 OAK HILL ESTATES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '23339' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Hill Estates' ,`TaxAmount` = '1818' ,`TaxRate` = '2.0933' ,`WaterSewer` = 'Aerobic,Public Sewer' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493801' WHERE `Matrix_Unique_ID` = '212375358' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:33:18.637' ,`MLSNumber` = '65956806' ,`ListAgentFullName` = 'Connie Buck' ,`ListOfficeName` = 'Lucid Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776560' ,`Longitude` = '-95.241484' ,`PhotoCount` = '5' ,`PostalCode` = '77013' ,`RoomCount` = '3' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Westshire' ,`StreetNumber` = '705' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTMENT PROPERTY ON BEAUTIFUL, HUGE LOT, DIRECTLY ACROSS THE STREET FROM SONGWOOD PARK. LOCATED ONE BLOCK AWAY FROM FURR HIGHSCHOOL. CENTRALLY LOCATED OFF OF I-10 AND 610 AND ONLY TEN MINUTES FROM DOWNTOWN! ' ,`Acres` = '0.1763' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 5 MEADOWOOD ESTATES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WHITTIER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'FURR HIGH SCHOOL' ,`SchoolMiddle` = 'HOLLAND MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Meadowood Estates' ,`TaxAmount` = '4627' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493801' WHERE `Matrix_Unique_ID` = '212471218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:57:43.910' ,`MLSNumber` = '44235461' ,`ListAgentFullName` = 'Michelle Marek' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.212362' ,`Longitude` = '-95.331165' ,`PhotoCount` = '18' ,`PostalCode` = '77302' ,`RoomCount` = '9' ,`ListPrice` = '699990.00' ,`Status` = 'Active' ,`StreetName` = 'Dandelion Dreams' ,`StreetNumber` = '15712' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy resort-style living in the master planned community of ARTAVIA. Enjoy the trails winding their way through the trees and along the boardwalk. Launch your kayak into the five-acre community lake. The new Meadowlark II plan by J. Patrick Homes features a painted brick exterior, 4 bedrooms, 3.5 bathrooms and a 3-car garage. Chef\'s kitchen has Quartz countertops, SS upgraded appliances and custom cabinetry. It is the perfect home for entertaining with an open concept floor plan and covered patio with outdoor kitchen. Primary suite has a spa-like bath with dual sinks, freestanding bathtub, and award-winning walk-through shower. Enjoy highly sought after 2 bedrooms down, with additional bedrooms and game room/media up. Beautiful finishes and selections throughout the home. Smart home features included with white glove service after closing. J. Patrick Homes recently awarded the GHBA Prism Awards - Volume Builder of the Year Grand Award.' ,`Acres` = '0.225459' ,`Area` = '19' ,`BuilderName` = 'J. Patrick Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 31 BLOCK 1 SECTION 13 ARTAVIA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9824' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.1988' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493801' WHERE `Matrix_Unique_ID` = '212571324' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:39:20.020' ,`MLSNumber` = '19750660' ,`ListAgentFullName` = 'Michelle Marek' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152242' ,`Longitude` = '-95.680973' ,`PhotoCount` = '15' ,`PostalCode` = '77362' ,`RoomCount` = '9' ,`ListPrice` = '799990.00' ,`Status` = 'Active' ,`StreetName` = 'Groveton Ridge' ,`StreetNumber` = '1046' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy resort-style living in the master planned community of Woodtrace. A stunning feature includes the 23-acre Lake and recreation center with pool, clubhouse and five miles of wooded greenbelt trails. The Oxford plan by J. Patrick Homes includes 5 bedrooms, 4.5 bathrooms and a 3-car garage. Chef\'s kitchen has Quartz countertops, SS upgraded appliances including double oven and custom cabinetry. It is the perfect home for entertaining with an open concept floor plan and covered patio with outdoor kitchen. Primary suite has a spa-like bath with dual sinks and award-winning walk-through shower. Highly sought-after secondary bedroom down and private office/study. Upstairs includes remainder 3 bedrooms and game room. Beautiful finishes and selections throughout the home including grand curved staircase. Smart home features included with white glove service after closing. J. Patrick Homes recently awarded the GHBA Prism Awards - Volume Builder of the Year Grand Award.' ,`Acres` = '0.2342' ,`Area` = '15' ,`BuilderName` = 'J. Patrick Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S959491 - WOODTRACE 08-B, BLOCK 1, LOT 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10201' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace' ,`TaxAmount` = '1672' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493801' WHERE `Matrix_Unique_ID` = '212615162' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:14:36.480' ,`MLSNumber` = '27018816' ,`ListAgentFullName` = 'David Brown' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.808356' ,`Longitude` = '-95.379504' ,`PhotoCount` = '24' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Link' ,`StreetNumber` = '705' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS FREESTANDING 3 STORY HOME WITH PRIVATE GUEST PARKING SPACE OWNED BY THIS HOME, 3 BDRMS, 3 FULL BATHS, 1 HALF BATH, 2 CAR GARAGE, SPACIOUS OPEN FLOORPLAN FEATURES HUGE 2ND FLOOR LIVINGROOM, BEAUTIFUL REAL HARDWOOD FLOORS, INTERIOR IS INVITING WITH LITE AND BRITE COLOR CONCEPT. LARGE GROUPED WINDOWS THAT ALLOWS FOR THE RIGHT AMOUNT OF NATURAL LIGHT. BEAUTIFUL SPACIOUS KITCHEN WHITE CABINETS, SOFT CLOSE SHAKER STYLE CANINETS WITH CUSTOM MOLDING. A FULL SPACIOUS DINING ROOM, MODERN BACKSPLASH PAIRED GRANITE COUNTERS. MASTER BEDROOM LUXURIOUS MASTER BATH, SEPERATE TUB & SHOWER, DOUBLE GRANITE VANITY, BIG WALK IN CLOSET, TWO NICE SECONDARY BDRMS W/ ENSUITE BATHS, ENGINEER DISIGNED FOUNDATION, ENERGY EFFICIENT WINDOWS. YOU ARE GOING TO FALL IN LOVE WITH THE CRAFTMANSHIP IN THIS HOME, SO MUCH TO EXPLORE IN THIS AREA, RESTAURANTS, HEB, WHOLE FOODS AND THE ONE OF THE BEST FARMERS MARKET HOUSTON HAS TO OFFER WITHIN WALKING DISTANCE. WALKING DISTANCE. CALL FOR PRIVATE SHOWING.' ,`Acres` = '0.0416' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 1 NEWER HEIGHTS T/H' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Newer Heights Twnhms' ,`TaxAmount` = '9045' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493802' WHERE `Matrix_Unique_ID` = '212626737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:12:17.623' ,`MLSNumber` = '87912637' ,`ListAgentFullName` = 'Brandon Dunbar' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887828' ,`Longitude` = '-95.606979' ,`PhotoCount` = '30' ,`PostalCode` = '77041' ,`RoomCount` = '8' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Fountaincrest' ,`StreetNumber` = '7510' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS ONE-OF-A-KIND PATIO HOME IS A MUST-SEE!! This 2-3/2 home is nestled into the prestigious Chimney Hill subdivision. The home has high ceilings and a large living room area that you and your family could enjoy. The home has a unique upstairs bedroom/home office/game room adding more living space and possibilities! Super easy access to HWY 290. The furniture seen in the home is all negotiable with the sale of the home. Refrigerator/Washer/Dryer comes with the home!' ,`Acres` = '0.1188' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 CHIMNEY HILL SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '381' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAIRGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LABAY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Chimney Hill Sec 05' ,`TaxAmount` = '4174' ,`TaxRate` = '2.811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493802' WHERE `Matrix_Unique_ID` = '212666702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:06:53.740' ,`MLSNumber` = '44266016' ,`ListAgentFullName` = 'Daniele Tavares' ,`ListOfficeName` = 'CB&A, Realtors-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042037' ,`Longitude` = '-95.590216' ,`PhotoCount` = '37' ,`PostalCode` = '77375' ,`RoomCount` = '5' ,`ListPrice` = '304900.00' ,`Status` = 'Active' ,`StreetName` = 'Carriage Vale' ,`StreetNumber` = '19234' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful, well-maintained home, zoned to highly acclaimed Klein ISD schools. This lovely home features 4 bedrooms, 3 full baths and an attached 2 car garage. Lots of upgrades and great closet space\r\nthroughout the home. \r\nConveniently located to Grand Parkway, Tomball Parkway, and Vintage Park!\r\nSee for yourself what this home has to offer and schedule your showing before it\'s gone! No carpet! New paint!' ,`Acres` = '0.111' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 ASHFORD GROVE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4833' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '405' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Grove Sec 1' ,`TaxAmount` = '5372' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493802' WHERE `Matrix_Unique_ID` = '212688962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:14:41.300' ,`MLSNumber` = '30220964' ,`ListAgentFullName` = 'Carolina Barbieri' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.865789' ,`Longitude` = '-95.686767' ,`PhotoCount` = '26' ,`PostalCode` = '77449' ,`RoomCount` = '7' ,`ListPrice` = '298000.00' ,`Status` = 'Active' ,`StreetName` = 'Sweet Juniper' ,`StreetNumber` = '18203' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Delight with tons of upgrades a one-story home 3 bedrooms and 2 full bathrooms, plus a flex room and no back neighbors. Renovated new floor, new paint, new fence!! Beautiful stone front, elevation with porch, triple layer-stained glass front door.. You don\'t want to miss this opportunity. A must to see!!!' ,`Acres` = '0.132' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 1 CYPRESS FALLS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCFEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Falls Sec 02' ,`TaxAmount` = '5389' ,`TaxRate` = '2.706' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493802' WHERE `Matrix_Unique_ID` = '212699469' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:19:09.877' ,`MLSNumber` = '83507290' ,`ListAgentFullName` = 'Katherine Hurtubise' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Megan Daugherty' ,`SellingOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`Latitude` = '29.550038' ,`Longitude` = '-95.315274' ,`PhotoCount` = '33' ,`PostalCode` = '77584' ,`RoomCount` = '5' ,`ListPrice` = '360000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sumac' ,`StreetNumber` = '3110' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO MORE SHOWINGS!\r\nCome check out this lovely, well-kept 3 bed & 2 bath home in the establish West Oaks subdivision. Built in 2001, this home boasts 12 foot ceilings, crown molding, hardwood floors, & granite countertops throughout. The kitchen features wood cabinets that were updated in 2020 along with an island, stainless steal appliances, and walk-in pantry. The gas log fireplace in the living area will come in handy for those cold nights. The primary bath features upgrades from 2021, a jetted tub & shower, His and hers vanity and closet. The covered patio is perfect for entertaining. This home is a MUST SEE! Schedule your private showing today. Roof, AC, and water heater all replaced in 2013.' ,`Acres` = '0.1791' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WEST OAKS SEC 3 PHASE B (A0241 H T & B)(PEARLAND), BLOCK 3,' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7802' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'H C CARLESTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West Oaks Sec 1 A-B/Sec Two A-' ,`TaxAmount` = '8425' ,`TaxRate` = '2.8052' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493802' WHERE `Matrix_Unique_ID` = '212706514' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:46:30.313' ,`MLSNumber` = '80724896' ,`ListAgentFullName` = 'Ruth Stultz' ,`ListOfficeName` = 'Berkshire Hathaway HomeService' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.373130' ,`Longitude` = '-95.602778' ,`PhotoCount` = '46' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Lake View' ,`StreetNumber` = '233' ,`StreetSuffix` = 'Circle' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning ONE story home welcomes all immediately upon drive-up. This home has the rare advantage of extra space between homes and sits on a quiet Circle. Nicely updated to suit today\'s expectations, one feels the casual comfort immediately upon entry. It has a formal dining as well as breakfast area and a delightful kitchen, all adjacent to the central, spacious Family room with high ceilings and inviting Primary suite Retreat. Wood flooring & Plantation Shutters in most areas, with tile in wet areas, no carpet! It boasts a screened porch with painted floor in the private, fenced back yard as well as a side patio providing privacy & easy for those who love to grill! April Sound is one of Lake Conroe\'s finest, offering 24 hr manned gated security as well as its wonderful Country Club amenities of golf, tennis, pickleball, pools & gym offering classes, with breathtaking views of Lake Conroe. There are 2 Play Parks as well. MISD !! A must see!' ,`Acres` = '0.2273' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 05, BLOCK 1, LOT 9' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '9902' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '234' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound 05' ,`TaxAmount` = '5184' ,`TaxRate` = '2.2625' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493803' WHERE `Matrix_Unique_ID` = '212809903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:06:53.207' ,`MLSNumber` = '86698567' ,`ListAgentFullName` = 'Terri Clasen' ,`ListOfficeName` = 'Pat Griffin Realty ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.294005' ,`Longitude` = '-94.801415' ,`PhotoCount` = '25' ,`PostalCode` = '77550' ,`RoomCount` = '3' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = '32nd' ,`StreetNumber` = '1317' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very cute, newly renovated, move-in ready home, located near Broadway with easy access to The Strand, UTMB, and beach. Outside you will note the fresh paint, new windows, new central AC/Heat and an easy to maintain yard. Once inside, you will see a thoughtfully designed space in this charming 2 bedroom, 1 bathroom home. There are new fixtures throughout the home. The kitchen boasts new counters, backsplash, appliances and cabinets. There is beautiful new vinyl plank flooring throughout the home, fresh paint and also new electrical. The roomy bathroom also has new fixtures and vanity. Both bedrooms have a nice closet space, and there are also 2 hall closets. The laundry is conveniently located just off of the kitchen with double doors to close off when not in use. Perfect starter home, or rental income. Please schedule your showing today.' ,`Acres` = '0.0305' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOT 8 (8-2) NW BLK 13 GALVESTO' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1330' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding 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,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Outlots' ,`TaxAmount` = '1022' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493803' WHERE `Matrix_Unique_ID` = '212835429' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:49:48.807' ,`MLSNumber` = '90907548' ,`ListAgentFullName` = 'Dorothy Wanko' ,`ListOfficeName` = 'TEXdot Real Estate Services,Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.142660' ,`Longitude` = '-95.444447' ,`PhotoCount` = '41' ,`PostalCode` = '77386' ,`RoomCount` = '12' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Basswood' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lowest tax rate around 2.00! No HOA! Like new construction (all renovations 2022, never lived in since renovated) semi custom single story ranch home (2,518 sqft). Home is situated on a corner lot 16,000+ sqft. There are too many updates and upgrades to list, plesae contact us or your Realtor for details. 3 Bedroom 2 bath home, plus study, all bedrooms have walk in closets. One of the secondary bedrooms has two walk in closets! 2 car garage with a double wide driveway, plus an additional oversized driveway (with a double gate entry into backyard) Park anything you want. Private inground pool recently resurfaced. Plus a Pool House (300 sqft in addition to home) complete with a kitchenette (gas range included) and full bath (bath 3). Beautiful covered front and back porches. Close to The Woodlands easy access to Hwy 45, 99 and Hardy Toll. Lots of restaurants, entertainment, and shopping. Multi-Generational “GenX” Low taxes~ Broker/Owner/Agent' ,`Acres` = '0.3687' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK RIDGE NORTH 03, LOT 303' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '16059' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Oak Ridge North 03' ,`TaxAmount` = '4616' ,`TaxRate` = '2.0087' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665493803' WHERE `Matrix_Unique_ID` = '212884131' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:57:07.343' ,`MLSNumber` = '54387640' ,`ListAgentFullName` = 'Charlie Neath' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749620' ,`Longitude` = '-95.503553' ,`PhotoCount` = '25' ,`PostalCode` = '77063' ,`RoomCount` = '8' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodway' ,`StreetNumber` = '7702' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2997' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well cared for and updated modern ranch-style home in Charnwood sits on beautiful 27,300 square foot ravine lot. Three bedrooms and 3.5 baths with stunning views of green space from almost every room in the home. City living with an outdoor feel, this extensively remodeled home has undergone transformation both in and out. Ebony stained hardwood floors, kitchen island with Caesarstone Oyster Quartz counter, gas range, Sub Zero fridge, Bosch double ovens (2020), walk-in pantry, and ample lighting. Master bedroom is open and airy with large windows, cathedral ceilings, Thibaut wallpaper and two Space-Man designed walk-in closets. Built-in basketball hoop, tree house, automatic gate, and two car garage. Neighborhood patrol and private trash pick-up two days a week. Conveniently located near The Kinkaid School, St. Francis, St. Martin\'s, Trader Joe\'s, Kroger, and Whole Foods. This home DID NOT flood in Harvey. (per Seller)' ,`Acres` = '0.6267' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Charnwood/Briarbend' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 4 CHARNWOOD' ,`LotDesciption` = 'Ravine,Subdivision Lot' ,`LotSize` = '27300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Charnwood' ,`TaxAmount` = '19947' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493803' WHERE `Matrix_Unique_ID` = '212927508' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:50:21.173' ,`MLSNumber` = '68486150' ,`ListAgentFullName` = 'Austin Jackson' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.587295' ,`Longitude` = '-95.053079' ,`PhotoCount` = '8' ,`PostalCode` = '77586' ,`RoomCount` = '11' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Berry' ,`StreetNumber` = '1522' ,`StreetSuffix` = 'Lane' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2476' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this 4 Bed, 2.5 Bath home in Kirbybend with a 3 car detached garage.' ,`Acres` = '0.1912' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 KIRBYBEND SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8330' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirbybend Sec 01' ,`TaxAmount` = '7095' ,`TaxRate` = '2.5419' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493803' WHERE `Matrix_Unique_ID` = '212963312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:17:39.387' ,`MLSNumber` = '25668986' ,`ListAgentFullName` = 'Carey Womack' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.068379' ,`Longitude` = '-95.384171' ,`PhotoCount` = '24' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Dusk' ,`StreetNumber` = '2806' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1671' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRISTINE best describes this beautifully updated home! Too many improvements to name here (complete list in Agent Docs) just a few: New Roof 2017, New HVAC System 2017, New Flooring 2021, All interior doors replaced 2021. From the stacked stone backsplash in the kitchen to the coordinating stacked stone gas log fireplace in the living room this home is spectacular. Kitchen has all stainless appliances with easy access out to a deck AND patio. Ideal for entertaining! The primary bedroom has French Sliding doors that open wide to lavishly landscaped, custom built deck area with pergola. A perfect place to begin or end your day! Primary bath is luxurious with double sink vanity and free standing claw foot soaking tub! One of the additional bedrooms has a wall of built-in bookshelves and cabinetry. A skylight provides lovely natural light. Currently utilized as an office, but anyone would love this as their bedroom! Schedule a personal Tour Today!!' ,`Acres` = '0.1116' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 10 SPRINGRIDGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '175' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Springridge Sec 02' ,`TaxAmount` = '3817' ,`TaxRate` = '2.8117' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493804' WHERE `Matrix_Unique_ID` = '213026433' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:42:46.813' ,`MLSNumber` = '16168427' ,`ListAgentFullName` = 'Somer Padilla' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981111' ,`Longitude` = '-95.515519' ,`PhotoCount` = '21' ,`PostalCode` = '77069' ,`RoomCount` = '8' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Gables' ,`StreetNumber` = '5602' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3016' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious one of a kind property offers a REME air purification system, rebuilt Trane HVAC system (2014), custom steel driveway gate, downstairs primary suite custom shelving in the walk in closet has a connected den area with wall to wall built-in book shelves and private access to the heated pool area which includes an outdoor kitchen and covered patio. With floor to ceiling windows throughout the first floor, the heated pool is visible from the entire floor! Sizable breakfast area and a formal dining room as well. Oversized bedrooms upstairs with plenty of storage.' ,`Acres` = '0.2944' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 3 CHAMPIONS EAST U/R & PAR R/P' ,`LotDesciption` = 'In Golf Course Community,Patio Lot,Subdivision Lot' ,`LotSize` = '12825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions East U/R & Prcl R/P' ,`TaxAmount` = '7575' ,`TaxRate` = '2.4906' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493804' WHERE `Matrix_Unique_ID` = '213083347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:16:10.700' ,`MLSNumber` = '53664121' ,`ListAgentFullName` = 'Garie Muenchausen' ,`ListOfficeName` = 'Walter Jolley Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.139972' ,`Longitude` = '-95.403246' ,`PhotoCount` = '37' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsway Park' ,`StreetNumber` = '31006' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FRESH & READY FOR YOU!SPACIOUS 2 STORY W/MASTER DOWN, STUDY DOWN,GAMEROOM UP;FORMAL DINING ROOM,LARGE FAMILY ROOM W/FIREPLACE-SPACIOUS KITCHEN W/REFRIGERATOR, 42\" CABINETS & OPEN TO FAMILY ROOM WHICH BOASTS WALLS OF WINDOWS W/STREAMING LIGHT INTO THE HOME.THIS HOME IS LOCATED ON A CORNER LOT & THE YARD IS OVERSIZED & FULLY FENCED FEATURING A DECK FOR YOUR ENJOYMENT.JUST BRING YOUR TABLE, UMBRELLA & CHAIRS!!UPSTAIRS IS THE JACK & JILL BATH &, AN ADDITONAL BATH OFF ONE OF THE SECONDARY BEDROOMS. DON\'T OVER LOOK THE STUDY AREA IN THE GAMEROOM.SPACIOUS PARKING FOR YOUR CARS W/THIS 3 CAR DETATCHED GARAGE W/A SINGLE DRIVEWAY THAT OPENS TO A DOUBLE AREA FOR PARKING. A/C & HEAT REPLACED IN SUMMER, 2022. BE IN BEFORE THE HOLIDAYS TO ENJOY YOUR NEW HOME & NEIGHBORHOOD.' ,`Acres` = '0.2531' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS FOREST 01, BLOIMPERIAL OAKCK 3, LOT 6' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '11025' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Forest 01' ,`TaxAmount` = '8367' ,`TaxRate` = '2.7627' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493804' WHERE `Matrix_Unique_ID` = '213100167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:58:26.033' ,`MLSNumber` = '16478270' ,`ListAgentFullName` = 'Lauren Ashley' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = 'Evan Compean' ,`SellingOfficeName` = 'Compean Group' ,`Latitude` = '29.788893' ,`Longitude` = '-95.405996' ,`PhotoCount` = '46' ,`PostalCode` = '77008' ,`RoomCount` = '11' ,`ListPrice` = '510000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Herkimer' ,`StreetNumber` = '1002' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS 3-story home located in the highly desirable Heights location boasts 3 bds & 3 baths! This amazing home features STUNNING hardwood floors throughout w/ dazzling tile floors in the foyer & bathrooms. The second floor is a wonderful open space great for entertaining w/ the chef\'s kitchen open to the spacious living room. The kitchen features SS appliances & beautiful granite countertops w/ breakfast bar into the formal dining area. The second bedroom & master suite are located on the third & final floor both include ensuite bathrooms. The breathtaking master suite boasts high ceilings & a seating area w/ built-in cabinet; double doors open to the luxurious master bath w/ large soaking tub & walk-in standing shower. The master bath was updated w/ dazzling quartz countertops & marble tile floors. Utility updates include updated utility box in 2021 & water heater in 2022! Located a 15 min drive from downtown & a few blocks from the heights hike & bike trails as well as MKT!' ,`Acres` = '0.0379' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 HERKIMER HEIGHTS' ,`LotDesciption` = 'Corner' ,`LotSize` = '1651' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Herkimer Heights' ,`TaxAmount` = '9276' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493804' WHERE `Matrix_Unique_ID` = '213147379' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:07:09.600' ,`MLSNumber` = '32461074' ,`ListAgentFullName` = 'Vicki Chapman' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.357378' ,`Longitude` = '-94.984565' ,`PhotoCount` = '25' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'CR 2235' ,`StreetNumber` = '2399' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New 2021 Home on 0.87 acre lot! This 3 bedroom 2 bath house has a large covered front porch to sit and enjoy the peace & quiet of country living. Beautifuly designed kitchen with a center island that opens into the family room. Nice, large soaking tub with separate shower in the primary bath. Brand new stoarge shed to boot! Great opportunity for an investor looking for rental property and/or family looking for a quiet place in the country. Tarkington ISD. SUD water. Come check it out!' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TARKINGTON LAKE ESTATES 1, LOT 29, TRACT 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'TARKINGTON LAKE ESTATES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493804' WHERE `Matrix_Unique_ID` = '213167493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:44:32.207' ,`MLSNumber` = '50811571' ,`ListAgentFullName` = 'Ana Patricia Torres' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.860721' ,`Longitude` = '-95.443610' ,`PhotoCount` = '18' ,`PostalCode` = '77091' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'BUNCHE' ,`StreetNumber` = '6702' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ABSOLUTELY BEAUTIFUL, 3 BEDROOM 2 BATH, ONE STORY HOME, NEW CONSTRUCTION, GRANITE THROUGHOUT THE KITCHEN AND BATHROOMS, OPEN CONCEPT WITH A LARGE ISLAND TABLE, AMPLE BACK YARD WITH PLENTY OF ROOM FOR PLAY OR PETS.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 195 BLK 6 CARVER ESTATES' ,`LotDesciption` = 'Other' ,`LotSize` = '4750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'CARVER ESTATES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493804' WHERE `Matrix_Unique_ID` = '213208628' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213305869','1665493805','213305869','2022-10-11T06:02:58.303','8173622','Stacy Newton','Weichert,REALTORS-Murray Group','','','29.796728','-95.738582','32','77449','7','294000.00','Active','Rock Harbor','20715','Court','Katy','2','0','3','1699','Single-Family','One story home on a cul-de-sac with no back neighbors. Walking distance to the British International School. This immaculate home offers an open floor plan. The family room, kitchen with granite countertops and custom cabinets and dining room are all open. The oversized primary bedroom offers plenty of privacy with a large en-suite with a walk in shower and separate jetted tub. The secondary bedrooms are situated on the other side of the home with access to the secondary bathroom. All stainless steel appliances. The refrigerator in the garage will stay with the home. Call today to schedule a private showing! This one won\'t last!!','0.1653','25','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Katy - North','Central Gas','1','LT 63 BLK 1 CASTLE ROCK SEC 1','Cul-De-Sac,Subdivision Lot','7201','Appraisal District','','455','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','30 - Katy','FRANZ ELEMENTARY SCHOOL','MORTON RANCH HIGH SCHOOL','MORTON RANCH JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,Request Online Appointment','Appraisal District','1','Traditional','Castle Rock Sec 01','4875','2.502','Public Sewer,Water District','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213313307','1665493805','213313307','2022-10-11T07:02:14.190','69055303','David Rainey','Camelot Realty','','','33.734429','-82.737685','42','30673','5','895000.00','Active','Water','210','','Washington','3','2','5','3971','Single-Family','\"Red Brick Manor\" The Samuel Lowe Home c.1898 the Main House (5 Bedroom/3 full 2 half baths) with fabulous GUEST QUARTERS above Climate controlled 8 car garage. Guest Quarters consist of two (2) 2 Bedroom 2 Bath suites complete with kitchens and small Juliet balconies. A wonderful property for entertaining! This most Exquisite Southern Antebellum reflects Greek Revival architecture with soaring columns, wide Southern porches, beautiful unpainted heart of Pine floors, a grand entry hall with arched doorway fanlights and a gracefully rising CENTER staircase create a spectacular entrance! Flanking the wide center hall on each side are two beautiful parlors and formal dining room, each with pocket doors and stunning matching mantles. This is a MUST SEE HOME far too many amenities to list....You will not be disappointed. Nestled in the heart of the Historic District within walking distance of the Quaint Historic Town Square, Shops, Restaurants, \r\nMuseums and Mary Willis Library.','0.61','81','','','','','Sellers Disclosure','1','','','','Central Electric','0','210 WATER ST GMD164','Patio Lot','30000','Appraisal District','','','0','','8','Electric Oven','0','','','Gas Range','','Composition','','','','','Accompany,Appointment Required','Appraisal District','2','Traditional','Historic Washington','','','Public Sewer,Public Water','1900','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:46:34.960' ,`MLSNumber` = '67627102' ,`ListAgentFullName` = 'Bradley Depoy' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'An Nguyen' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.194768' ,`Longitude` = '-95.498048' ,`PhotoCount` = '31' ,`PostalCode` = '77381' ,`RoomCount` = '4' ,`ListPrice` = '405000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sweetdream' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1993' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE!!! This home is in the heart of Woodlands, walking distance from phenomenal schools, parks and much more! Home features many upgrades and very well maintained. Please reach out today for your private showing!' ,`Acres` = '0.1783' ,`Area` = '15' ,`BuilderName` = 'Ryland' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S972219 - WDLNDS VIL COCHRANS CR 19, BLOCK 3, LOT 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7767' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 19' ,`TaxAmount` = '5047' ,`TaxRate` = '2.0869' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493805' WHERE `Matrix_Unique_ID` = '213313738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:41:28.317' ,`MLSNumber` = '60367135' ,`ListAgentFullName` = 'Ryan Neunuebel' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = 'Maria Ariza' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.200711' ,`Longitude` = '-95.486424' ,`PhotoCount` = '38' ,`PostalCode` = '77382' ,`RoomCount` = '10' ,`ListPrice` = '456000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Elm' ,`StreetNumber` = '98' ,`StreetSuffix` = 'Crescent' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4-bedroom home nestled in the heart of Alden Bridge in The Woodlands! This meticulously-maintained, one-owner home is quite versatile and sure to meet your family’s needs. Upon entry, you are greeted by high ceilings in the foyer that flow gracefully into a large and bright family area. The kitchen, which opens into the family room, has fine, finishing touches including granite countertops, tile backsplash, and stainless steel appliances. Stunning, engineered hardwood grace the floors of the foyer, dining, kitchen and living room. Withdraw into the large master suite featuring double vanities, separate tub & shower and an expansive walk-in closet. You\'ll find three generous bedrooms upstairs including a spacious game room. This home boasts a covered patio in the back and a beautifully lush garden & private sitting area situated in the front side yard. Convenient access to Hwy 242, I-45, The Grand Parkway, and all of the fine amenities that The Woodlands has to offer.' ,`Acres` = '0.1928' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 02, BLOCK 1, LOT 24' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DAVID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br' ,`TaxAmount` = '6343' ,`TaxRate` = '2.1269' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493805' WHERE `Matrix_Unique_ID` = '213323036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:52:01.293' ,`MLSNumber` = '11004731' ,`ListAgentFullName` = 'William Lozada' ,`ListOfficeName` = 'Las Lomas Realty Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678281' ,`Longitude` = '-95.730997' ,`PhotoCount` = '20' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Larkspur' ,`StreetNumber` = '20130' ,`StreetSuffix` = 'Landing' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1913' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! We invite you tour this charming 4 bed 2 bath home in the beautiful Waterview Estates subdivision located in Richmond Tx. Features include an open floor plan with ample walkways and plenty of natural lighting along with an kitchen island and a cozy living area to pass time with family and friends. Conviniently located with 99 and Westpark Toll within the proximity, along with various shopping centers and resturants to visit! Master room includes double vanities, a garden bath-tub and a seperate walk-in shower. You have to come see it for yourself!' ,`Acres` = '0.1242' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WATERVIEW ESTATES SEC 2, BLOCK 1, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5412' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'NEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Waterview Estates Sec 2' ,`TaxAmount` = '5748' ,`TaxRate` = '2.8929' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493805' WHERE `Matrix_Unique_ID` = '213334696' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213344833','1665493805','213344833','2022-10-11T07:33:49.260','33182156','Cathey Granello','BHGRE Gary Greene','','','29.810682','-95.397329','44','77008','15','1150000.00','Active','26th','203','Street','Houston','2','1','3','3010','Single-Family','EXQUISITE CRAFTSMAN STYLE HEIGHTS CUSTOM HOME THAT RIVALS NEW CONSTRUCTION AND OOZES SOUTHERN CHARM W FRONT AND BACK PORCHES & TREED BACKYD LARGE ENOUGH FOR POOL & PLAYGRD! SUPERIOR QUALITY FROM THE PIERS ON SLAB TO THE DETAILS OF THIS GREAT OPEN DESIGN FLR PLAN W GRAND FOYER 9-10\' CEILINGS AND 8\' STAINED DRS. RICH SOLID OAK FLRS THRU OUT. GREAT WALL SPACE FOR ARTWORK. FORMAL LIVING OR STUDY, LARGE DR. WONDERFUL FOR ENTERTAINING W IT\'S OPEN CONCEPT LIVING AREA SPACES, FABULOUS CHEF DREAM KIT W HUGE CARRERA MARBLE ISLD OVERLOOKING DEN & MAIN LIVING. STAINLESS REFRIGERATOR, GAS COOKTOP W GRIDDLE & LARGE OVEN, CUSTOM BUILTINS, LIGHT & BRIGHT. BUTLERS PANTRY BAR W WINE CHILLER & CABINETS. LARGE PRIMARY MASTER W ROOM FOR A SITTING AREA, WALK IN CLOSET, ELEGANT ENSUITE MARBLE BATHRM W JETTED TUB, SEAMLESS SHOWER & HIS/HER VANITIES. LARGE UTILITY RM EQUIPPED W WASHER/DRYER. COME & SEE THIS METICULOUSLY MAINTAINED HOME NEAR ALL THE HEIGHTS HAS TO OFFER! YOU WILL NOT BE DISAPPOINTED!','0.1227','9','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Corporate Listing','1','','','Heights/Greater Heights','Central Gas,Zoned','0','LT 31 & TR 32 BLK 33 SUNSET HEIGHTS','Wooded','5345','Appraisal District','','','0','','2','Convection Oven,Electric Oven,Freestanding Oven,Single Oven','0','','','Gas Cooktop,Gas Range,Grill','','Composition','27 - Houston','HELMS ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HAMILTON MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required','Builder','2','Craftsman,Traditional','Sunset Heights','19979','2.3307','Public Sewer,Public Water','2014','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:00:20.483' ,`MLSNumber` = '82080330' ,`ListAgentFullName` = 'Nicole Handy' ,`ListOfficeName` = 'Braden Real Estate Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.470115' ,`Longitude` = '-95.463742' ,`PhotoCount` = '19' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '264990.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Rubia' ,`StreetNumber` = '7818' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1263' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DR Horton, America\'s #1 Builder! NEW CONSTRUCTION Ashburn Plan with Elevation L, features a modern design and offers 3 spacious bedrooms and 2 bathrooms, covered patio and 2-car garage! This open concept home has a stunning kitchen which includes quartz countertops, 42\" cabinets, and stainless & steel appliances. Delight yourself in the primary bathroom, with dual sinks, separate shower, garden tub (on select inventory homes) and a large walk-in closet! (All information provided by builder). Located in Rosharon\'s newest DR Horton Community, Caldwell Ranch this gorgeous community will feature a resort-style pool, Covered Pavilion with Picnic Tables, Splash areas, Water Slides, Soccer Fields, and miles of walking trails. Visit our onsite sales center today! Listing photos are of a similar floor plan. Finishes may vary and are subject to change. Calle Martin: 832-264-8768' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Caldwell Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665493805' WHERE `Matrix_Unique_ID` = '213372603' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:38:52.833' ,`MLSNumber` = '70731820' ,`ListAgentFullName` = 'Kristi Nations' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Catherine Perkins' ,`SellingOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`Latitude` = '29.513269' ,`Longitude` = '-95.014142' ,`PhotoCount` = '35' ,`PostalCode` = '77573' ,`RoomCount` = '10' ,`ListPrice` = '750000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mallorca' ,`StreetNumber` = '2405' ,`StreetSuffix` = 'Pass' ,`City` = 'League City' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '5081' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautifully updated home situated on a large lot and zoned to the highly desirable CCISD Education Village. Impressive kitchen with granite counter tops, an island and a breakfast bar. The kitchen is open to the family room perfect for entertaining. Two bedrooms down including the spacious primary bedroom with an updated bath. The second floor boasts an expansive game room with a separate seating area. Four bedrooms up, three recently updated bathrooms and a play room. The media room has a full projector, dishwasher and sink. Vacation year around in your spectacular backyard. Covered patio with an in-line gas grill, refrigerator, sink, Sonos speakers and two TV\'s. An enormous saltwater heated pool with a spacious hot tub. Enjoy your evenings around the custom built firepit. There is still plenty of room for the kids to play on the swingset or jump on the trampoline. Two AC\'s have been rebuilt like new along with a dehumidifier for the entire home.' ,`Acres` = '0.354' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MAR BELLA SEC 9-B (2011) ABST 32, BLOCK 1, LOT 3, ACRES 0.35' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '15422' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mar Bella' ,`TaxAmount` = '15835' ,`TaxRate` = '2.7997' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493806' WHERE `Matrix_Unique_ID` = '213381133' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:08:02.750' ,`MLSNumber` = '37181317' ,`ListAgentFullName` = 'Michael Seder' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.182179' ,`Longitude` = '-95.549079' ,`PhotoCount` = '38' ,`PostalCode` = '77382' ,`RoomCount` = '13' ,`ListPrice` = '1175000.00' ,`Status` = 'Active' ,`StreetName` = 'Stanwick' ,`StreetNumber` = '15' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This impeccably maintained custom home on a cul-de-sac street in Sterling Ridge offers stunning curb appeal! A sweeping wrought iron staircase leads you to a private home office with French doors, crown moulding, built-in desk and shelving; the formal dining has cove lighting and plantation shutters; a formal living area features a wall of windows framing your backyard pool views; butler\'s pantry with wine chiller; the open concept kitchen with center island, planning desk, walk-in pantry, double oven and warming drawer overlooks the sunny breakfast room and den with stacked stone gas log fireplace, and consistent travertine flooring is great for pets and kids. Owner\'s retreat and 2nd bedroom down; three bedrooms, media and game room up; three car attached garage + porte-cochere; the meticulously landscaped backyard has a covered patio, outdoor kitchen, gorgeous pool and spa. Close to area parks, walking/bike trails, shopping and restaurants, and zoned to exemplary schools!' ,`Acres` = '0.2522' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL STERLING RIDGE 03, BLOCK 1, LOT 36' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '10986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Sterling Ridge 03' ,`TaxAmount` = '17635' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493806' WHERE `Matrix_Unique_ID` = '213382278' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:29:10.210' ,`MLSNumber` = '98791395' ,`ListAgentFullName` = 'Judy Johnson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815938' ,`Longitude` = '-95.507464' ,`PhotoCount` = '43' ,`PostalCode` = '77080' ,`RoomCount` = '7' ,`ListPrice` = '735000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Kolbe' ,`StreetNumber` = '8717' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3231' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Home, in a Stunning Community! Kolbe Farms home that rivals new construction. Former model home. Tremendous Lake Views. Urban Farmhouse style home with wrap around living room porch, and wrap around primary bedroom balcony, all with lake views. Large yard overlooks the lake. First floor living, fireplace,12 ft ceilings, large dining room, large kitchen island with 5 burner Bosch cooktop, Giant pantry. Fantastic Shiloh Cabinetry soft close drawers and cabinets. Wide plank wood floors throughout. Plantation shutters. Wet bar with wine refrigerator and Surround sound in game room leads to 3rd floor terrace with fireplace. inside an appx. 40 Acre Community in Spring Branch known as Kolbe Farms. 3 Acre Lake/Park Area with Jogging/Walking Trails. Has Both Adult and Kids Pool. Dog Park. Gated community. Smart. Green. Healthy Built with 2x6 Exterior Walls, Tankless WH, CertainTeed AirRenew Drywall (Mold & Water Resistant), 16 Seer 2SP A/C. Home Automation Capabilities.' ,`Acres` = '0.0735' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 52 BLK 2 KOLBE FARMS' ,`LotDesciption` = 'Corner,Subdivision Lot,Water View' ,`LotSize` = '3200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Kolbe Farms Sub' ,`TaxAmount` = '12139' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493806' WHERE `Matrix_Unique_ID` = '213389509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:57:36.643' ,`MLSNumber` = '16703748' ,`ListAgentFullName` = 'Garrett Mohnke' ,`ListOfficeName` = 'Complete Property Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.049032' ,`Longitude` = '-95.395577' ,`PhotoCount` = '19' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Earlmist' ,`StreetNumber` = '23415' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2096' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently updated split level 4-2-2 in Timber Lane with large yard and deck.' ,`Acres` = '0.1653' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 50 TIMBER LANE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PEARL M HIRSCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane' ,`TaxAmount` = '5175' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493806' WHERE `Matrix_Unique_ID` = '213412061' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213430644','1665493806','213430644','2022-10-11T07:19:53.170','89787876','Sachin Chowdhry','OctoGen Real Estate Group','','','29.702429','-95.471029','45','77401','12','1350000.00','Active','Willow','5203','Street','Bellaire','4','1','5','4150','Single-Family','Open country feel on an oversized 12,325 sf lot, 5203 Willow sits on a large lot with great views. Spacious 5 bedroom home with 4.5 baths. Hardwood floors down and new carpet upstairs. Formal dining room and ground-floor study/library. Exquisite island kitchen equipped with high-end appliances. Living room with corner gas log fireplace. A wet bar with wine area adds to the entertainment value.The gorgeous primary bedroom suite is located on the second floor, with four additional bedrooms and a large media/gameroom upstairs. Fully-fenced back yard with porch and an amazing oversized pool for a game of volleyball or water polo for kids. The oversize lot of 12000 plus square feet allows an open green space for kids to play. Mosquito repellant spray system installed in the yards. Conveniently located, 50 yards from the Bellaire Recreation Center and City Hall, close to the freeways and many restaurants.. Zoned to Bellaire High School and NEVER FLOODED.','0.2829','17','','','Electric Dryer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Bellaire Area','Central Gas','0','LT 2 & TR 2A BLK 50 BELLAIRE AMENDED','Subdivision Lot','12325','Appraisal District','','','0','','2','Convection Oven','1','Heated,In Ground','','Gas Cooktop','','Composition','27 - Houston','CONDIT ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Appointment Required','Appraisal District','3','English','Bellaire Amd','20571','2.2271','Public Sewer,Public Water','1995','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:52:39.483' ,`MLSNumber` = '32750896' ,`ListAgentFullName` = 'Lori Van Joslin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.215355' ,`Longitude` = '-95.449897' ,`PhotoCount` = '28' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Hockenberry' ,`StreetNumber` = '75' ,`StreetSuffix` = 'Place' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1477' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*****Priced to sell QUICKLY***** sold as-is. Great opportunity to own in The Woodlands for under $230,000. Must see – this will not last. Contract MUST close on or before November 10, 2022. 1 story, 3 bedrooms, 2 full bathrooms, 2 car-garage, covered back patio, small back-yard pond/waterfall. Owner is willing to sell all furniture separately. Harpers Landing residents enjoy awesome amenities such as; playground, park, pool, splash pad, tennis & basketball courts, soccer field, baseball/softball field, walking trails & dog park. Location is literally minutes to all major Woodlands amenities and major highways.' ,`Acres` = '0.1278' ,`Area` = '15' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S970116 - WDLNDS HARPER\'S LND COLLEGE PK 16, BLOCK 1, LOT 61' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5566' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'POWELL ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Harpers Lnd College Park' ,`TaxAmount` = '4026' ,`TaxRate` = '2.2719' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493806' WHERE `Matrix_Unique_ID` = '213462732' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213465409','1665493807','213465409','2022-10-11T06:33:08.430','59967673','Jared Turner','Turner Mangum,LLC','','','30.167556','-95.578323','34','77354','7','349990.00','Active','Courageous Side','200','Way','Magnolia','2','1','4','2387','Single-Family','Charming 2-Story Home in the highly sought-after Lakes At Black Oak, a quiet, tranquil community skirting the edges of Magnolia, offering quick access to The Woodlands and many nearby attractions. The home sits in a quiet cup-de-sac, oversized homesite, offering 4 Bedrooms | 2.5 Baths with the primary bedroom downstairs. The living area features an open concept floor plan, filled with natural light. A large island w/sitting counter and adjacent dining area, overlooking a comfortable living space. A formal dining sits at the front of the home, easily functioning as a study/office if desired. The primary bedroom possesses a large walk-in closet w/ direct access to the laundry room! 3 secondary bedrooms | game room | 1 Full bath sit upstairs! LARGE & PRIVATE backyard w/ surrounding mature trees to enhance that serene setting! The community amenities include a park, splash pad, man-made lake, and a serene setting to call home!','0.1726','15','Rausch Coleman','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Magnolia/1488 East','Central Gas','1','S263891 - BLACK OAK 01 PARTIAL REPLAT NO 2, BLOCK 1, LOT 12','Subdivision Lot','7518','Appraisal District','','748','0','','2','Gas Oven','0','','','Gas Range','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Appraisal District','2','Traditional','Black Oak','8037','3.1087','Public Sewer,Public Water','2020','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:48:33.863' ,`MLSNumber` = '52799644' ,`ListAgentFullName` = 'Hal Bazar' ,`ListOfficeName` = 'Green & Associates Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.562707' ,`Longitude` = '-95.581696' ,`PhotoCount` = '50' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Baywater Park' ,`StreetNumber` = '4218' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3270' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to paradise! This ultimate entertainment home sits on a huge 17,000 +/- sq ft premium lot in the very sought after Riverstone Community! The backyard oasis is surrounded by a massive greenbelt that provides peaceful seclusion and a feel that you\'re in the country! This property is packed full of upgrades both inside & out that any homeowner would appreciate and we would love to share! The interior boasts an open concept that provides backyard views from almost every room, huge living room with soaring ceiling + rock fireplace, spacious formal dining + additional breakfast area, amazing island kitchen w/ stainless appliances, split bedroom floorplan, gorgeous primary suite, primary bath with soaking tub + separate shower, ample sized spare bedrooms, study could be 5th bedroom if needed. The massive backyard boasts a custom, oversized, heated Maddox Pool & heated spa with a weeping wall & moss rock waterfall. Tons of Travertine decking, and a covered patio!' ,`Acres` = '0.3887' ,`Area` = '29' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERSTONE NORTH SEC 5, BLOCK 1, LOT 30' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Greenbelt' ,`LotSize` = '16933' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SETTLERS WAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverstone North Sec 5' ,`TaxAmount` = '12223' ,`TaxRate` = '2.4529' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493807' WHERE `Matrix_Unique_ID` = '213494273' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213503236','1665493807','213503236','2022-10-11T07:40:24.560','38647548','Holli Evans','Keller Williams Premier RealtyKaty','','','30.237042','-95.878638','42','77484','9','799900.00','Active','Arena','29060','Drive','Waller','2','1','3','3156','Single-Family','WELCOME to this PRISTINE home nestled on almost 4.5 acres in Waller. Immaculately maintained, this 1-story home offers 3 spacious bedrooms, 2.5 bathrooms & attached 3-car garage. Step inside & FALL IN LOVE w/ the timeless features including bright windows w/ natural light, tall tray ceilings, crown molding, slate & hardwood floors & built-in custom cabinetry! Enjoy a fully equipped chef-inspired kitchen w/ large island & breakfast bar, dark Granite w/ contrasting white Subway Tile, SS appliances, double ovens & luxe upgraded white cabinetry. The stunning private wing dedicated to the primary suite features a large bay window, remote pool access through French doors, ensuite bathroom & massive walk-in closet. Step outside & enjoy your newly renovated resort-style in-ground pool & spa, extensive covered patio, outdoor kitchen & sprawling green space w/ professional landscaping. This property is beaming w/ upgrades & updates! Excellent location w/ easy access to 249 & 1488. Zoned to WISD.','4.461','26','','','Electric Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Wood Burning Fireplace','2','Waller','Central Gas,Zoned','1','S758381 SADDLE CREEK FOREST 1 BLK 3 LOT 24R (REPLAT OF 24 &','Corner,Greenbelt,Subdivision Lot,Wooded','194321','Appraisal District','','775','0','','3','Double Oven,Gas Oven','1','Heated,In Ground','','Electric Cooktop','','Composition','55 - Waller','FIELDS STORE ELEMENTARY SCHOOL','WALLER HIGH SCHOOL','SCHULTZ JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Seller','1','Traditional','Saddle Creek Forest','12304','2.0243','Septic Tank,Well','2007','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213503291','1665493807','213503291','2022-10-11T06:15:14.350','49934288','Gayla Gayden','REALM Real Estate Professional','','','29.352263','-95.460276','8','77583','10','295990.00','Active','Golden Rubia','7730','Lane','Rosharon','2','0','3','1501','Single-Family','New Construction-New D.R. Horton Homes, America\'s #1 Builder! Dramatic Chic Stucco & Brick Elevation with Covered Back Patio! Stunning Entry W/Beautiful Wood Like Vinyl Throughout! Amazing Gourmet Kitchen W/Silestone Quartz Countertops, Stainless Steel Appliances W/Side By Side Refrigerator, Washer, Dryer, 2 Inches Faux Blinds, Eat-in Island with Stainless Steel Undermount Sink, Tall Shaker Cabinets, Beautiful Tile Backsplash & flows gracefully into your Casual Dining Area & Family Room W/Walls of Windows looking out to your Backyard! Private Primary Suite W/High Ceilings, His & Her Deep Undermount Sinks, Quartz Counters, Soaker Tub, Shower & Walk In Closet! Guest Bathrm W/Quartz Counters! Garage Door Opener! HERS Energy Rated, Tank-less Gas Water Heater! The Smart Home Automation System allowing you to control your home from anywhere with the Amazon Echo Dot! Amenity Center W/Pool, Lap Pool, Water Slides, Pavilion, Playground, Soccer Fields & more! Subdivision had No Flooding!','','5','D.R. Horton','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Rosharon','Central Gas','1','Caldwell Ranch Lot: 1 Block: 1','Subdivision Lot','','','','850','1','To Be Built/Under Construction','2','Gas Oven,Single Oven','0','','','Gas Range','','Composition','5 - Angleton','FRONTIER ELEMENTARY SCHOOL','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Leave Business Card,No Appointment Required,No Supra Keybox,Vacant/Unoccupied','Builder','1','Contemporary/Modern,Ranch','Caldwell Ranch','','','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T07:28:59.727' ,`MLSNumber` = '33502521' ,`ListAgentFullName` = 'Judy Burfict' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.686141' ,`Longitude` = '-95.329530' ,`PhotoCount` = '9' ,`PostalCode` = '77033' ,`RoomCount` = '4' ,`ListPrice` = '100000.00' ,`Status` = 'Active' ,`StreetName` = 'Southlea' ,`StreetNumber` = '5925' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '822' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single family home with two bedrooms and one bath. Large backyard and beautiful landscaped front yard. Great investment property, family home or starter home with needed repair and updating. Conveniently located near 610, Medical Center, Hobby Airport.' ,`Acres` = '0.1653' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 27 BLK 12 SOUTHCREST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KELSO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southcrest Sec 01' ,`TaxAmount` = '1083' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493807' WHERE `Matrix_Unique_ID` = '213503526' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:33:56.727' ,`MLSNumber` = '11590029' ,`ListAgentFullName` = 'Tiffany Franklin' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018121' ,`Longitude` = '-95.386926' ,`PhotoCount` = '26' ,`PostalCode` = '77073' ,`RoomCount` = '10' ,`ListPrice` = '238922.00' ,`Status` = 'Active' ,`StreetName` = 'Copra' ,`StreetNumber` = '2802' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1771' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2548' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 131 BLK 8 WESTFIELD GLEN' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11101' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Glen' ,`TaxAmount` = '4712' ,`TaxRate` = '2.6145' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493807' WHERE `Matrix_Unique_ID` = '213515696' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-11T06:03:15.277' ,`MLSNumber` = '14876921' ,`ListAgentFullName` = 'Janetta Penn' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051305' ,`Longitude` = '-95.156898' ,`PhotoCount` = '0' ,`PostalCode` = '77345' ,`RoomCount` = '12' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Seven Maples' ,`StreetNumber` = '2103' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Klotz beauty in prestigious Kings Point, steps away from award winning schools! Soaring 2 story entry/double wrought iron front door! Lushly landscaped backyard paradise w/rec. re-plastered pool/spa/cool decking; located on OS corner lot *recent 150K upgrades including: triple panel windows dnstrs, plant. shutters, luxurious engineered wood flooring dnstrs; evap coil, hot water heaters, condenser, ductwork; pool automation; bonus room up; inviting French doored study w/f/p; dual sized f/p separates formal/family room *DID NOT FLOOD! Bonus room !' ,`Acres` = '0.343' ,`Area` = '32' ,`BuilderName` = 'KLOTZ' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1 KINGS POINT VLG 1 AMEND R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '14932' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '585' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Pt Village Sec 01 Amd Place' ,`TaxAmount` = '14419' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665493807' WHERE `Matrix_Unique_ID` = '213519051' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213525277','1665493807','213525277','2022-10-11T06:25:29.530','45935275','Yvonne Bonner-Holley','Keller Williams Metropolitan','','','29.724390','-95.365585','17','77004','8','345000.00','Active','Ennis','4302','','Houston','2','1','3','2300','Single-Family','2 story townhome with modern elegance! Spacious bedrooms, 10ft ceilings, fireplace, hardwood flooring, upgraded fixtures, and more! The property shows beautifully. It is centrally located - minutes away from Medical Center, Downtown, and the area universities! The property is sold in as-is condition and is unrestricted. Perfect for Airbnb or student rental potential.','','4','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','University Area','Central Gas','0','LT 1 BLK 1 UNIVERSITY T/H AMEND','Subdivision Lot','2275','Appraisal District','','','0','','2','Gas Oven','0','','','Freestanding Range','','Composition','27 - Houston','LOCKHART ELEMENTARY SCHOOL','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required,Leave Business Card,Supra Keybox','Builder','2','Traditional','University','0','2.99125','Public Sewer,Public Water','2005','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213525288','1665493807','213525288','2022-10-11T06:26:50.430','5306745','Lorena Martinez','J Perez Properties','','','28.714167','-96.223362','6','77465','1','399900.00','Active','Henderson','910','Street','Palacios','1','0','1','1438','Single-Family','','2.5','54','','','','','Other Disclosures','','','','','Other Heating','0','AB 0162, L GOODWIN, ACRES 2.5, AB 162 N450\' E/2 LOT 5 2.50AC','Other','108900','Appraisal District','','','0','','0','','0','','','','','Composition','156 - Palacios','CENTRAL ELEMENTARY SCHOOL (PALACIOS)','PALACIOS HIGH SCHOOL','PALACIOS JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Other Style','n/a','3940','2.7105','Public Sewer,Public Water','1961','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213525541','1665493807','213525541','2022-10-11T07:42:52.260','51859491','Walter Cole','Coldwell Banker Realty','','','29.963520','-95.625648','28','77429','6','439990.00','Active','Lakecrest','13526','Drive','Cypress','2','0','3','1752','Single-Family','Here is a rare opportunity to own a modern smart home that shows like a model. The home sits on a heavily wooded 12,800 SF lot where you can watch the deer with your morning coffee from your exterior balcony. The kitchen offers a large quartz island with gas cooktop, breakfast bar, oven, microwave and fridge. Smart home features include ring doorbell, cameras, smart locks, remote gate, surround sound system, lights and thermostat. The oversized living room has 10-14 foot ceilings and features a LED fireplace that can be ambient to provide heat. The home offers 3 bedrooms, 2 bathrooms and an additional loft area perfect for guests or office area. The master shower offers double sinks and an oversized steam shower. The large exterior deck area offers a projection screen if you would like to take in an evening movie in the fresh air. There is a raised deck under the home for storage and there are two gates that secure the home and one of the gates can be opened remotely with your phone.','0.2938','10','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','1','Cypress North','Central Gas','1','LT 32 BLK 6 SARACEN PARK SEC 3','Wooded','12800','Appraisal District','','709','0','','0','Electric Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Contemporary/Modern','Saracen Park Sec 03','5890','2.5737','Public Sewer','2013','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213525751','1665493808','213525751','2022-10-11T07:48:16.110','4557159','Teri Walter','K. Hovnanian of Houston II, LL',' Non-MLS Agent','Non-MLS ','29.597964','-95.805246','15','77471','9','390000.00','Pending Continue to Show','Mason','6015','Way','Rosenberg','2','0','3','2063','Single-Family','Stunning one-story Juniper II home design features 3 bedrooms, 2 baths and 2 car attached garage. Convenient home office located across from great room. Beautiful maple cabinets, granite countertops and island in gourmet kitchen. Huge walk-in closet, double sinks, separate tub and shower in owner\'s bath. Covered patio in backyard, perfect for entertaining. \r\nEnjoy the convenience of the community\'s Recreation Center, Lakes and Parks. Kingdom Heights in Rosenberg is conveniently located between Sugar Land and Katy/Fulshear with easy access to the major Highway 99 (Grand Pkwy). Offered by: K. Hovnanian of Houston II, L.L.C','','30','K. Hovnanian Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Fort Bend County North/Richmond','Central Gas','1','9/4/6','Subdivision Lot','7000','Survey','','665','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','FROST ELEMENTARY SCHOOL (LAMAR)','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Builder','1','Traditional','Kingdom Heights','','2.7948','Public Sewer,Public Water','2022','Builder'); --> New record created successfully