Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:02:47.710' ,`MLSNumber` = '73711263' ,`ListAgentFullName` = 'Jeffrey Welch' ,`ListOfficeName` = 'Welch Realty Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834722' ,`Longitude` = '-95.371906' ,`PhotoCount` = '23' ,`PostalCode` = '77022' ,`RoomCount` = '6' ,`ListPrice` = '319900.00' ,`Status` = 'Active' ,`StreetName` = 'Julia' ,`StreetNumber` = '253' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prime location minutes from downtown and the Galleria. Down the street from the north rail line terminus - connecting you to everything in the city including downtown, the museum district, the medical center, the theater, sports stadiums, and the University of Houston. Walking distance from the rail line, HCC, and shopping/restaurants. Brand new development with modern design and a dog park. You will fall in love with this 3 bedroom, 2 1/2 bath home featuring an open floor plan and beautiful kitchen. The first floor will have vinyl flooring and the stairs and the second floor will have carpet. the Interest list forming - Only 15 homes prices ranging from $290,000-$325,000, these won’t last long at these prices! These are not townhomes they are detached single-family homes.' ,`Acres` = '0.0528' ,`Area` = '9' ,`BuilderName` = 'Deacon Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 JULIA FIRST ESTATE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2289' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JANOWSKI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM HOUSTON MATH SCIENCE AND TECHNOLOGY CENTER' ,`SchoolMiddle` = 'BURBANK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Julia First Estate' ,`TaxAmount` = '' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668008631' WHERE `Matrix_Unique_ID` = '209083373' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:39:33.110' ,`MLSNumber` = '81463744' ,`ListAgentFullName` = 'Chandra Jones' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = 'Pedro Martinez' ,`SellingOfficeName` = 'City Group' ,`Latitude` = '29.545364' ,`Longitude` = '-95.486486' ,`PhotoCount` = '37' ,`PostalCode` = '77545' ,`RoomCount` = '5' ,`ListPrice` = '295000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Bravos Manor' ,`StreetNumber` = '2146' ,`StreetSuffix` = 'Lane' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STOP THE SEARCH! Cozy 3 bedroom and 2 bathroom one-story home is nestled on a cul-de-sac. The home is very well maintained and in an incredible location with easy access to Fort Bend Toll & 288, shopping and restaurants. This DR Horton home provides a huge primary bedroom with an upgraded bathroom which features custom cabinets and a HUGE walk-in shower. Granite countertops in kitchen with gas range. Stainless refrigerator and washer & dryer are included. The home also has a sprinkler system. The community provides a pool, walking trails and a park so you can become one with nature. DEFINITELY COME SEE THIS GEM, you will be glad you did!' ,`Acres` = '0.1739' ,`Area` = '38' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAMBRIDGE FALLS SEC 10, BLOCK 3, LOT 55' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7575' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PARKS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cambridge Falls Sec 10' ,`TaxAmount` = '5068' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008632' WHERE `Matrix_Unique_ID` = '211157857' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:17:52.640' ,`MLSNumber` = '38196254' ,`ListAgentFullName` = 'Randy Polasek' ,`ListOfficeName` = 'Impression Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.667383' ,`Longitude` = '-95.749023' ,`PhotoCount` = '38' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '399977.00' ,`Status` = 'Active' ,`StreetName` = 'Lone Star Junction' ,`StreetNumber` = '7507' ,`StreetSuffix` = 'Street' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2587' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**50K PRICE REDUCTION FOR A QUICK SALE**RARE FIND! 1.5 STORY WITH 3 BEDROOMS DOWN+OFFICE/STUDY+FORMAL DINING+GAMEROOM UP WHICH COULD BE USED AS A 4TH BEDROOM **BRAND NEW ROOF IN 2022** GRAND ENTRYWAY LEADS TO LARGE FAMILY ROOM WHICH IS OPEN TO KITCHEN*SOLID GRANITE COUNTERTOPS*STAINLESS STEEL APPLIANCES*GAS COOKTOP*ABUNDANCE OF CABINETS & PLENTY OF COUNTER SPACE*IMPRESSIVE FRONT ELEVATION BOASTS STUCCO & STONE*COVERED FRONT & BACK PATIO*BEAUTIFUL LANDSCAPING* MODERN UPDATES THROUGHOUT*THE NEIGHBORHOOD COMES WITH ACCESS TO SEVERAL COMMUNITY POOLS, GORGEOUS WALKING TRAILS, GYM, TENNIS COURT, AND COVERD PAVILION. MAKE THIS YOUR PLACE TO CALL HOME AND SCHEDULE YOUR PRIVATE SHOWING BEFORE THIS GEM IS SNATCHED UP AS WELL!' ,`Acres` = '0.1763' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LONG MEADOW FARMS SEC 1, BLOCK 2, LOT 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '875' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Long Meadow Farms' ,`TaxAmount` = '6671' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008632' WHERE `Matrix_Unique_ID` = '211422528' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:20:01.227' ,`MLSNumber` = '7236951' ,`ListAgentFullName` = 'Amy Vanterpool' ,`ListOfficeName` = 'Elite 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.136872' ,`Longitude` = '-95.061072' ,`PhotoCount` = '20' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Martes' ,`StreetNumber` = '22903' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All one level three bedrooms two bathrooms, canal front home in Terramar Beach. Windows have storm shutters you will really enjoy all the deck and patio space as well as the downstairs storage and yard area. Terramar community offers a pool, boat ramp, beach access, frisbee golf course, and pavilion area. Terramar is close to Sea Isle restaurant, marina, & stores. Buyer to verify room dimensions and details of the property. Everything stays with the sale of the property. Property is being sold AS IS.' ,`Acres` = '0.123' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 12 LOT 6 BLK 8 TERRAMAR BEACH SEC 4' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`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` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Terramar 4' ,`TaxAmount` = '7438' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008632' WHERE `Matrix_Unique_ID` = '211902844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:32:30.237' ,`MLSNumber` = '58282094' ,`ListAgentFullName` = 'D\'Ann Fleming' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.672209' ,`Longitude` = '-95.184494' ,`PhotoCount` = '27' ,`PostalCode` = '77502' ,`RoomCount` = '9' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Memorial' ,`StreetNumber` = '1908' ,`StreetSuffix` = 'Court' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2167' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for that home with the four bedroom and master bedroom on first floor with a pool? Look no further, this is the one for you. Detached garage with storage shed behind garage and extra yard space. Gazebo to sit and relax in the evenings with a great pool for entertaining. Master bedroom and additional room on first floor. Upgrades include:Interior Plumbing, master bathroom renovations, AC and furnace, pool light, tile flooring, carpet in master bedroom, security fence around pool and more. Driveway has additional parking with the detached garage. Options on upstairs carpet to be replaced. Great location with all your needs surrounding you. Make your appointment today and bring your offers!!!' ,`Acres` = '0.2283' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 50 BLK 4 PARKVIEW ESTATES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FISHER ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkview Estates Sec 03' ,`TaxAmount` = '4857' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008632' WHERE `Matrix_Unique_ID` = '212177385' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T05:57:23.380' ,`MLSNumber` = '76352891' ,`ListAgentFullName` = 'Michele Flory' ,`ListOfficeName` = 'Point Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151607' ,`Longitude` = '-95.532672' ,`PhotoCount` = '49' ,`PostalCode` = '77389' ,`RoomCount` = '15' ,`ListPrice` = '1695000.00' ,`Status` = 'Active' ,`StreetName` = 'Badger Lodge' ,`StreetNumber` = '46' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity in this impeccably maintained custom home with a resort feel in this gated community! Difficult to find all of this at this price point! Enjoy the Carlton Woods lifestyle living with golfing, tennis, dining in or on a patio, music venues, walking, bike rides...all at your fingertips! Gorgeous views of recent built pool & private backyard! If you work from home, you will find the views of the pond from the study peaceful & relaxing, even in the most stressful times. Entertaining is natural in this home w/large foyer that flows into formal dining, living area, kitchen, wet bar & out to the pool...so inviting for guests & yet so comfortable for the family. Enjoy nature w/wildlife around the pond, including a bald eagle! Primary suite offers views of pool & gardens & the bath is luxurious w/a closet that offers space for stackable washer & dryer. Upstairs bedrooms are great size. Just a few minutes to John Cooper & several shopping areas. Life just became easier!' ,`Acres` = '0.3549' ,`Area` = '14' ,`BuilderName` = 'Kingman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 THE WOODLANDS CARLTON WOODS CREEKSIDE 4 IN THE V' ,`LotDesciption` = 'Greenbelt,In Golf Course Community,Water View' ,`LotSize` = '15461' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '4750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'TIMBER CREEK ELEMENTARY SCHOOL (Tomball)' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Carlton Woods Creekside' ,`TaxAmount` = '28768' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668008633' WHERE `Matrix_Unique_ID` = '212311267' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:09:42.657' ,`MLSNumber` = '60205541' ,`ListAgentFullName` = 'Ayo Oluwi' ,`ListOfficeName` = 'J. Lindsey Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.548902' ,`Longitude` = '-95.799830' ,`PhotoCount` = '27' ,`PostalCode` = '77471' ,`RoomCount` = '3' ,`ListPrice` = '236000.00' ,`Status` = 'Active' ,`StreetName` = 'Madison' ,`StreetNumber` = '2601' ,`StreetSuffix` = 'Avenue' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in a great neighborhood with a private pool and fireplace.New floor, new washable paint and fittings (2022)with Quartz counter top in the kitchen.Primary bedroom is very spacious and the house layout is very welcoming.' ,`Acres` = '0.1834' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CAMBRIDGE VILLAGE SEC 1, BLOCK 2, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7991' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'RAY ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'TERRY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO/GEORGE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Cambridge Village Sec 1' ,`TaxAmount` = '4026' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008633' WHERE `Matrix_Unique_ID` = '212401167' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:59:56.037' ,`MLSNumber` = '75368879' ,`ListAgentFullName` = 'Jerri Alonzo' ,`ListOfficeName` = 'Keller Williams Heritage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783458' ,`Longitude` = '-94.910652' ,`PhotoCount` = '30' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandy Creek' ,`StreetNumber` = '6007' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2493' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '\"Home Sweet Home\" is the feeling you get when you enter this exceptional 4 bedroom, 2 and half bathroom, with a game room. New roof and water heater. Generous family room adjoins kitchen with recently installed: kitchen cabinets, new countertops, new dishwasher, new stove. Breakfast nook and double door pantry. Spacious game room, with three additional bedrooms and additional bath located on second floor. The primary bedroom, located on main floor, is very spacious and bathroom has a large closet as well as a walk-in shower. NO backyard neighbors. Did I mention, it has an Epoxy garage floor. Minutes from the elementary school. LOW TAXES! Located Chambers County. Located close to shopping, entertainment, and dining. Right off Hwy 146 and close to I-10.' ,`Acres` = '0.127' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BK 1 LT 2 DEVINWOOD PHASE I' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5532' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Devinwood Ph 01' ,`TaxAmount` = '5661' ,`TaxRate` = '2.9232' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008633' WHERE `Matrix_Unique_ID` = '212484552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:08:36.390' ,`MLSNumber` = '31134051' ,`ListAgentFullName` = 'Travis Foote' ,`ListOfficeName` = 'Ineto Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062232' ,`Longitude` = '-95.462917' ,`PhotoCount` = '33' ,`PostalCode` = '77388' ,`RoomCount` = '6' ,`ListPrice` = '281602.00' ,`Status` = 'Active' ,`StreetName` = 'Spring Bluff' ,`StreetNumber` = '20530' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2142' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nicely updated 3 Bedroom one story in Klein ISD. Formal Dining, Formal Living areas. Hardwood floors. High ceilings. Irrigation system. French drain. Great location within 5 min drive to 45. New interior paint and carpeting. New Microwave. Roof replaced in 2021, warranty transfers to new owner. Furnace replaced 2022. Ready for move in!' ,`Acres` = '0.1331' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 2 SPRING LANDING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5797' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KREINHOP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Lndg Sec 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008633' WHERE `Matrix_Unique_ID` = '212981051' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:19:21.807' ,`MLSNumber` = '98565951' ,`ListAgentFullName` = 'Telma Garcia' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = 'Luzcelia Collins' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.968115' ,`Longitude` = '-95.193799' ,`PhotoCount` = '30' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '299000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Kobuk Valley' ,`StreetNumber` = '17239' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fantastic one-story home combines desirable location, an open floor plan, and modern updates into one attractive package. Featuring 10-foot ceilings and hardwood or tile floors throughout(No Carpet!). This home also offers a newly remodeled stunning primary bathroom ! New fabulous custom closet! Recent new A/C and Water heater units. New fence in 2021, Exterior painted 2022. The open living and kitchen area includes energy-efficient s.s. appliances and plenty of room for cooking or entertaining. (Refrigerator stays) The large backyard and covered patio make grilling with the family a breeze. No Flooding here! Located in the highly desired community of Eagle Springs and situated in a family-friendly cul-de-sac. This perfect home is also conveniently close to lots of shopping and restaurants & easy access to Beltway 8 and Hwy 59. Neighborhood amenities include 24-hour fitness center, resort style pools, sports fields, splash pad, several parks, and more!' ,`Acres` = '0.1515' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 EAGLE SPRINGS SEC 19' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '5905' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008633' WHERE `Matrix_Unique_ID` = '213393823' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:17:13.483' ,`MLSNumber` = '65761962' ,`ListAgentFullName` = 'Betty Herndon' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = 'Pauline Worth' ,`SellingOfficeName` = 'Keller Williams RealtyNortheast' ,`Latitude` = '30.638230' ,`Longitude` = '-95.119352' ,`PhotoCount` = '40' ,`PostalCode` = '77331' ,`RoomCount` = '6' ,`ListPrice` = '699000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lakeview Estates' ,`StreetNumber` = '1791' ,`StreetSuffix` = 'Drive' ,`City` = 'Coldspring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2331' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open Waterfront, A Beautiful Home with Views of Pine Island, you\'re going to Love It! Located in one of Lake Livingston\'s sought-after neighborhoods, you will enjoy spending your time here with family & friends. Boathouse has large cradle boatlift, a double jet ski lift, and a sitting area to enjoy the view. The Home was recently updated and has a Lovely \"Farmhouse Lodge Appeal. The Kitchen is the Heart of the Home, and this one will not disappoint with its Custom Cabinetry, High-end Stone Quartzite Counters, Large Farm Sink, Double Oven, Shiplap Walls, Rustic Beams, and Nice Lighting. Living Room has High Plank Ceiling, Rustic Beams, Beautiful Lighting, Large Windows, Wood Burning Stone Fireplace and flows off the Dining Area & Kitchen, making it a Great Place for Entertaining Family & Friends. Two Primary Bedroom Suites, one downstairs & one upstairs, both have Beautiful Custom Baths. Be sure to see the list of improvements made in 2019, and come see today, it won\'t last long.' ,`Acres` = '0.241' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEVIEW ESTATES #1, LOT 117, SECTION 1, ACRES .241' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '10498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeview Estates 1' ,`TaxAmount` = '7553' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008634' WHERE `Matrix_Unique_ID` = '213402735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:31:50.507' ,`MLSNumber` = '13078045' ,`ListAgentFullName` = 'Angela Easterbrook' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815625' ,`Longitude` = '-95.503868' ,`PhotoCount` = '29' ,`PostalCode` = '77080' ,`RoomCount` = '7' ,`ListPrice` = '609000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Kolbe' ,`StreetNumber` = '8623' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this stunning 3-story home located in Kolbe Farms of Houston, TX YOURS! Offering 3 spacious bedrooms, 3.5 bathrooms & an attached 2-car garage- this is the PERFECT home for who love to entertain! Impeccable curb appeal with a coastal chic exterior elevation, lush landscaping & fenced yard. Enter the home to find gorgeous light wood flooring, soaring 12-ft ceilings, double crown molding, bright windows, upgraded light fixtures, plantation shutters & custom bamboo shades. The home chef will love the expansive kitchen with sprawling Quartz countertops, high-end white cabinetry, large island with seating & SS appliances. Luxe amenities include a walk-up front porch, private primary suite balcony, rooftop terrace, game room & spa-inspired luxury primary suite. Excellent location near the Galleria, City Centre & Memorial City w/ 2 community pools, a 3-acre park w/ walking trails, a stunning lake & dog park all within the security of a MANNED GATE.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'InTown homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 6 KOLBE FARMS' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '2640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Kolbe Farms Sub' ,`TaxAmount` = '11375' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008634' WHERE `Matrix_Unique_ID` = '213504737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T05:28:20.910' ,`MLSNumber` = '65016126' ,`ListAgentFullName` = 'Esther Garcia' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.801321' ,`Longitude` = '-95.067596' ,`PhotoCount` = '25' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Clover' ,`StreetNumber` = '462' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1369' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Modern New Construction in Livingston on two lots! 3bed/2.5 bath home in gated waterfront community! Cedar Point has pool, playground, and boat launch. Great location about 10 miles from I-69.Open kitchen, dining, and living area great for entertaining!Kitchen boast of beautiful glass upper cabinets and under cabinet lighting.Kitchen includes beautiful countertops and backsplash, and pot filler! Stainless steel appliances are included! Smooth walls/ceilings in living room/kitchen, fireplace, charming tile wall in powder room, and wood look plank tile. Wood stairs with iron railing lead up to the second floor. Master bedroom has roaring high ceiling with large windows! Floor to ceiling tile in bathroom showers. Gorgeous over mount sinks in master bathroom with separate vanity area! Outdoor deck is excellent for entertaining! Other upgrades include custom garage and front door, pre-plumbing for water softener, portable generator disconnect, and stub out for future grill.' ,`Acres` = '0.2457' ,`Area` = '44' ,`BuilderName` = 'TX Home Transformers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR POINT SECTION 2 BLK 36 LOT 13 & Lot 14' ,`LotDesciption` = 'Ravine,Subdivision Lot' ,`LotSize` = '10700' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '610' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cedar Point Sec 2' ,`TaxAmount` = '258' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668008634' WHERE `Matrix_Unique_ID` = '213583962' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:06:00.457' ,`MLSNumber` = '57981761' ,`ListAgentFullName` = 'Amy Hoang' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.558646' ,`Longitude` = '-95.672943' ,`PhotoCount` = '45' ,`PostalCode` = '77479' ,`RoomCount` = '9' ,`ListPrice` = '739900.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Bend' ,`StreetNumber` = '2019' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exquisite, custom-built home with 4-bedroom, 4.5 bath home with 2-car attached garage located on an oversized, corner lot in the master planned community of Greatwood Shores. This spectacular home features a grand entrance, elegant and spacious formals, high-vaulted ceiling, island kitchen with granite countertops, floor-to-ceiling windows, and an open floor plan where the rooms flow seamlessly. The stunning Primary retreats are conveniently located on the first floor with an oversized ensuite bath, large walk-in closet with plenty of shelves and windows with panoramic views of the backyard. Fabulous, engineered wood flooring and ceramic tiling can be found throughout the downstairs of the home. Nicely sized backyard and covered patio extend the homes entertaining space. This home also features updates/upgrades: two A/C units, toilets, sinks, dishwasher, doors, bathtub sliding glass doors, paint & epoxy garage floor. Home is near highly-rates schools, pool, golf course and playground.' ,`Acres` = '0.2493' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'GREATWOOD SHORES SEC 4, BLOCK 2, LOT 10' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '10858' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '555' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'DICKINSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Greatwood Shores Sec 4' ,`TaxAmount` = '10796' ,`TaxRate` = '2.3013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008634' WHERE `Matrix_Unique_ID` = '213679160' --> 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','213724721','1668008635','213724721','2022-11-09T06:11:34.897','54123147','Zach Toth','Sprout Realty','','','30.023667','-95.752819','50','77433','9','1100000.00','Active','Bowdin Crest','17202','Drive','Cypress','5','1','5','4926','Single-Family','This beautiful home is located just minutes away from the Houston Premium Outlet Mall, fine dining, and is in close proximity to major highways; 99 and 290. In addition, this home is zoned to the highly accredited Cypress Fairbanks ISD. This spacious home sits on a large lot, just shy of 3/4 of an acre, and backs up to the neighborhood greenbelt (as well as a fully stocked pond with a water feature). No stone was left unturned in this backyard paradise! Some of its features include a huge 3 lane lap pool, a hot tub, fire pit, LED lighting, outdoor speakers, pergola with a motorized roof to allow the sun in or keep you out of the elements, mosquito misting system and a fully lit sports court. Off the back of the garage you will enjoy a 650 sq/ft air conditioned pool house equipped with a fully functional mini kitchen, a bathroom with a walk-in shower and a unique glass garage door that overlooks the sport court. This 5 BR home has so much to offer. Schedule your showing today!','0.6715','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','2','Cypress North','Central Gas','1','LT 76 BLK 1 LAKES OF FAIRHAVEN SEC 1','Subdivision Lot,Water View','29250','Appraisal District','','1100','0','','3','Electric Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','SWENKE ELEMENTARY SCHOOL','BRIDGELAND HIGH SCHOOL','SALYARDS MIDDLE SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Lakes/Fairhaven Sec 01','15454','2.2317','Other Water/Sewer','2005','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:27:40.867' ,`MLSNumber` = '92231686' ,`ListAgentFullName` = 'Evelyn Laniado' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675385' ,`Longitude` = '-95.830295' ,`PhotoCount` = '30' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Lilac Croft' ,`StreetNumber` = '10131' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home!!!! Gorgeous 2 story Brick and stone home front elevation with inviting covered front porch. Walk in to Open concept Cherry Slate kitchen cabinets with elegant Iced White Quartz counter tops with an eased edge and and a mesh mount tile kitchen back splash to compliment it all. Luxury Vinyl wood floors throughout the entry, kitchen, dining, utility room and powder room. Stainless steel Whirlpool kitchen appliances including a gas cook-top, built-in microwave, oven and dishwasher. Walk up the stairs to a loft area, perfect for Family gatherings. All 4 bedrooms up with walk-in closets and 2 bathrooms. Home Also has double Low E pane tilt out windows and fixed windows in the family room and dining area bringing in lots of natural light. Ready for move in and to be called Home.' ,`Acres` = '0.126' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSIDE RANCH SEC 12, BLOCK 1, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5490' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Creekside Ranch Sec 12' ,`TaxAmount` = '6148' ,`TaxRate` = '2.5248' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008635' WHERE `Matrix_Unique_ID` = '213743218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:41:28.313' ,`MLSNumber` = '78914387' ,`ListAgentFullName` = 'Patrick Lee' ,`ListOfficeName` = 'Dreams Come True Realty' ,`SellingAgentFullName` = 'Banny Lim' ,`SellingOfficeName` = 'Century 21 Olympian Galleria' ,`Latitude` = '29.603635' ,`Longitude` = '-95.608184' ,`PhotoCount` = '40' ,`PostalCode` = '77478' ,`RoomCount` = '9' ,`ListPrice` = '415000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Creekside' ,`StreetNumber` = '1630' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3155' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custo built Arnold Morgan home with wrought iron and double stained glass front door. Light and bright open floor plan. Living with high ceilings and fireplace. Kitchen w/ stainless steel appliances, built-in desk and plenty of storage. Large primary bedroom w/ dual sinks, separate shower, and jacuzzi tub. Secondary bedrooms and bath are good size. Large backyard with gazebo. Oversized garage with workshop and storage. Nearby restaurants and shopping. Easy access to freeway. Low tax rate.' ,`Acres` = '0.282' ,`Area` = '29' ,`BuilderName` = 'Arnold Morgan' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SUGARWOOD R/P SEC 1, BLOCK 6, LOT 44 (SW 1/2) & LOT 45' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12286' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugarwood R/P Sec 1' ,`TaxAmount` = '7226' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008635' WHERE `Matrix_Unique_ID` = '213793522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:30:30.043' ,`MLSNumber` = '12439343' ,`ListAgentFullName` = 'D\'Ann Fleming' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694552' ,`Longitude` = '-95.117506' ,`PhotoCount` = '27' ,`PostalCode` = '77536' ,`RoomCount` = '8' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'X' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Street' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home Sweet Home! Location, location, location, in the middle of Deer Park. Recent upgrades: granite, backsplash, paint and opening up the kitchen to living room. Double pane windows with plantation shutters and solar screens. French drains and sprinkler system on a separate water line. Outlet for generator as a bonus and ready when needed. Selling AS IS. Furniture could stay. Great backyard with covered patio for all your entertaining. Make your appointment for your showing today.' ,`Acres` = '0.2314' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 334 DEER PARK GARDENS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEER PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Park Gardens Sec 05' ,`TaxAmount` = '5750' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008635' WHERE `Matrix_Unique_ID` = '213993870' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:35:19.120' ,`MLSNumber` = '73631413' ,`ListAgentFullName` = 'Chris Thompson' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Linda Graham' ,`SellingOfficeName` = 'Arrowstar Realty' ,`Latitude` = '29.922757' ,`Longitude` = '-95.091925' ,`PhotoCount` = '16' ,`PostalCode` = '77532' ,`RoomCount` = '4' ,`ListPrice` = '245000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Quadrant' ,`StreetNumber` = '16610' ,`StreetSuffix` = 'Court' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2171' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Charming 4 bedroom, 2 bath, 2 car garage home on cul-de-sac lot located in Newport. Upon entering the home, two bedrooms and the secondary bathroom are on the left while the 4th bedroom, laundry room, and formal dining are to the right. From the entry way you will see the dining room, with the living room straight ahead. Interact with family and friends while cooking in the kitchen which opens up to the living room as well. Your spacious primary bedroom has a primary bathroom with a dual sink vanity, separate tub and shower and walk in closet. Laminate flooring/tile in wet areas with carpet throughout living areas and bedrooms. Community offers bike/hiking trails, community pools, park and Stonebridge (Newport Golf Course).' ,`Acres` = '0.202' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 14 NEWPORT SEC 4' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'CROSBY ELEMENTARY SCHOOL (CROSBY)' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 04' ,`TaxAmount` = '6455' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008635' WHERE `Matrix_Unique_ID` = '214000901' --> 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','214090585','1668008635','214090585','2022-11-09T06:46:35.170','91168530','Patrick King','Realty Kings Properties','','','29.745592','-95.357896','28','77003','7','419900.00','Active','Leeland','2228','Street','Houston','2','1','2','2090','Single-Family','Experience the heart of the city right at your doorstep with this beautiful modern designed home with high ceilings, open floor plan and beautiful finishes. The 1st floor offers a welcoming entry, storage area and a spacious bedroom with a full bath; perfect for guests. The open concept 2nd floor features chef-inspired kitchen with S-S appliances, granite countertops, center island and is open to the living/dining area and cozy balcony. Upstairs on the 3rd floor you’ll find a flex area than can be used as an office or sitting area, you will also find the primary suite featuring high ceilings, large walk-in closet and spa inspired bath with double sinks, soaking tub, and stand-up shower. The gorgeous terrace is on the 4th level and offers a private retreat for breathing fresh air, dining, and cozy gatherings. This home offers the best in urban living just steps away from Downtown Houston, sports stadiums, restaurants, parks, and easy access to major freeways. Make this home a MUST SEE!','0.0344','4','','','','','Sellers Disclosure','1','','','East End Revitalized','Central Electric','1','LT 4 BLK 1 JOSEPH MAJUMDER II','Other','1500','Appraisal District','','125','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','27 - Houston','LANTRIP ELEMENTARY SCHOOL','WHEATLEY HIGH SCHOOL','NAVARRO MIDDLE SCHOOL (HOUSTON)','Appointment Required,Controlled Access,Supra Keybox,Temporarily No Showings','Seller','4','Contemporary/Modern','Joseph -Majumder 02','8364','2.4557','Public Sewer,Public Water','2008','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','214123676','1668008635','214123676','2022-11-09T05:46:42.330','68286855','Tammy Rea','CB&A, Realtors','','','29.811306','-95.538926','40','77080','10','449000.00','Active','Rosefield','2203','Drive','Houston','2','0','4','2067','Single-Family','Welcome home to this meticulously maintained one story home in Spring Shadows. Inviting entry with views of the back yard pool through the bay windows. Concrete stamped patio to enjoy while lounging by the pool. New 40 year Elk high definition roof. Remodeled bathrooms, hardwood laminate flooring, replastered pool, fence, Rheem 40 gal water heater, new windows, plus fresh paint in three bedrooms. Den with and brick corner gas fireplace, hardwood laminate flooring. Primary bedroom has wonderful view of the backyard and pool. Easy access to downtown, City Centre and Beltway 8. Per the seller\'s, home has never flooded.','0.202','24','','','Gas Dryer Connections','','Sellers Disclosure','1','Freestanding,Gaslog Fireplace','1','Spring Branch','Central Gas','1','LT 11 BLK 11A SPRING SHADOWS SEC 7','Subdivision Lot','8800','Appraisal District','','336','0','','2','Double Oven','1','Gunite','','Electric Range','','Composition','49 - Spring Branch','PINE SHADOWS ELEMENTARY SCHOOL','SPRING WOODS HIGH SCHOOL','SPRING WOODS MIDDLE SCHOOL','Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Spring Shadows Sec 07','7257','2.4415','Public Sewer,Public Water','1968','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:09:52.827' ,`MLSNumber` = '45593584' ,`ListAgentFullName` = 'Deborah Spangler' ,`ListOfficeName` = 'Spangler Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404891' ,`Longitude` = '-95.675169' ,`PhotoCount` = '24' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Grandview' ,`StreetNumber` = '11705' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3781' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy lake living on this gorgeous new construction Stately Homes build on a canal in the gated Grand Harbor Enclave on Lake Conroe. All bedrooms down with gameroom, half bath and two storage closets up. Cathedral beamed ceiling in family room, GE Cafe series appliances, refrigerator included! So much storage and space in this home. Beautiful mud room with storage closets, laundry off of master closet also has storage closet. See attached floor plan for more information. Enjoy beautiful views off of the covered back porch with extended pergola and privacy wall.. Complete and ready for move in. Ask about builders incentive' ,`Acres` = '1.1406' ,`Area` = '39' ,`BuilderName` = 'Stately Homes LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S538010 - GRAND HARBOR 10, BLOCK 1, LOT 12, ACRES 1.14' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '49684' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Grand Harbor 10' ,`TaxAmount` = '3178' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668008636' WHERE `Matrix_Unique_ID` = '214218320' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:51:09.473' ,`MLSNumber` = '80785795' ,`ListAgentFullName` = 'Constance Willis' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.110757' ,`Longitude` = '-95.358835' ,`PhotoCount` = '39' ,`PostalCode` = '77386' ,`RoomCount` = '5' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Meadow' ,`StreetNumber` = '28216' ,`StreetSuffix` = 'Way' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2789' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful Toll Brothers-built home in the coveted neighborhood of Woodson\'s Reserve! Situated on a corner lot, this home provides considerable curb appeal and continues to impress once inside. Medium-toned wood floors will greet guests in the expansive foyer and will continue to run throughout the main areas. Tall, trey ceilings are accented by beautiful carpentry and neutral tones. Secondary bedrooms are especially large and come with their own private baths. The study features a vaulted ceiling and easy-to-clean glass doors. White cabinetry, quartz countertops and stainless-steel appliances are highlighted by a brick-tile backsplash. The large primary bedroom and contemporary bath are elevated once you step into the primary closet, with enough space for even the most discerning \"clothes collector!\"' ,`Acres` = '0.1861' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S973708 - WOODSON\'S RESERVE 08, BLOCK 1, LOT 39' ,`LotDesciption` = 'Corner' ,`LotSize` = '8106' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodsons Reserve 08' ,`TaxAmount` = '12953' ,`TaxRate` = '3.0987' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008636' WHERE `Matrix_Unique_ID` = '214238804' --> 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','214251574','1668008636','214251574','2022-11-09T06:51:54.963','18799444','Christine Hale','RE/MAX The Woodlands & Spring','','','30.615375','-95.567087','50','77340','9','899000.00','Active','Branding Iron','186','Road','Huntsville','4','1','4','3521','Single-Family','Beautiful Like-New Custom Home on 2.2 Acres in Sought-After Community of Texas Grand Ranch. This Lovely 1-Story Home Offers the Ideal Floor Plan with a Spacious Open-Concept Floor Plan w/Spacious Living Room w/German Schmear Brick Fireplace, Extensive Wood-Look Tile, Cathedral Ceiling w/Exposed Beams Open to Kitchen w/Eat-at-Island, Gas Cooktop, Private Study w/French Doors, Split Floor Plan w/4 En-Suite Bedrooms. Upstairs Features a Game Room & Half-Bath. Exceptional Primary Bedroom and Luxurious Bath w/Walk-In Shower, Double Sinks, Freestanding Soaking Tub & 2-Separate Walk-In Closets. Utility Room w/Sink, Counter Space & Room for Refrigerator. Whole-House Generator & Oversized 3-Car Garage w/Epoxy Floor. Sparkling Pool & Spa, Huge Covered Patio Area w/Summer Kitchen for Entertaining & a Fenced Backyard. *The Lot Extends Well Past the Back Fence as Can be Seen on the Survey.','2.263','43','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Huntsville Area','Central Gas,Zoned','1','TEXAS GRAND RANCH PHASE 4A, BLOCK 16, LOT 26, ACRES 2.263','Wooded','98576','Appraisal District','','400','0','','3','Double Oven','1','Heated,In Ground','','Gas Cooktop','','Composition','64 - Huntsville','ESTELLA STEWART ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Appointment Required,Leave Business Card','Appraisal District','1','Traditional','Texas Grand Ranch','6936','1.6942','Aerobic','2022','Seller'); --> 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','214280742','1668008636','214280742','2022-11-09T06:26:35.817','64749827','Kendra Alexis','Collective Realty Co.','','','30.084763','-95.525375','30','77379','10','319999.00','Active','Cascade Hollow','21918','Lane','Spring','2','1','3','2136','Single-Family','Wonderfully Captivating and Spacious Home with Oversized Primary Suite! Centrally located in a highly desirable area only minutes from major conveniences, this residence exudes sheer elegance with a gorgeous exterior brick facade and a stunning covered entryway. Brilliantly sundrenched, the luminous interior features an entertainment-ready floorplan, arched doorways, and an open concept kitchen with stainless-steel appliances, granite countertops, and richly toned cabinetry. Discover blissful rest in the primary bedroom, which has a deep closet and an attached en suite. Two additional generously-sized bedrooms are perfect for guests or lifestyle-specific flex spaces, while the separate office may be utilized for at-home businesses or entrepreneurial pursuits. Call now to schedule your exclusive showing!','0.132','14','','','Electric Dryer Connections,Gas Dryer Connections','','Estate,Sellers Disclosure','1','','0','Spring/Klein/Tomball','Central Gas','1','LT 12 BLK 1 SPRING TERRACE SEC 6','Subdivision Lot','5750','Appraisal District','','480','0','','2','Gas Oven','0','','','Gas Range','','Composition','32 - Klein','MUELLER ELEMENTARY SCHOOL','KLEIN OAK HIGH SCHOOL','KRIMMEL INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Spring Terrace Sec 06','5880','2.59','Water District','2014','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:45:39.887' ,`MLSNumber` = '56284661' ,`ListAgentFullName` = 'Kaylon McNeal' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659669' ,`Longitude` = '-95.313613' ,`PhotoCount` = '19' ,`PostalCode` = '77087' ,`RoomCount` = '3' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Reed' ,`StreetNumber` = '6310' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This updated 3-bedroom home is close to both the airport & the loop. Check out the curb appeal: a newer roof+an oversized driveway+landscaped planting beds+a lush lawn. Inside, you’ll find refinished hardwood floors+new ceiling fans+lots of natural light. The renovated kitchen features NEW Shaker cabinets+fixtures+appliances+backsplash+granite countertops. Just steps away, the backyard boasts 2 patios+a fenced-in lawn+a BBQ pit area+a convenient outdoor powder room. Back inside, the primary bedroom includes a walk-in closet & an ensuite with a soaking tub+lots of storage. The other guest rooms (1 with a built-in desk) share the all-marble hallway bathroom. Don’t forget about the storage in the 2-car garage & the solar screens on the windows. This MOVE-IN-READY home is up the street from F.M. Law Park (trails+playground+golf course). You’ll be 10 min from the airport, with shopping & dining options in every direction. Jump on I-45 & 610 in no time & downtown Houston is just 20 min away.' ,`Acres` = '0.1636' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 16 OVERBROOK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7128' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN VILLAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Overbrook Sec 05' ,`TaxAmount` = '1875' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008636' WHERE `Matrix_Unique_ID` = '214287712' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:52:01.217' ,`MLSNumber` = '78802976' ,`ListAgentFullName` = 'Kathleen Graf' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.698266' ,`Longitude` = '-95.472402' ,`PhotoCount` = '29' ,`PostalCode` = '77401' ,`RoomCount` = '9' ,`ListPrice` = '925000.00' ,`Status` = 'Active' ,`StreetName` = 'Evergreen' ,`StreetNumber` = '5315' ,`StreetSuffix` = 'Street' ,`City` = 'Bellaire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3387' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Live in the heart of Bellaire! Just half a mile from the Bellaire Family Aquatic Center & zoned to Condit Elementary School as well as Pershing & Bellaire High School(buyer to verify & confirm eligibility & enrollment). Although close to all Bellaire has to offer, this home features its own glistening pool w/reverse swim feature. With a flowing floor plan, high ceilings, tasteful moldings, & gleaming hardwood floors, this home is inviting from the moment you walk through the door. The kitchen opens to the breakfast & family rooms w/a gorgeous view of the pool & backyard. Upstairs, a second living area can serve as a TV room, game room or separate living area. The large primary bedroom has two walk-in closets & the primary bath w/travertine tile has a jetted tub w/separate frameless shower. AC system for 2nd & 3rd floor replaced in June of 2022, included both the coil and condensing unit. All info per seller' ,`Acres` = '0.1405' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 10 PEACEFUL VALLEY SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Peaceful Valley' ,`TaxAmount` = '18413' ,`TaxRate` = '2.2271' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008636' WHERE `Matrix_Unique_ID` = '214368666' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T05:49:47.780' ,`MLSNumber` = '60330538' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014765' ,`Longitude` = '-95.536090' ,`PhotoCount` = '40' ,`PostalCode` = '77379' ,`RoomCount` = '14' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Oak' ,`StreetNumber` = '8107' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Updated Home Nestled in the beautiful Memorial Northwest for today lifestyle! Huge Lot! 2 1/2 Detached Garage! Energy Saving Home w/ Updated Roof, Radiant Attic Barrier, High-Efficiency HVAC, Insulated Doors, Insulated/Low-E Windows, Energy Saving H2O Heater & More! Owner\'s Suite & Guest Bedroom Down! Elegant Formal Living & Dining! Dramatic Family Area W/High Ceilings, Amazing Wall of Windows, Stunning Corner Fireplace, Wood Like Tile Floors lead into the Magnificent Gourmet Kitchen W/Tall White Shaker Cabinets, Soft Close Drawers & Cabinets, Gorgeous Quartz Counters, Subway Glass Backsplash, Deep Farmer Sink, 5 Burner, Double Oven Range, Huge Wrap Around Breakfast Bar & More! Owner\'s Suite W/Luxurious Spa Bathroom W/Massive Body Shower, Free Standing Soaking Tub, His & Her Private Undermount Sinks, Quartz Counters, Make Up Area & More! Upstairs Huge Game Rm, 3 Large Bedrooms, & Hollywood Bathroom W/Shaker Cabinets & Quartz Counters! No Flooding! Outstanding Amenities!' ,`Acres` = '0.2686' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 6 017*M1876900-002-006-035 MEMORIAL NORTHWEST SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Memorial Northwest' ,`TaxAmount` = '5281' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008636' WHERE `Matrix_Unique_ID` = '214372890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-09T06:30:53.833' ,`MLSNumber` = '52003796' ,`ListAgentFullName` = 'Tenzesta Smith' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.950255' ,`Longitude` = '-95.204018' ,`PhotoCount` = '43' ,`PostalCode` = '77346' ,`RoomCount` = '5' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Clunie Pass' ,`StreetNumber` = '12343' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in ready! 4-Bed or 3-Bed w/ private office Exquisitely maintained 2,540 sf Highland Home - Beautiful brick & stone exterior with contemporary elevation. An amazing backyard - 54ft from the back of the house to the rear brick fence / NO REAR NEIGHBORS. The large primary bedroom and Office are conveniently located on the first floor. This home features an open and airy layout with classic clean lines and tons of natural light. A sleek and stylish gourmet kitchen with an over-sized island, granite countertops, designer backsplash & stainless appliances. Custom blinds throughout. Spacious floor plan features hard-surface flooring throughout main areas on the lower level. Wrought iron spindles wind up the stairs and open into a bright loft game room offering a delightful space for fun and entertainment. Extended covered patio - close to lagoon. Gated section! Convenient nearby shopping & entertainment. Enjoy the resort style amenities at Balmoral. 12343 Clunie Pass Drive has it all.' ,`Acres` = '0.1285' ,`Area` = '1' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 1 BALMORAL SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5597' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1730' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Balmoral Sec 5' ,`TaxAmount` = '10864' ,`TaxRate` = '3.5573' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668008637' WHERE `Matrix_Unique_ID` = '214400288' --> 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','214436440','1668008637','214436440','2022-11-09T05:30:46.390','98668421','Erica Vasquez','CB&A, Realtors','','','29.891509','-95.409167','24','77037','8','272999.00','Active','Saddle Rock','607','Drive','Houston','2','0','3','1721','Single-Family','Beautifully maintained home with 3 bedrooms, 2 full baths, formal living room, family room sharing space with the breakfast/dining area, breakfast bar overlooking the kitchen. Kitchen has granite counters, plenty of cabinets and updated appliances. This home as a possible 4th bedroom that is currently being used as an office/study, off the formal living room. Out the back door is a covered patio that spans the whole length of the house. Past the covered patio, the outdoor living space continues with pavers providing a great hard surface for guests to walk and gather around the firepit and additional seating. Beyond this this space there is a storage shed and a workshop just ready for your next project at home! All room dimensions are approximate and should be verified by the buyer. This is must see property with tons of possibilities. Never Flooded per seller.','0.1722','34','','','Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure,Tenant Occupied','1','','','Aldine Area','Central Gas','0','LT 18 BLK 2 NORTHLINE TERRACE SEC 1','Subdivision Lot','7500','Appraisal District','','','0','','1','Electric Oven','0','','','Gas Cooktop','','Composition','1 - Aldine','GOODMAN ELEMENTARY SCHOOL (ALDINE)','ALDINE HIGH SCHOOL','STOVALL MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Seller','1','Traditional','Northline Terrace','3039','2.5119','Public Sewer,Public Water','1968','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','214499457','1668008637','214499457','2022-11-09T05:52:04.680','92616539','Ashley Uballe','Keller Williams Professionals','','','30.011759','-95.545435','40','77379','9','330000.00','Active','Canyon Ridge','16910','Court','Spring','2','1','3','2186','Single-Family','Beautiful home in a great location! Close to the Vintage Park with a short commute to major freeways! Your future home will be great for a family that loves to entertain with friends and loved ones. Large game room on 2nd level leading to three bedrooms with amazing sized closets and both baths featuring double sinks. Primary bath is not to be confused for another room with its incredible size!! Worried about a repeated winter freeze? No worries when your own home has a traditional wood burning fireplace for cozy conversations during the holidays. Home also has a 2 car garage. Microwave, dishwasher, and stove all included! As if it doesn\'t get any better, brand new backyard fence was just installed! Meticulously maintained home with lots of updates with an amazing neighborhood. What\'s not to love is the question!! Don\'t miss out and make this your home now! Oh, did I mention you are also in a cul-de-sac!? Run don\'t walk!','0.1452','13','','','','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Champions Area','Central Gas','1','LT 25 BLK 2 CHAMPION SPRINGS SEC 1 AMEND','Cul-De-Sac','6325','Appraisal District','','680','0','','2','Gas Oven','0','','','','','Composition','32 - Klein','KRAHN ELEMENTARY SCHOOL','KLEIN CAIN HIGH SCHOOL','KLEB INTERMEDIATE SCHOOL','Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Champion Spgs Sec 01 Amd','4761','2.3266','Water District','1995','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','214516324','1668008637','214516324','2022-11-09T06:14:56.037','86552065','Jana Koshnick','Keller Williams RealtyNortheast','','','29.973546','-95.117873','42','77532','9','465000.00','Active','Running Bear','1915','Trail','Crosby','2','1','4','2980','Single-Family','WELCOME to this beautiful 4 bedroom home on a large corner lot in convenient Indian Shores subdivision. With lake access and a golf course, this is a great community with country living that has easy access to shopping, Houston and the international airport. This home offers all bedrooms on first floor with a large game room upstairs. The home has been very well maintained with a new roof added in 2021. Sprinkler system with 18 zones. In addition to a 2 car garage it has a 24\' x 20\' workshop with a 24\' x 10\' covered carport and separate driveway. It also has an RV carport. The spacious covered patio is great for those family and friends gatherings that you will be sure to have in this beautiful setting just waiting to become your new home. NEVER FLOODED. During Hurricane Harvey the ditch in the front yard never reached capacity. Great location in neighborhood.','0.3684','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Crosby Area','Central Gas','1','LT 4 BLK 11 INDIAN SHORES SEC 2','Corner,In Golf Course Community,Subdivision Lot','16049','Appraisal District','','500','0','','2','','0','','','Electric Range','','Composition','12 - Crosby','NEWPORT ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Seller','1.5','Traditional','Indian Shores','6817','2.6733','Public Sewer,Public Water','2004','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','214549052','1668008637','214549052','2022-11-09T06:07:28.033','36509172','Rachel Lambright','CB&A, Realtors','','','30.101170','-95.395970','0','77386','7','320000.00','Active','Ryansbrook','1943','Lane','Spring','2','0','3','2016','Single-Family','Like new, Charming home in the popular neighborhood of Spring Trails. New Roof, new interior paint, new interior lighting, water heater replaced less than a year ago, recent flooring. You will love this split floor plan w/ two secondary bedrooms at the front of the home & the primary at the back. As you enter, notice the high ceilings, farmhouse lighting, neutral paint colors. Formal dining could be used as an office/playroom or close it off for a 4th bedroom. Kitchen features solid surface countertops, an abundance of cabinets w/ separate butler\'s pantry perfect for coffee/wine bar. Primary bathroom has a large counter space w/ dual sinks, soaker tub, separate shower, & huge walk in closet. 3 Car Detached Garage! Large concrete patio area, good sized private backyard with no rear neighbors. Easy access to 99, Hardy, and 45. Walkable to Broadway Elementary, Olympic size pool, several parks , basketball/pickleball/tennis/volleyball courts, & easy access to Spring Creek Nature Preserve','0.2064','40','Perry','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Spring Northeast','Central Gas','1','SPRING TRAILS 05, BLOCK 2, LOT 8','Corner,Greenbelt,Subdivision Lot','8991','Appraisal District','','720','0','','3','Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','BROADWAY ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Spring Trails 05','6431','2.6137','Public Water,Water District','2005','Appraisal District'); --> New record created successfully