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-28T22:46:57.613' ,`MLSNumber` = '98856116' ,`ListAgentFullName` = 'Penny Clissold' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839831' ,`Longitude` = '-95.436300' ,`PhotoCount` = '34' ,`PostalCode` = '77018' ,`RoomCount` = '7' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Del Norte' ,`StreetNumber` = '1404' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this fabulous updated home in Oak forest/ Heights area. This home sits on a double lot so if you are trying to build you can build 2 homes on this double lot if you remove the current home. Location, location, location. This home has it all. This home has been totally remodeled . You have front door mail service which I have never even heard of. This home was remodeled in the farmhouse look or as some say the Joanna Gaines look. Nice grey paint and pretty new lighting. This home has been reduced by 75K. A great opportunity for investors or smart home buyers.' ,`Acres` = '0.4292' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LTS 135 & 136 BLK F ELLA LEE FOREST' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '18553' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ella Lee Forest' ,`TaxAmount` = '11757' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265648' WHERE `Matrix_Unique_ID` = '202241207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T22:05:07.427' ,`MLSNumber` = '85778137' ,`ListAgentFullName` = 'Vicki Baggs' ,`ListOfficeName` = 'Vista Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.851752' ,`Longitude` = '-96.380476' ,`PhotoCount` = '40' ,`PostalCode` = '75032' ,`RoomCount` = '5' ,`ListPrice` = '674900.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowpark' ,`StreetNumber` = '220' ,`StreetSuffix` = 'Lane' ,`City` = 'McLendon-Chisholm' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3098' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for country living not too far from town? Beautifully updated home in the country on 2.62 acres. In spring, the entire yard is covered in pink & white Primrose. Home includes new flooring, window moldings, kitchen & bathroom remodels. Master bath features large dbl shower, 6’ tub, Kohler ceiling-mount faucet, designer tile walls, & horizontal sliding windows. Ideal for entertaining with a real dbl-sided fireplace (not a metal box) inside a huge open kitchen, breakfast area. Media room could be 5th bedroom or game room. Outdoor entertainment space, large fire pit, relaxing spa that heats & cools, cedar patio, speakers, and TV. 12x24 storage building w new roof & metal roll-up door. Home features antique bricks from the Old Farmer\'s Market in Dallas. Rural setting with large pond, neighbors have cows, dogs, horses, goats and more. Your kids will love growing up here! Restaurants & shopping are less than 10 minutes away. 30 min from Dallas.Rockwall ISD! 2020 new HVACs (x2) No HOA!' ,`Acres` = '2.616' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 15, BLOCK A, MEADOWCREEK 2.616 AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '113953' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '876 - Rockwall' ,`SchoolElementary` = 'OUIDA SPRINGER' ,`SchoolHigh` = 'ROCKWALL-HEATH HIGH SCHOOL' ,`SchoolMiddle` = 'MAURINE CAIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowcreek' ,`TaxAmount` = '7378' ,`TaxRate` = '1.7717' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265649' WHERE `Matrix_Unique_ID` = '209395180' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T21:02:40.120' ,`MLSNumber` = '96439510' ,`ListAgentFullName` = 'Jennifer Robbins' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.424977' ,`Longitude` = '-95.637640' ,`PhotoCount` = '16' ,`PostalCode` = '77356' ,`RoomCount` = '5' ,`ListPrice` = '743900.00' ,`Status` = 'Active' ,`StreetName` = 'Wycliffe' ,`StreetNumber` = '15' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3841' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION, MOVE-IN READY! ELEGEANT AND CASUAL DESCRIBES THIS CUSTOM HOME IN THE HEART OF FAMILY FRIENDLY BENTWATER A GATED COMMUNITY. THE HOME FEATURES 4 BEDROOMS, WITH AN OFFICE, AND PRIMARY BEDROOM DOWNSTAIRS. UPSTAIRS FEATURES 2 SECONDARY BEDROOMS WITH A HOLLYWOOD BATHROOM, PLUS A FLEX ROOM WITH A PRIVATE BATHROOM, PLUS A SMALL EXTRA ROOM FOR A 2ND OFFICE OR PLAYROOM. PRIMARY BEDROOM HAS A LARGE WALK-IN CLOSET WITH CUSTOM BUILT-INS, ALSO FEATURES A LARGE WALK-IN SHOWER WITH SOAKING TUB AND DOUBLE SINKS WITH LOTS OF STORAGE.\r\nTHE KITCHEN FEATURES A LARGE ISLAND WITH SEATING AND OPEN TO THE FAMILY ROOM, CUSTOM KITCHEN CABINETS AND DRAWERS BUILT ON SITE, PLUS A LARGE WALK-IN PANTRY WITH LOTS OF STORAGE. HOME ALSO FEATURES A STONE WALL WITH BUILT-INS AND ELECTRIC FIREPLACE. MOVE-IN READY!' ,`Acres` = '0.2242' ,`Area` = '39' ,`BuilderName` = 'Troy Scott Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BENTWATER 30A, BLOCK 1, LOT 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '9766' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1600' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '516' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265649' WHERE `Matrix_Unique_ID` = '210173792' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T21:40:52.550' ,`MLSNumber` = '35757399' ,`ListAgentFullName` = 'Tammy Downey' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.976091' ,`Longitude` = '-95.583524' ,`PhotoCount` = '49' ,`PostalCode` = '77070' ,`RoomCount` = '11' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypresswood' ,`StreetNumber` = '10819' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2982' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible 2 story home w/ 4 bedrooms & 2 ½ baths nestled on a corner lot w/ a circle drive & 3 car garage. As you enter through the double door entry, you are greeted by the long light filled foyer w/ formal dining & formal living located on each side. The gourmet kitchen is complete w/ breakfast bar, custom cabinetry, granite countertops w/ built-in island & lots of storage & provides access to the enclosed courtyard. The family room is located right off the kitchen & breakfast room featuring tile flooring, gas log stone fireplace & double doors leading to a large flex space w/ endless possibilities. Primary suite is located on 1st floor w/ ensuite bath, 2 closets & private access to backyard. Custom wrought iron staircase leads to the 2nd floor game room w/ wet bar & 3 spacious bedrooms. 2022 updates: roof, flooring, cabinets, countertops, toilets & paint throughout. Take advantage of the community clubhouse, pool, tennis courts, low tax rates & highly acclaimed Cy-Fair ISD.' ,`Acres` = '0.2686' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 17 NORCHESTER SEC 2 R/P' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MATZKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Norchester' ,`TaxAmount` = '5545' ,`TaxRate` = '2.4817' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265649' WHERE `Matrix_Unique_ID` = '210624381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T22:15:59.037' ,`MLSNumber` = '96035448' ,`ListAgentFullName` = 'Veronica Cunningham' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Melissa Harper' ,`SellingOfficeName` = 'RE/MAX Universal' ,`Latitude` = '30.033380' ,`Longitude` = '-95.621412' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '12' ,`ListPrice` = '650000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Northpointe Bend' ,`StreetNumber` = '12422' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4401' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come knock on our door, we\'ve been waiting for you, the first two fell through, this house is for you!\r\nBeen on the market and was returned at no fault of my own, waiting patiently for my forever family! Good with pets, kids and backyard events!\r\n\r\nThis David Weekley Home offers 5 bedrooms, 3 full bathrooms, large game room on the second level, two half bathrooms, study and formal dining. Gorgeous views from the back of home on the lake and your own backyard oasis with custom covered patio completed summer of 2021. Rare find with a THIRD FLOOR BONUS room and half bath. No side neighbors, oversized garage, front patio to sit and watch the kids play. Custom woodwork throughout the first floor, fireplace and mantle refinished 2021, interior paint 2021, brand new AC October 2022.\r\nHighly sought after Villages of Northpointe in award wining Tomball ISD.' ,`Acres` = '0.2728' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 VILLAGES OF NORTHPOINTE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11882' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CANYON POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Northpointe Sec 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265649' WHERE `Matrix_Unique_ID` = '212623722' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T21:48:12.583' ,`MLSNumber` = '16687428' ,`ListAgentFullName` = 'Abbie Walsh' ,`ListOfficeName` = 'Walsh &Mangan Premier RE Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.612126' ,`Longitude` = '-96.401393' ,`PhotoCount` = '50' ,`PostalCode` = '77807' ,`RoomCount` = '14' ,`ListPrice` = '849900.00' ,`Status` = 'Active' ,`StreetName` = 'Boxelder' ,`StreetNumber` = '2964' ,`StreetSuffix` = 'Drive' ,`City` = 'Bryan' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION WITHOUT THE WAIT! This 4 bedroom, 3 bath, 1 1/2 bath home boasts an open floor plan with living, kitchen & dining on the main floor. Accented with white oak engineered wood floors, plantation shutters, brass fixtures and stunning tile kitchen backsplash. The 1st floor primary suite is outfitted with a spacious bathroom, complete with soaking tub, walk-in shower, & an expansive walk-in closet. The kitchen offers quartz countertops, custom cabinetry, brass schoolhouse pendant lighting over the island, wood vent hood over gas cooktop, large island and walk-in pantry. Custom built-ins flank the stone fireplace. Upstairs you\'ll find 3 bedrooms, 2 bathrooms and an extra large bonus room. The spacious covered back patio provides even more space to entertain or just enjoy your morning coffee. The Traditions community is known for its premier golf course and clubhouse and resort-style pool!' ,`Acres` = '0.194' ,`Area` = '61' ,`BuilderName` = 'Easterling Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE TRADITIONS PH 20B, BLOCK 1, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8451' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'MARY BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'The Traditions Ph 20b' ,`TaxAmount` = '1886' ,`TaxRate` = '2.3493' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265650' WHERE `Matrix_Unique_ID` = '212722185' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T22:10:59.510' ,`MLSNumber` = '89661808' ,`ListAgentFullName` = 'Angeline Clark' ,`ListOfficeName` = 'Monarch Real Estate & Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.500270' ,`Longitude` = '-95.395980' ,`PhotoCount` = '18' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '581100.00' ,`Status` = 'Active' ,`StreetName` = 'Palmero' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Way' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3657' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SARATOGA HOMES NEW CONSTRUCTION!! Two story new construction home for sale in Rodeo Palms. Open-concept layout features an elongated foyer entryway with a breathtaking view of the over-sized family room with a full wall of windows. Our gourmet kitchen is a chef\'s dream kitchen with a large granite kitchen island, double ovens, and walk-in pantry. Formal dining room and separate breakfast area. Study on the first level allows you to work from home or for the children to do their online learning. Over-sized family room offers plenty of space for quality family time. Grand primary suite boasts a massive closet with an extra storage nook. Spacious primary bath feature his and hers sinks, sit-in vanity, separate soaking tub, and walk-in shower. Open to below makes it easy to keep an eye on the kids from the first level. 3 spacious secondary bedrooms and large game room lie upstairs. Covered back patio.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 4 BLK 2 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265650' WHERE `Matrix_Unique_ID` = '212918732' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T21:55:50.087' ,`MLSNumber` = '63637855' ,`ListAgentFullName` = 'Angeline Clark' ,`ListOfficeName` = 'Monarch Real Estate & Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.500270' ,`Longitude` = '-95.395980' ,`PhotoCount` = '28' ,`PostalCode` = '77578' ,`RoomCount` = '12' ,`ListPrice` = '655400.00' ,`Status` = 'Active' ,`StreetName` = 'Palmero' ,`StreetNumber` = '9' ,`StreetSuffix` = 'Way' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3151' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SARATOGA HOMES NEW CONSTRUCTION NOW $115k off!! Two story, new construction home for sale in Manvel, TX with elongated foyer entryway. Our gourmet kitchen is a chef\'s dream kitchen with a large granite kitchen island, double ovens, and walk-in pantry. Formal dining room and separate breakfast area. Open-concept family room features a grandiose wall of windows and stone fireplace faces the kitchen where lasting memories will be made. Spacious primary retreat located on the first level boasts an enormous walk-in closet. Primary bath is the perfect oasis with his and hers vanities, separate soaking tub, and walk-in shower. Open to below catwalk makes it easy to keep an eye on the kids from the first level. Three secondary bedrooms. Reading loft, huge game room, and separate media room lie upstairs. Covered back patio. Our Hudson floor plan is the ULTIMATE floor plan for entertainer\'s!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Saratoga Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 4 BLK 1 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11299' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675265650' WHERE `Matrix_Unique_ID` = '212919730' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T21:50:20.810' ,`MLSNumber` = '55387075' ,`ListAgentFullName` = 'Victor Burks' ,`ListOfficeName` = 'Buyer First Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.538842' ,`Longitude` = '-95.391124' ,`PhotoCount` = '12' ,`PostalCode` = '77578' ,`RoomCount` = '8' ,`ListPrice` = '290990.00' ,`Status` = 'Active' ,`StreetName` = 'Spindletop' ,`StreetNumber` = '3306' ,`StreetSuffix` = 'Court' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2662' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 1 story home on cul de sac with huge backyard for pool or whatever the buyer desires. Home has 3 full baths and a 4th bedroom with French doors that can be a study/office.' ,`Acres` = '0.3' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHFORK SEC 1A (A0540 A C H & B) BLK 3 LOT 6' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '13068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '540' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'RED DUKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southfork Sec 1a-1b-1c-2a-2b-2' ,`TaxAmount` = '9070' ,`TaxRate` = '2.8294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265650' WHERE `Matrix_Unique_ID` = '213238001' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T22:28:28.627' ,`MLSNumber` = '61094593' ,`ListAgentFullName` = 'Patricia Woldtvedt' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = 'Cheyenne Perry' ,`SellingOfficeName` = 'Seaside Properties' ,`Latitude` = '29.475257' ,`Longitude` = '-95.167299' ,`PhotoCount` = '20' ,`PostalCode` = '77573' ,`RoomCount` = '6' ,`ListPrice` = '415000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sugar Trail' ,`StreetNumber` = '616' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with eye catching tray ceilings in the foyer as you enter. Fabulous kitchen overlooking the spacious living room with a large breakfast bar area with seating area, generous counter/prep space and tons of cabinet storage. The island with cabinets is centered in the kitchen with a fabulous Skylight above bringing in beautiful natural light throughout. Offers a dining room boasting with your very own Butlers Pantry with glass doors. \r\n3 bedroom 2.5 bath with a study/office space/flex room or 4th bedroom. Your own oasis awaits as you enter the primary bedroom with tray ceilings and luxurious ensuite. Bedroom overlooks a spacious backyard with no back neighbors, garden beds awaiting new owners to create their own masterpiece, a 8x10 shed for tools and a covered patio for relaxing or entertaining. 3 car garage for vehicles, recreational toys or additional space. Local community ponds, recreation center & pool for your enjoyment. Call now to schedule your showing!!' ,`Acres` = '0.1884' ,`Area` = '33' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 42 BLK 1 WESTWOOD SUB SEC 7 (2018) ABST 614' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8208' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Sub' ,`TaxAmount` = '10567' ,`TaxRate` = '3.0697' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265651' WHERE `Matrix_Unique_ID` = '214017035' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T21:35:07.957' ,`MLSNumber` = '57888893' ,`ListAgentFullName` = 'Judith Lowery' ,`ListOfficeName` = 'American Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.163298' ,`Longitude` = '-95.631482' ,`PhotoCount` = '25' ,`PostalCode` = '77486' ,`RoomCount` = '7' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Amherst' ,`StreetNumber` = '334' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enter into gated community of Columbia Lakes.Ideal for the golf enthusiast, fishing, swimming are just looking for lovely stately trees that offers a tranquil environment, this is the place to call home.Lovely entry guides you into large family room,unique white washed fireplace stunning wood floors,formal dining room.Chefs delight with gourmet kitchen, designer Porcelin backsplash,apron sink,prepping island,breakfast area.Enjoy reading your favorite book in the remodeled sunroom complimented with custom Spanish tile.Primary bedroom/bath offers tub, separete shower,large closets.Upstairs has two oversized bedrooms, updated bath,granite counter top,Tiled walk-in shower,office/game area.Relax on the treated wood deck patio with privacy nook,fenced area for pets.Two covered dog kennels on concrete pad behind detached garage.Updates include exteriior/interior paint,beautiful vinyl plank flooring.This home offers more value for your mortgage. Sq. Ft per owner . Veriify any measurements' ,`Acres` = '0.2114' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 3 (A0133 M VARNER) BLK 26 LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9209' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '5086' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265651' WHERE `Matrix_Unique_ID` = '214719423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-28T22:44:54.410' ,`MLSNumber` = '95141781' ,`ListAgentFullName` = 'Heather Lange' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.944303' ,`Longitude` = '-93.902030' ,`PhotoCount` = '25' ,`PostalCode` = '77619' ,`RoomCount` = '12' ,`ListPrice` = '350000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '2801' ,`StreetSuffix` = 'Lane' ,`City` = 'Groves' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2506' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step into this entertainer\'s dream located in PNG-ISD. This lovely home features welcoming columns, high ceilings, split floor plan, and an upstairs game room with a full bathroom that could be a 4th bedroom. The master bedroom has a partial wall for a quiet sitting area or an office. Lots of room to host plenty of guests for dinner; with a formal dining area, breakfast table area and a bar. The backyard has a covered patio and 2 areas for storage. This home is a must-see!' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 5 PLAZA TERRACE NO 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '233 - Port Neches-Groves' ,`SchoolElementary` = 'PORT NECHES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORT NECHES-GROVES HIGH SCHOOL' ,`SchoolMiddle` = 'GROVES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Plaza Terrace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675265651' WHERE `Matrix_Unique_ID` = '214823043' --> 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','215220181','1675265651','215220181','2023-01-28T22:19:12.113','48577880','David Weaver','Coldwell Banker Realty','','','29.479522','-95.533149','48','77459','6','489900.00','Active','Calm Channel','2343','Court','Missouri City','3','0','3','2484','Single-Family','WHY WAIT 8 MONTHS TO BUILD? Stunning 1-story 2020 Perry custom “SMART” home on cul-de-sac in Sienna! This Northeast facing home features Austin stone/brick with dark trim elevation and double iron doors for stunning curb appeal! The 12 foot entry welcomes you to an office/study with glass French doors, three bedrooms, three baths, open kitchen, dining and family room with a wall of windows. The chef’s kitchen is equipped with sleek upgrades such as granite countertops, 42\" custom cabinetry, glass tile backsplash, stainless appliances and gas cooktop with pot filler. Primary suite is perfect with wall of windows, spa-like bath with \'TEXAS SIZE\' shower and two walk-in closets. Extended backyard patio with TV (included) provides endless oasis possibilities. $40,000 in design center amenities includes foyer lighting, plantation shutters, custom drapery, tile flooring, exterior camera\'s, 3 car tandem garage with epoxy flooring. Two refrigerators, washer/dryer and home generator included.','','38','Perry Homes','','Electric Dryer Connections,Gas Dryer Connections','','Levee District,Mud,Sellers Disclosure','1','','','Sienna Area','Central Gas','1','Sienna Plantation Sec 16, BLOCK 2, Lot 13','Cul-De-Sac,In Golf Course Community,Subdivision Lot','7284','Appraisal District','','1428','0','','3','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','LEONETTI ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Contemporary/Modern','Sienna','10935','3.1629','Other Water/Sewer','2020','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','215220273','1675265652','215220273','2023-01-28T22:08:26.960','80075592','Shelby Crowe','Berkshire Hathaway HomeServices Premier Properties','','','29.601531','-95.112187','40','77059','9','436400.00','Active','Sweet Cicely','4322','Court','Houston','2','1','4','2728','Single-Family','*******VERBAL OFFER ACEPTED WAITING ON PAPERS TO BE SIGNED *******Welcome Home 4322 Sweet Cicely-Exquisite Single story in Pine Brook on cul-de-sac-Leaded Glass front door-Meticulously Brazilian Cherry Hardwood floors-NO CARPET-Crown Molding/chair rail-Split floor plan-office with French doors great windows for natural light-formal living-family/kitchen open floor plan-Gorgeous kitchen overlooking family room with fireplace-kitchen has a cooks recipe desk area plenty of storage-breakfast nook overlooking gorgeous courtyard with covered patio with slate flooring-Beautiful cabinets with abundance of storage-granite countertops-stainless steel appliances-corner pantry-oversized extended garage extra storage space-2 bedrooms share a Hollywood bath-primary bedroom separate from 3 secondary rooms-laundry room with window-Gated driveway with remote-sprinkler system-','0.2116','7','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace,Wood Burning Fireplace','1','Clear Lake Area','Central Gas,Zoned','1','LT 4 BLK 1 PINE BROOK SEC 5','Cul-De-Sac,Subdivision Lot','9216','Appraisal District','','635','0','','1','Gas Oven','0','','','Gas Cooktop','','Composition','9 - Clear Creek','BROOKWOOD ELEMENTARY SCHOOL','CLEAR LAKE HIGH SCHOOL','SPACE CENTER INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Seller','1','Ranch,Traditional','Pine Brook Sec 05','11064','2.5769','Public Sewer,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','215768574','1675265652','215768574','2023-01-28T22:31:26.790','89645303','Jessica Salinas','RE/MAX ONE - Premier','','','29.818775','-94.839122','35','77523','8','439000.00','Active','South River','13927','Drive','Baytown','2','1','4','2791','Single-Family','Beautiful two story, 4 bedroom, 2 and a half bath, 2 car garage in River Farms. This Thomas Kade home offers high ceilings with generous sized bedrooms. Wood like tile throughout and plush carpet in the bedrooms. Spacious kitchen, custom Noddy Alder wood cabinets, granite counter tops, stainless steel appliances. Open concept, kitchen with formal dining, kitchen open to living area and breakfast bar. Large living room with vaulted ceilings. Oversized primary bedroom, tons of natural light with large windows, and a massive walk in closet. Primary bath has soaking tub and standing shower. Game room on second floor. Oversized back patio perfect for entertaining or relaxing outdoors after a long day. Zoned to BHISD, near I-10, 1409, Grand Parkway 99, low tax rate, near shopping amenities. Call for your private showing!','0.178','53','THOMAS KADE','','Washer Connections','','No Disclosures','1','','','Chambers County West','Central Gas','1','LT 47 BLK 1 RIVER FARMS SEC 6','Subdivision Lot','7754','Appraisal District','','750','1','Never Lived In','2','Single Oven','0','','','Gas Cooktop','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Appointment Required,Lockbox Front','Builder','2','Traditional','RIVER FARMS','','1.656','Public Sewer,Public Water','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','215770346','1675265652','215770346','2023-01-28T21:54:56.923','774617','Jessica Salinas','RE/MAX ONE - Premier','','','29.819720','-94.821871','31','77523','6','369000.00','Active','Rain Cloud','631','Drive','Baytown','2','1','4','2235','Single-Family','Beautiful two story, 4 bedroom, 2 and a half bath, 2 car garage in Rain Tree. This Thomas Kade home offers high ceilings with generous sized bedrooms. Wood like tile throughout and plush carpet in the bedrooms. Spacious kitchen, custom Noddy Alder wood cabinets, granite counter tops, stainless steel appliances. Open concept, kitchen with formal dining, kitchen open to living area and breakfast bar. Large living room with high ceilings. Oversized primary bedroom, tons of natural light with large windows, and a massive walk in closet. Primary bath has soaking tub and standing shower. Back patio perfect for entertaining or relaxing outdoors after a long day. Zoned to BHISD, near I-10, 1409, Grand Parkway 99, low tax rate, near shopping amenities. Call for your private showing!','0.1805','53','THOMAS KADE','','Washer Connections','','No Disclosures','1','','','Chambers County West','Central Gas','1','LT 61 BLK 1 RAIN TREE SECTION 2','Subdivision Lot','7863','Appraisal District','','750','1','Never Lived In','2','Single Oven','0','','','','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','RAIN TREE','','1.656','Public Water','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','215875469','1675265652','215875469','2023-01-28T21:42:45.290','96922690','Renee Madera','CJM Realty Advisors','','','29.829217','-95.746758','14','77449','3','289000.00','Active','Crystal Pass','3914','Court','Katy','2','0','3','1710','Single-Family','Welcome to 3914 Crystal Pass Court, a beautiful single family dwelling located in a quiet residential neighborhood. This traditional-style home boasts 1710 square feet of living space and sits on a spacious 7,058 square foot lot. The interior of the home features neutral earth tones throughout, creating a warm and inviting atmosphere.\r\n\r\nThe property boasts a split floor plan, with the secondary rooms located at the front left side of the home and sharing a restroom. The family dining room is in the middle of the home, while the kitchen can be found at the back. The primary bedroom is located in the far right corner of the property, offering privacy and tranquility.\r\n\r\nThis 3-bedroom, 2-bathroom home is the perfect place to create lasting memories with your loved ones. The ample space and comfortable layout make it perfect for entertaining guests, or just relaxing after a long day. Don\'t miss your chance to own this wonderful home, schedule a showing today!','0.162','25','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Freestanding','1','Katy - North','Central Gas','1','LT 9 BLK 4 BRIDGEWATER POINTE SEC 1','Cul-De-Sac,Subdivision Lot','7058','Appraisal District','','490','0','','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','30 - Katy','GOLBOW ELEMENTARY SCHOOL','MORTON RANCH HIGH SCHOOL','MCDONALD JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Bridgewater Pointe Sec 01','5760','2.8233','Water District','1998','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','216179814','1675265652','216179814','2023-01-28T22:01:28.083','67748254','Kylee Garza','NextHome Realty Solutions BCS','','','30.686626','-96.244282','31','77808','9','689000.00','Active','Lonesome Dove','10734','Trail','Bryan','3','1','4','2854','Single-Family','Location, Location, Location! This house has it all! Minutes from town with the living in the country feel. Built in 2016 this house boast all the bells and whistles you have been looking for. Nestled on a one acre tract you wont have neighbors looking through your windows which allows for great privacy while enjoying the outdoors. Walking into the home you are greeted with an open concept kitchen and living with granite countertops, and island and tons of cabinet space! Perfect for entertaining guest any time of year! Primary room offers a small nook for an office or reading area, large walk in bathroom with multiple storage closets, walk in shower and huge tub! Other rooms offer privacy from one another without feeling crowed. Beautiful wood tile floors throughout help keep allergies down to a minimum. Make your appointment today to see this gorgeous home before its too late!','1.06','61','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','','Central Gas','1','HERITAGE LAKE ESTATES PH 2, BLOCK 2, LOT 47','Cleared,Subdivision Lot','46174','Appraisal District','','750','0','','2','Electric Oven','0','','','Gas Range','','Composition','148 - Bryan','SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)','BRYAN HIGH SCHOOL','STEPHEN F. AUSTIN MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Heritage Lake Estates Ph 2','9847','1.5945','Aerobic,Public Water,Septic Tank','2016','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','216368925','1675265652','216368925','2023-01-28T22:28:54.820','72584821','Jordyn Bosse','Compass RE Texas, LLC','Buddy Novak','RE/MAX Lake Livingston','30.616117','-94.871524','17','77351','3','315000.00','Option Pending','Wood','151','Haven','Livingston','2','0','3','1888','Single-Family','Come see this better-than-new farmhouse style home! Situated on just under half an acre, you\'ll love being able to see the private neighborhood lake from the front porch. Escape to peaceful country living in this waterfront community with a fully stocked pond. Less than 15 minutes from 59 and downtown Livingston, with an easy commute to The Woodlands or Kingwood! The natural light and open concept design flows between the formal dining space, living room, and kitchen island with granite countertops. Primary bedroom has gorgeous tray ceilings and ensuite bath with dual sinks, tub with separate shower, and a spacious walk-in closet with built ins. Move-in ready and easy to show! This home has been impeccably cared for and is ready for new owners! Schedule a private tour today!','0.4477','44','','','','','Sellers Disclosure','','','','Livingston Area','Central Electric','1','FOREST SPRINGS SECTION 1 BLK C LOT 23, 24 & 25','Subdivision Lot,Water View','19500','Appraisal District','','50','0','','2','','0','','','','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal','1','Contemporary/Modern,Other Style,Traditional','Forest Spgs Sec 1','3955','1.742','Public Water,Septic Tank','2021','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','216447339','1675265652','216447339','2023-01-28T21:42:20.673','68454680','Mansur Hussain','Hutaib USA','','','29.926754','-95.685443','45','77095','7','350553.00','Active','Marble Crest','10423','Drive','Houston','2','1','4','2530','Single-Family','Beautiful Clean home, accross from Mail Box, 2 years ago following were updated Stainless Steel Appliances, Granite Counter Top, Flooring on 1st Floor, Carpet and Engineered Wood, AC 3 years old, \r\nLeaded Glass Front Door, Island in Kitchen. Granite Counter Top in all Bathrooms.\r\nAll sides Brick, back fence is bricked\r\nJanuary 2023 New whole house painted and New carpet in all areas of 2nd Floor\r\nExtended Patio Concrete, Jacuzzi, Sprinklers. Builder PULTE HOMES. No Pets or Smokers One Owner\r\n\r\nBest Schools and area to live.','0.1247','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Copperfield Area','Central Gas','1','LT 24 BLK 1 CANYON LAKES VILLAGE SEC 3 AMEND','Subdivision Lot','5434','Appraisal District','','940','0','','2','Convection Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','WOODARD ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ARAGON MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Canyon Lakes Village Sec 03 Amend','6865','2.561','Water District','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','216452033','1675265652','216452033','2023-01-28T21:16:18.720','67553396','Wayne Comer','360 Realty & Management','','','29.897865','-95.723522','34','77433','4','320000.00','Active','Ranch Mill','20707','Lane','Cypress','2','1','4','2379','Single-Family','BEAUTIFUL LARGE 4 BEDROOM 2.5 BATH IN CYPRESS','0.1083','25','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Cypress South','Central Gas','1','LT 17 BLK 2 PINE CREEK AT CANYON LAKES WEST SEC 7','Subdivision Lot','4718','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','ANDRE ELEMENTARY SCHOOL','CYPRESS SPRINGS HIGH SCHOOL','ANTHONY MIDDLE SCHOOL (CYPRESS-FAIRBANKS)','Appointment Required','Appraisal District','2','Traditional','Pine Crk/Canyon Lakes West Sec 7','10308','3.041','Water District','2017','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','216561370','1675265652','216561370','2023-01-28T22:27:35.540','10922001','Virginia Price','Virginia Price Realty, LLC','Virginia Price','Virginia Price Realty, LLC','30.946891','-95.912762','40','77864','9','149000.00','Pending Continue to Show','Madison','402','Street','Madisonville','2','1','3','1638','Single-Family','You must see this adorable, remodeled and very spacious 3 bedroom, 2 1/2-bathroom home in downtown Madisonville. The home has new PVC plumbing throughout, central heat and air conditioning, ceiling fans, new flooring, large utility room with a pantry inside the home, and so much more. Walking distance from the courthouse, downtown shopping and restaurants. The backyard is fenced ready for your family pet. Hurry to schedule your showing today!','0.202','52','','','Electric Dryer Connections,Washer Connections','','No Disclosures','','','','Madisonville Area','Central Gas','0','MADISONVILLE TOWNSITE BLK 33 (PT) .202','Other','8800','Appraisal District','','','0','','0','','0','','','Electric Range','','Aluminum,Composition','175 - Madisonville Consolidated','MADISONVILLE ELEMENTARY SCHOOL','MADISONVILLE HIGH SCHOOL','MADISONVILLE JUNIOR HIGH SCHOOL','Appointment Required','Seller','1','Other Style','Madisonville Townsite','1640','2.2583','Public Sewer,Public Water','1950','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','216647803','1675265652','216647803','2023-01-28T22:44:46.423','32361833','Donny Luong','ABSOLUTE Realty Group Inc.','','','30.081060','-95.517441','34','77388','10','345990.00','Active','Menor Crest','6223','Drive','Spring','3','0','5','2690','Single-Family','Welcome home! This cozy 2-story FIVE-BEDROOM efficient open floor plan house can offer what you are searching for in your next home. It is recently updated with fresh new paint, new laminate flooring, and new roof in 2021. It has a secondary bedroom and full-bath downstairs, good for elderly parents. The island kitchen is open to a large living room and comes with 42\" cabinetry and tile backsplash. The upstairs primary bedroom suite is enormous with tray ceiling, a garden bath with dual sinks, separate tub/shower, and a walk-in closet. All the remaining bedrooms are upstairs. The highlight of this house is the massive, covered patio with two fans and recessed lighting. The house has 2,690 sq ft of living space. It was not flooded during Harvey. This could be your next home to build your memories here.','0.1319','14','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Spring/Klein','Central Gas','1','LT 15 BLK 1 NORTHCREST VILLAGE SEC 1','Subdivision Lot','5746','Appraisal District','','525','0','','2','Gas Oven','0','','','Gas Range','','Composition','32 - Klein','FOX ELEMENTARY SCHOOL','KLEIN OAK HIGH SCHOOL','HILDEBRANDT INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Northcrest Village Sec 1','7890','2.5053','Public Sewer,Water District','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','216682168','1675265652','216682168','2023-01-28T21:14:29.930','10268920','Yvonne Pruneda','Nan & Company PropertiesChristie\'s International R','Linh Luong','eXp Realty, LLC','29.708132','-95.613874','37','77072','9','224990.00','Option Pending','Garden Trail','6519','Court','Houston','2','1','3','1383','Single-Family','Discover the perfect blend of functionality and style in this 3 bedroom, 2.5 bath home. The first floor features a spacious living area, while all bedrooms are located on the second floor. The primary bedroom features an ensuite bathroom with a tub/shower combo, providing a private oasis for relaxation. Enjoy the outdoors with a covered back patio, perfect for entertaining. Additional features include ceiling fans, a gas range, refrigerator, and washer and dryer are included in the sale. This home is ready for you to make it your own','0.1008','28','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Alief','Central Gas','1','LT 24 BLK 1 BELLAIRE GARDENS SEC 2','Subdivision Lot','4389','Appraisal District','','185','0','','2','Gas Oven','0','','','Gas Range','','Composition','2 - Alief','MAHANAY ELEMENTARY SCHOOL','AISD DRAW','O\'DONNELL MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Traditional','Bellaire Gardens Sec 02','3771','2.3258','Public Sewer,Public Water','2002','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','216734733','1675265652','216734733','2023-01-28T21:56:27.730','10075879','Janet Vittur','Texas All American Real Estate','','','29.583551','-95.618016','28','77479','9','439900.00','Active','Greencove','2223','Lane','Sugar Land','2','0','3','2669','Single-Family','Pride in ownership describes this lovely home so come check out this beautiful home located in a great neighborhood close to shopping and schools. The curb appeal is outstanding and the backyard serves as an oasis of tranquility. The backyard backs up to a green belt that results in no backyard neighbors The Primary bedroom has a fireplace and lots of closet space. The upstairs loft can serve as another bedroom or game room. Updates include new carpet and paint as well as recent window and siding replacement along with a new electrical box. The slab has been repaired and has a transferable warranty.\r\nThe Agent is related to the seller','0.1641','29','','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','2','Sugar Land South','Central Gas','1','WOODSTREAM SEC 3, BLOCK 3, LOT 26','Subdivision Lot','7149','Appraisal District','','850','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','COLONY MEADOWS ELEMENTARY SCHOOL','CLEMENTS HIGH SCHOOL','FORT SETTLEMENT MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','1','Traditional','Woodstream Sec 3','7004','2.1584','Public Sewer,Public Water','1984','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','216826993','1675265652','216826993','2023-01-28T22:35:22.750','58598684','Bethany Laub','Live Better Realty Brokers','','','30.374637','-95.619341','44','77356','7','344000.00','Active','Cove Circle','116','Circle','Montgomery','2','0','2','1903','Single-Family','Don\'t miss seeing this April Sound custom one owner home.This well maintained home boasts a 2bedroom 2 bath with a flex room upstairs. This custom home features an open floor plan with high ceilings. The large primary suite with sitting area over looking the spacious backyard. Notice the custom walk-in closet and soaking tub plus separate shower. Living area has built ins & a custom stone fireplace, The backyard patio is private and oversized. The sellers purchased the extra space so the Apprasial district does not reflect the correct square footage. The home is located on a corner lot. There is a recent updated roof and HVAC. Ready for immediate move in! This pristine 1 1/2 story features spacious rooms, custom designed for a flowing floor plan. The upstairs area can be used a flex room for office, bedroom, game room and or storage.The owners purchased more property to extend the patio not reflected on listing. The closets in this home is ready for storage.','0.1149','39','','','Electric Dryer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Lake Conroe Area','Central Electric','1','APRIL SOUND 08, BLOCK 43, LOT 1, 1-A, ACRES 0.1149','Corner','5005','Appraisal District','','234','0','','2','Freestanding Oven','0','','','Electric Range','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Supra Keybox','Appraisal District','1','Traditional','April Sound 08','5305','2.2625','Water District','1998','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','216846264','1675265652','216846264','2023-01-28T21:54:34.197','4689761','Natasha Simon','Keller Williams Realty - Memor','','','29.482374','-95.454991','1','77583','7','293400.00','Active','Mariquita','1227','Lane','Rosharon','2','0','4','1637','Single-Family','READY FOR MOVE IN! This beautiful 1 story Clover plan by Saratoga Homes includes 4 bedrooms, 2 full baths, separate tub and shower and an oversized island with open concept. This plan also features a covered porch along with a patio as well. This home is zoned to the prestigious Ridge Point High School and has an elementary in the community. Call today for your showing!','0.1282','38','Saratoga Homes','','Electric Dryer Connections,Washer Connections','','Other Disclosures','','','','Sienna Area','Central Gas','1','GLENDALE LAKES SEC 9, BLOCK 2, LOT 23','Subdivision Lot','5586','Appraisal District','','550','1','Never Lived In','2','Electric Oven','0','','','Gas Range','','Composition','19 - Fort Bend','HERITAGE ROSE ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required','Builder','1','Traditional','Glendale Lakes Sec 9','1291','3.1129','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','216849869','1675265652','216849869','2023-01-28T21:24:54.083','19562429','Juan Barron','RE/ImageProperties and Investm','','','29.485711','-95.232399','3','77511','3','120000.00','Active','Hastings','19905','Circle','Alvin','2','0','3','1064','Single-Family','Possibilities are endless with this land. Mobile home is a tear down. Unrestricted property.','0.8','5','','','','','Sellers Disclosure','','','','Alvin North','Central Electric','0','A0595 H STEVENS TRACT 4A7 (PT) ACRES 0.8','Other','34848','Appraisal District','','','0','','','','0','','','','','Composition','3 - Alvin','MARK TWAIN ELEMENTARY SCHOOL (ALVIN)','ALVIN HIGH SCHOOL','G W HARBY J H','No Appointment Required','Appraisal District','1','Other Style','H Stevens','1580','2.1187','Septic Tank','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','216850598','1675265652','216850598','2023-01-28T21:40:15.877','20252220','Juan Arrieta','Elite Texas Properties','','','18.044812','-66.643630','15','00733','4','400000.00','Active','Granada Hills','5-B','Street','Ponce','2','1','4','1971','Single-Family','Beautiful and spacious hilltop property in Ponce, Puerto Rico. Remodeled inside and out, it features a fully-independent solar panel system and diesel-power generator for self-reliability and peace-of-mind. It offers plenty of room with four comfortable bedrooms, 2.5 baths, and ample kitchen with breakfast bar, dining, and living room. \r\nRelax in the open terrace with ocean views and sparkling swimming pool and make this your own private oasis. Contact listing agent for more information and to schedule a showing today. Room sizes provided are estimates based on seller\'s measurements; buyers must independently verify.','','','','','','','No Disclosures','','','','','Solar Assisted','0','Calle 5-B, Granada Hills Development, Ponce, PR 00733','Subdivision Lot,Water View','25973','Appraisal District','','','0','','0','','1','In Ground','','','','Other','','','','','Appointment Required,Request Online Appointment','Appraisal','1','Other Style','Granada Hills','','','Septic Tank','1969','Appraisal'); --> New record created successfully