Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T21:06:45.720' ,`MLSNumber` = '95485024' ,`ListAgentFullName` = 'Linda Barnhill' ,`ListOfficeName` = 'FYI Realty-Katy' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707297' ,`Longitude` = '-95.777678' ,`PhotoCount` = '17' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '370000.00' ,`Status` = 'Active' ,`StreetName` = 'Stratsborough' ,`StreetNumber` = '23410' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2286' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMPROVED PRICE for quick sale! Seller is motivated! Custom glass and wrought iron front door welcomes you into this recently remodeled home. Italian tile throughout the home, custom fireplace, completely remodeled kitchen with granite countertops, and new appliances. The primary bath and closet have custom cabinets and a double shower. The secondary bath has custom cabinetry and glass enclosed shower. New flooring in bedrooms and closets. The OVERSIZED yard features a 16 X 50 covered patio, paved walkways, a fire pit, and a 16 X 13 X 8 building. The large garage has epoxy flooring. This home is conveniently located near highways, shopping, and zoned to excellent schools. Schedule your showing today! This stunning home will not last long!' ,`Acres` = '0.2456' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HICKORY CREEK SEC 1, BLOCK 12, LOT 3, 2ND R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HOLLAND ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Hickory Creek Sec 1' ,`TaxAmount` = '6582' ,`TaxRate` = '2.5145' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216361' WHERE `Matrix_Unique_ID` = '212447482' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T21:06:01.057' ,`MLSNumber` = '32036094' ,`ListAgentFullName` = 'Amy Yoder' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932724' ,`Longitude` = '-95.615695' ,`PhotoCount` = '35' ,`PostalCode` = '77065' ,`RoomCount` = '10' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood Blossom' ,`StreetNumber` = '13023' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3397' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Wortham Estates two story brick home. This Home features grand two story entry, formal living, dining, light filled family room with gas fireplace, open concept to kitchen and breakfast area. 1st floor Primary bedroom has high ceilings, crown molding and large windows. Upstairs are 3 additional bedrooms, 2 bathrooms, large game room and office with built in cabinetry.' ,`Acres` = '0.1848' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 4 WORTHAM ESTATES SEC 2 2ND AMND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ADAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wortham Estates' ,`TaxAmount` = '7259' ,`TaxRate` = '2.341' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216361' WHERE `Matrix_Unique_ID` = '213918586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T21:51:21.213' ,`MLSNumber` = '71473815' ,`ListAgentFullName` = 'Arlene Hinsley' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.614909' ,`Longitude` = '-95.794058' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '12' ,`ListPrice` = '1475900.00' ,`Status` = 'Active' ,`StreetName` = 'River Forest' ,`StreetNumber` = '3606' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '6014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Relisting with updates to kitchen, baths and more. A PRIVATE gated, LAKEFRONT estate, this 2.57 acre wooded lot in popular River Forest offers a one of a kind residence. Exterior boasts a brick/masonry/stucco elevation, whole-home generator, driveway gate, porte-cochere, 3.5 car garage, gardens, & expansive patios. Interior features truss & beam or coffered ceilings, crown moldings, built-ins, hardwood floors, formal dining & living room, butler’s pantry w/ a catering/spice kitchen, elevator capable, all 4 bedrooms w/ en-suite baths, a private balcony off the Primary bedroom, upstairs office area w/ adjoining den, generous gameroom/media room ready to entertain. Kitchen features new counters, Sub-Zero refrigerator/freezer, separate Ice Maker, 36’ Wolf Gas range, hammered copper hood, newly expanded & painted cabinets open to the breakfast & keeping room. Never flooded. A spacious home yet attention to details.' ,`Acres` = '2.572' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'RIVER FOREST SEC 2, BLOCK 1, LOT 4, ACRES 2.572' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '112036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '659' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Left Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English,French,Traditional' ,`Subdivision` = 'River Forest Sec 2' ,`TaxAmount` = '18661' ,`TaxRate` = '1.6948' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216361' WHERE `Matrix_Unique_ID` = '214562350' --> 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','214993144','1675216361','214993144','2023-01-19T21:00:11.580','43219729','Steve Anton','Hallmark Properties, Inc.','','','29.695110','-95.444724','24','77025','12','1825000.00','Active','Grennoch','4115','Lane','Houston','4','1','4','5019','Single-Family','Unrivaled new home, thoughtfully designed & carefully built by acclaimed Laird Custom Homes on a large, quiet lot. Zoned to Mark Twain Elem & Bellaire High. Long sightlines throughout an ideal floorplan for entertaining or busy family. Great front veranda w/double doors to a soaring formal entry w/graceful, curving stairway. Spacious family room w/20’ ceiling, clerestory windows, custom wet bar, built-ins & a wall of windows to the covered patio w/fireplace and fun backyard. Spacious kitchen featuring Miele appliances, gas range, huge island, fully shelved pantry, pot filler & custom cabinetry. Elegant formal dining w/beamed ceiling & butlers pantry. Ideal home office w/high ceiling & desirable front-yard view. A wide, gallery-style hallway leads to enormous and very private master down w/step vaulted ceiling, giant closet, oversized shower. separate tub & its own washer/dryer. Gameroom up plus 3 addl bedrooms w/ensuite baths. Mudroom to attached garage w/elec vehicle charging outlet.','0.2231','17','Laird Custom Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections','1','Braeswood Place','Central Gas,Zoned','0','LT 4 BLK 21 AYRSHIRE SEC 9','Subdivision Lot','9720','Appraisal District','','','1','To Be Built/Under Construction','2','Single Oven','0','','','Gas Range,Grill','','Composition','27 - Houston','TWAIN ELEMENTARY SCHOOL','BELLAIRE HIGH SCHOOL','PERSHING MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Ayrshire','10944','2.3307','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215160403','1675216361','215160403','2023-01-19T21:26:07.200','65459358','Collette King','RE/MAX Universal','','','30.009703','-95.615661','50','77377','10','449000.00','Active','Cranes Park','12518','Street','Tomball','3','1','4','3182','Single-Family','Beautiful pool home in the highly sought after Lakewood Forest subdivision. You won’t be disappointed as you step into this executive retreat. Spacious study & formal dining room are adorn w/ lovely wood flooring. Oversized family room is complete w/ a gorgeous red brick, gas-log fireplace. A wall of windows overlook the resort-style backyard complete w/ plenty of yard left over. Island kitchen w/ double ovens, gas cooking & ample countertop space make cooking a dream! Wait until you see this huge walk-in pantry. Large laundry room (w/d stay). Downstairs master retreat opens to the office providing a great nursery or work space. Master bath w/ separate tub & shower. Upstairs find an oversized game room, & three large secondary bedrooms. One bedroom w/ en-suite bath & a hall bath for the two separate bedrooms. Walk in closets throughout! Three-car detached garage. Recent roof. Freshly painted from top to bottom. New floors too! Tomball schools! HUGE diving pool & Sprinkler system.','0.2814','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','Tomball South/Lakewood','Central Gas','1','LT 43 BLK 3 LAKEWOOD FOREST SEC 15','Subdivision Lot','12256','Appraisal District','','655','0','','3','Double Oven,Electric Oven','1','In Ground','','Gas Cooktop','','Composition','53 - Tomball','LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)','TOMBALL MEMORIAL H S','WILLOW WOOD JUNIOR HIGH SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Lakewood Forest','8487','2.4325','Water District','1991','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','215782662','1675216361','215782662','2023-01-19T22:08:02.330','21315090','Gay Milliorn','RE/MAX Eastside','','','29.969406','-94.899678','8','77535','7','344990.00','Active','San Marcos','512','Trail','Dayton','2','1','4','2563','Single-Family','Welcome to River Ranch, a brand new community with easy access to Hwy 146 and the Grand Parkway! This 4 bedroom home offers a great office and game room, with amazing natural light. The open kitchen features maple shaker-style cabinets, quartz countertops, and stainless steel appliances. The spacious Primary Suite is tucked away for your own private retreat with separate shower, garden tub, and two closets! This smart home has front and back sprinklers. You will appreciate the great storage and energy efficient features throughout. Estimated completion for this home is April 2023!','0.1653','52','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud,No Disclosures','1','','','Dayton','Central Gas','1','River Ranch Meadows, Sec 1, Lot 3, Block 4 Acres 0.1653','Subdivision Lot','7200','Survey','','800','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Range','','Composition','74 - Dayton','KIMMIE M. BROWN ELEMENTARY SCHOOL','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','River Ranch Meadows','','3.223','Public Sewer,Public Water,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215829461','1675216362','215829461','2023-01-19T21:05:02.840','34781419','Caroline Spagnola','Douglas Elliman Real Estate','','','29.204457','-94.936695','29','77554','13','825000.00','Active','Pirates','4119','Alley','Galveston','2','1','5','2348','Single-Family','Welcome to 4119 Pirates Alley!! This 5 bedroom well maintained home is just one block away from the Gulf of Mexico in the heart of highly sought after Pirates Beach! Enjoy sunrises with partial gulf views on the first and second wrap around deck! As you walk in you are greeted by an open concept living room, dining area, and updated kitchen ideal for entertaining featuring granite countertops and stainless steel appliances. There is two well proportioned bedrooms downstairs as well as two upstairs. Bonus bedroom is located on ground level complete with queen/twin bunk beds as well as a full bathroom; which is not included in square footage. Ground level features an outdoor shower after a day at the beach and an ample amount of space for grilling and lounging. Whether you\'re searching for a new investment property to add to your portfolio or a beach house for personal leisure; this home checks off all of the boxes! Conveys fully furnished and turn key ready!-','0.1377','33','','','','','Sellers Disclosure','1','','','West End','Central Electric','0','ABST 121 HALL & JONES SUR LOT 48 BLK 11 PIRATES BEACH SEC 2','Water View','6000','Appraisal District','','340','0','','0','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required','Appraisal District','2','Other Style','Pirates Beach 2','17612','1.9875','Public Sewer,Public Water','1972','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','216205704','1675216362','216205704','2023-01-19T21:51:21.120','85217671','Jo Krejci','Champion Real Estate ','Toan Vu','Greatland Living','29.789357','-95.737446','24','77449','3','265000.00','Pending Continue to Show','Windys','1507','Way','Katy','2','1','3','1978','Single-Family','ADDITIONAL PHOTOS ON THE WAY - Just installed Sparkling Quartz Counter Tops, double sink, disposal and faucet in kitchen. New tile and carpet throughout, new ceiling fans and light kits in all bedrooms and den, refurbished bathroom countertops, new tub in guest bath, refurbished shower surround in primary bath, new interior paint throughout, new exterior paint, replaced door hardware, new electrical outlets and switches, new electric panel, new privacy fence on two sides, new garage door opener. Huge back yard, .26 acres with extra area for storing a boat or trailer inside privacy fenced back yard. Security cameras, staged furniture, washer, dryer, frig are reserved, not included in sale. Possession will be within 24 business hours after closing and funding.','0.2667','25','','','','','Sellers Disclosure','1','Wood Burning Fireplace','1','Katy - North','Central Gas','1','LT 31 BLK 4 PARKWAY WEST SEC 1','Subdivision Lot','11616','Appraisal District','','392','0','','2','','0','','','','','Composition','30 - Katy','FRANZ ELEMENTARY SCHOOL','MORTON RANCH HIGH SCHOOL','MORTON RANCH JUNIOR HIGH SCHOOL','Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal','2','Traditional','Parkway West Sec 01','6232','2.502','Public Sewer,Public Water','1983','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','216278325','1675216362','216278325','2023-01-19T22:42:10.740','14106337','Justin Dickey','Keller Williams Professionals','','','29.427405','-95.454044','29','77583','8','425990.00','Active','Sequoia Run','2410','Drive','Rosharon','2','1','4','2377','Single-Family','This gorgeous Colina Home has it all! Offering 4bedrooms, 2.5bathrooms, 3 car garage, Study and Huge Game Room. Spacious Living/Dining area with tall ceilings. The kitchen features breakfast bar for those quick meals in the morning, 42\" cabinetry,& spacious walk in pantry. This home sits on a HUGE Cul-De-Sac lot and the covered back patio is great for grilling and family fun. Rosharon\'s best communities offering everything a family friendly community would want + amenities located in Sterling Lakes, with a spashpad, fitness center,Basketball Court, Lakes & Parks. Crystal Lagoon coming soon in Sierra Vista, Close to Pearland, Alvin,Manvel, Lake Jackson,30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND COME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA! Photos are representative ONLY.','','5','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 2 Blk 1 Sec 6','Subdivision Lot','7915','Survey','','1100','1','To Be Built/Under Construction','3','Freestanding Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany','Builder','2','Traditional','Sierra Vista','','3.6','Public Sewer,Public Water,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216278575','1675216362','216278575','2023-01-19T22:47:35.477','23677292','Justin Dickey','Keller Williams Professionals','','','29.427469','-95.454204','40','77583','8','414990.00','Active','Sequoia Grove','2421','Drive','Rosharon','2','0','4','2349','Single-Family','Beautiful one story with four bedrooms, three full baths plus study/dining room, 2 sinks in primary bath with garden Tub and large standalone shower. utility room connect to spaces primary closet. Additional closet in primary off primary bath. High ceiling granite kitchen with deep vinderman sink 42 inch cabinets. Stainless steel five burner gas range and With microwave and dishwasher 2\" blinds along with windstorm panels. Est completion: February 2023','','5','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 8 BLK 1 Sec 6','Subdivision Lot','7197','Survey','','950','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','1','Traditional','Sierra Vista West','','3.606','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216278634','1675216362','216278634','2023-01-19T22:48:54.097','26427957','Justin Dickey','Keller Williams Professionals','','','29.427395','-95.453252','33','77583','8','417990.00','Active','Sequoia Run','2405','Drive','Rosharon','3','0','4','2543','Single-Family','Beautiful one story with 4 bedrooms, 3 full baths plus study/dining room. Two sinks in primary bath with garden tub and stand-alone shower with seat, XLarge primary closet. High ceilings throughout the home with vestibule in the entry. Granite Kitchen with deep under-mount sink. 42” cabinets, Stainless Steel 5 burner gas range, microwave and dishwasher 2” blinds standard along with windstorm panels, large covered patio. EST Completion 2/28/23. PICTURES ARE REPRESENTATIVE- Not the actual home.','','5','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Alvin North','Central Gas','1','Lot 4 BLK 1 Sec 6','Subdivision Lot','9540','Appraisal District','','900','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Cooktop','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany,Leave Business Card','Builder','1','Contemporary/Modern','Sierra Vista West','','3.6','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216278679','1675216362','216278679','2023-01-19T22:50:35.697','73939869','Justin Dickey','Keller Williams Professionals','','','29.427362','-95.453243','30','77583','10','359990.00','Active','Sequoia Grove','2409','Drive','Rosharon','3','0','4','2050','Single-Family','Colina Homes- Single Story: Elegant entry with coffered tall ceilings, 4 bedrooms, 3 baths location in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub\r\nand shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite\r\nand tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s.\r\nYou\'re going to Love it! Situated in one of Rosharon\'s best communities. and offers everything your\r\nare looking in a family friendly community- amenities located in Sterling Lakes - the spashpad, fitness\r\ncenter, Basketball Court, Lakes & Parks. Crystal Lagoon coming soon! Close to Pearland, Alvin,\r\nManvel, Lake Jackson, 30 minutes from Downtown Houston. SHOP AND WORK IN THE CITY AND\r\nCOME HOME TO A QUIET PEACEFUL COMMUNITY @ SIERRA VISTA! PHOTOS ARE REPRESENTATIVE.','','5','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Alvin North','Central Gas','1','Lot 5 Block 1 Sec 6','Corner,Subdivision Lot','7156','Survey','','1100','1','To Be Built/Under Construction','3','','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Sierra Vista West','','3.6','Public Sewer,Public Water,Water District','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216278784','1675216362','216278784','2023-01-19T22:52:41.710','41151764','Justin Dickey','Keller Williams Professionals','','','30.151994','-95.615602','18','77354','8','299990.00','Active','Grey Fox','27082','Run','Magnolia','2','1','3','1988','Single-Family','MILL CREEK IS NOW OPEN!! FEBUARY 2023 MOVE-IN! 365 DAY RATE LOCK WITH 1X RATE FLOAT DOWN AVAILABLE. Colina Homes believes in building your dream 2-Story at a price you CAN afford! Come see this open-concept home that lives BIG. 2-Story Ceilings at Entry & Family Room, Spacious Kitchen with 42” Modern Grey Cabinets + Luxury White Granite + 3D Subway Tile Backsplash on Brick Pattern + Stainless \"Farmhouse\" Single-Bowl Sink + Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Extra-Large Master Suite that boasts a BIG Walk-In Closet, 36\" Cabinets w/ Double Sinks, Garden Tub & Separate Shower with Glass Enclosure with Shampoo Ledge! 3-Sides Acme Brick, 2” Faux Wood Blinds, 16 SEER Lennox Air System, In-Wall Pest Defense System & much more! This Energy Efficient home will SAVE you $$$! CALL & MAKE YOUR APPOINTMENT TO VISIT TODAY! Photos Are Representative','','15','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Magnolia/1488 East','Central Gas','1','Lot 16 Block 1 SEC 2','Subdivision Lot','6533','Other','','450','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Accompany','Builder','2','Contemporary/Modern,Traditional','Mill Creek Trails','','','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216278924','1675216362','216278924','2023-01-19T22:56:27.030','8151878','Justin Dickey','Keller Williams Professionals','','','29.405773','-95.059907','50','77568','7','340822.00','Active','VILLA SOLA','13314','Drive','Texas City','3','0','4','2340','Single-Family','BEAUTIFUL BRAND NEW COLINA HOME- 2 STORY WITH 4 BEDROOMS, 3 FULL BATHS , PLUS UPSTAIRS LOFT. DOWNSTAIRS HAS 2 BEDROOMS AND 2 FULL BATHS, UPSTAIRS HAS 2 BEDROOMS AND 1 FULL BATH, HUGE OPEN HOME PLAN WITH SKY LINE WINDOWS, STORMY NIGHT GRANITE KITCHEN COUNTERTOPS, WHITE 42\" KITCHEN CABINETS WITH CROWN MOLDING, 9\" SINGLE BOWL KITCHEN SINK, 6X24 TILE FLOORING EVERYWHERE EXCEPT STAIRS & BEDROOMS AND LOFT, INCLUDES 2\' FAUX WOOD CORDLESS BLINDS, BUILT IN TAEXX PEST CONTROL, RINNAH TANKLESS WATER HEATER, FRONT GUTTERS, BACK COVERED PATIO, COVERED FRONT PORCH, FRIGIDARE STAINLESS STEEL 5 BURNER GAS APPLIANCES, STONE ELEVATION M, FRONT GUTTERS, LENNOX 16 SEER A/C, DOUBLE VANITY IN MASTER BATH, BUILT IN SHOE CASE IN MASTER CLOSET. READY IN FEBUARY!\r\nPHOTOS ARE REPRESENTATIVE!!','','33','Colina Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Texas City','Central Gas','1','Lot 9 Block 1 Sec 3','Corner,Subdivision Lot','5625','Survey','','1330','1','To Be Built/Under Construction','2','Freestanding Oven','0','','','Gas Cooktop','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Accompany','Builder','2','Contemporary/Modern,Traditional','Lago Mar','','3.55','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216293261','1675216362','216293261','2023-01-19T22:40:51.510','91126415','Cameron Namazi','Summit Realty','','','29.773174','-94.984261','40','77521','13','319000.00','Active','Prince','4502','Street','Baytown','2','1','5','3276','Single-Family','Location! Location! Location! This two story Baytown Beauty is located in the highly sought after Country Club Manor! The location cannot be more perfect.This 5 bedroom 2 and half bathroom two-story is a traditional style home. The open concept living room and kitchen area are ready for enjoyable family time. Master bedroom has its own tub and stand up shower. Two additional rooms are great for the kids to have their own private space to play in. here is plenty of space in this immaculate and pristine yard to add a pool if so desired. Storm shutters have been installed on all windows and also has full gutters with leaf guard protection. Perfect neighborhood, perfect location, means this home won\'t last long. This home is luxury at a affordable price all within minutes from major highways like I-10 and 146. Schedule your private tour today!','0.1571','2','','','Gas Dryer Connections','','Sellers Disclosure','1','','0','Baytown/Harris County','Central Gas','1','LT 59 COUNTRY CLUB MANOR SEC 3','Cleared,Subdivision Lot','6844','Appraisal District','','175','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','23 - Goose Creek Consolidated','ALAMO ELEMENTARY SCHOOL (GOOSE CREEK)','GOOSE CREEK MEMORIAL','GENTRY JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Contemporary/Modern,Traditional','Country Club Manor Sec 03','8727','2.97','Public Sewer,Public Water','2006','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','216414693','1675216362','216414693','2023-01-19T22:06:12.837','37055832','Christopher Dahl','DTP Realty','','','29.800193','-95.827241','50','77493','13','2500000.00','Active','Franz','6007','Court','Katy','3','1','6','7581','Single-Family','This one is a must see one of a kind in the Heart of Katy! Completley remodeled this home features 6 bedrooms, 3 living areas, home office/study, formal dining room, breakfast room, stunning kitchen has quartz countertops, shaker cabinets with soft close cabinets & drawers, island with seating, double oven, microwave, refrigerator, butlers pantry with wine & beverage refrigerators and breakfast room, huge laundry/mud room with built in area. Porcelain floors throughout, marble in the primary bathroom, walk in shower, double sinks & quartz counter tops, additional vanity with lighted mirror, carpet upstairs in the bedrooms, wood floor landing outside of upstairs bedrooms. New light light fixtures throughout the home. Outside you will find a screened in heated pool/hot tub, fire pit. Garage/studio apartment has a kitchen with stove & refrigerator and it\'s own private entrance Make an appointment today to see this amazing home! Professional photos will be upload in a couple of days.','1.742','25','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Freestanding','1','Katy - Old Towne','Central Gas','0','TR 7K ABST 1348 H&TCRR CO SEC 44','Cul-De-Sac','75882','Other','','','0','','2','Double Oven,Gas Oven','1','Enclosed,Gunite,Heated,In Ground','','Gas Cooktop','','Other','30 - Katy','KATY ELEMENTARY SCHOOL','KATY HIGH SCHOOL','KATY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal','2','Colonial','H & Tc Railroad Company Surv S','22364','2.3852','Public Sewer,Public Water','1976','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','216557367','1675216362','216557367','2023-01-19T21:09:02.730','26548800','Kay Voigt','Walzel Properties','','','29.416812','-95.261608','7','77511','2','238000.00','Active','Kost','812','Road','Alvin','1','0','2','1284','Single-Family','1.27 acres, with small home, 18x40 barn. Home was built in the 1930s and while it needs a great deal repair, it still has some of its historical architecture. The barn has 3 stalls and chicken coop. Rumor has it, this was the home of Mr Kost (the street name) and was originally a barn converted to a house in the 30s. You will need to check your own historical facts, but this is a great location for a business, build multi unit, rehab the home or build your new home. Nice plot of land near the middle of Alvin. Also due to the freeze several years ago, part of the owner, new pics pipes were installed in the house along with a new wiring.\r\nWill be ready to view starting Sat, Jan. 21.','1.27','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','','Alvin South','No Heating','0','A0422 HOOPER & WADE, TRACT 2A3-2F-2G (STOWE ESTATES LOT 2),','Cleared,Wooded','55321','Appraisal District','','','0','','0','','0','','','','','Composition','3 - Alvin','MELBA PASSMORE ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','FAIRVIEW JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal District','1','Other Style','Hooper & Wade','3908','2.743','Public Sewer,Public Water','1930','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','216562735','1675216362','216562735','2023-01-19T21:45:34.717','81682660','Yigal Kass','Compass RE Texas, LLC','','','29.742463','-95.469813','11','77056','8','2850000.00','Active','Stoney Point','2219','Street','Houston','2','2','2','3098','Single-Family','Pavilion House” by Collaborative Designworks is a unique, timelessly elegant contemporary home inspired by Mies van der Rohe’s masterpiece, Farnsworth Pavilion. This custom home, currently designed as a 3098 sf two bedroom home w/study, can be expanded into a 4 bedroom 4000+ sf home without compromising the exquisite design of the structure. The open floorplan glass walled pavilion features 12’ floor to ceiling sliding doors. Living, dining, kitchen & primary bedroom all on the ground floor, overlook a magnificent 800 sf deck, pool & outdoor kitchen hidden from street by a beautiful masonry wall. A tranquil study opens onto a private courtyard. Spacious 16’ x22’ guest bedroom. The luxurious home is to be built on a prime corner lot just minutes from the Galleria, Tanglewood & Post Oak. Foundation in place, windows and doors on order. This home awaits a buyer who will complete construction with current builder or with a builder of their choosing. Property is also available for the lot.','0.2635','22','Owner\'s Choice','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','Gas Connections','1','Galleria','Central Electric','1','LT 13 & TR 12A BLK 2 DEL MONTE SEC 2','Corner','11480','Appraisal District','','500','1','To Be Built/Under Construction','2','Double Oven,Electric Oven','1','In Ground','','Gas Cooktop','','Other','27 - Houston','BRIARGROVE ELEMENTARY SCHOOL','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Accompany,Appointment Required','Seller','1','Contemporary/Modern','Del Monte Sec 02','','','Public Sewer,Public Water','2023','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','216563817','1675216362','216563817','2023-01-19T22:59:36.160','59703064','Dondra Hamilton','AVOREC','','','31.823656','-99.105996','22','76801','9','425000.00','Active','Ardee','7231','Drive','brownwood','2','0','2','2266','Single-Family','Texas Hill Country Haven--own a slice of paradise on beautiful Lake Brownwood. Custom home situated on a quiet, shallow cove, this 2260 square foot ranch boasts Austin chalk stonework with cedar beams on front and back. Inside, the great room with soaring ceilings offers views straight through to the back. The open concept living room with gas fieplace leads directly to a chef\'s kitchen. There you can enjoy high-end appliances, large island, custom cabinets with soft-close doors and drawers, granite countertops, gas cooktop and double ovens. The primary bedroom has walk-in closet and an en-suite bath with heated tile floors and massive shower. The bonus room is perfect as a game room, office or could be a third bedroom. A sunlit laundry room with extra sink leads to the back porch with vaulted ceilings and tiered deck. Entertaining is a breeze in the outdoor pavilion with fridge and sink. Multiple storage buildings, RV cover, boat carport, chicken coop and more! Owner/Agent','1.1827','83','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','','Central Gas,Propane','0','SHAMROCK SHORES SECTION E, LOT 19-22','Water View','51518','Appraisal District','','','0','','1','Double Oven','0','','','Gas Cooktop','','Other','330 - Bangs','J B STEPHENS ELEMENTARY SCHOOL','BANGS HIGH SCHOOL','BANGS MIDDLE SCHOOL','Appointment Required,Lockbox Back','Appraisal District','1','Ranch','Shamrock Shores Sec E','6446','1.4434','Septic Tank','2018','Appraisal District'); --> New record created successfully